Encoding for CSV, TXT and HTML files
EasyXLS will allow setting a custom character encoding like Unicode, ASCII, UFT-8 and UTF-32 when reading or writing CSV, TXT or HTML files.
The feature was already available for XLS, XLSX, XLSM and XLSB file formats and now was extended to text file formats.
The countries that use Greek alphabet, Cyrillic alphabet, Han script or special Latin characters will be able now to use the full functionality of our Excel library.
Format data labels for charts
EasyXLS will allow setting the data labels properties like:
- label position
- number format
- fill settings (no fill, solid fill, gradient fill, picture or texture fill, automatic)
- border color (no line, solid line, gradient line, automatic)
- border style (width, compound type, dash type, cap type, join type)
- shadow settings (presets, color, transparency)
- font settings (font name, font size, foreground, alignment)
- 3-D format settings(bevel, surface, lighting)
Best Features
EasyXLS covers all the major features that a Microsoft Excel file has, for all Excel file formats like XLS, XLSX, XLSM, XLSB and common file formats like XML, HTML, CSV and TXT.
EasyXLS can be used from:
- C#, VB.NET, J#, C++.NET or any other .NET compatible software
- PHP, ASP, C++, VB6, VBS or other software that supports COM technology
- JAVA, JSP, JSF, ColdFusion or any other software that can be integrated with Java
For the complete list of features please check the presentation brochure.
Best Performance
EasyXLS works without Microsoft Excel. It is faster than OLE Automation and handles very well large Excel files with a big volume of data.
Best Support
EasyXLS provides the best quality support to his customers. 24 hours of customer support including emails and phone calls.
EasyXLS version 8.4 comes with a 64bit installer that includes 64bit DLLs for .NET.
The release is meant to help our clients who have 64bit applications only, or who want to avoid the DLL hell of mixing 32bit and 64bit in a single application.
Another advantage is that the speed of execution is improved given the fact that the emulation is avoided.
A trial version can be found here.
The customers who purchased the 8.4 version or own the 8.4 version on subscription base can find the 64bit installer under Purchase Items section.
1. EasyXLS 8.4 suite is now out.
For more details visit our products page:
www.easyxls.com/products
Please visit the purchase page in order to get the latest version:
www.easyxls.com/purchase
New features:
- Preserves macros between xlsx, xls, xlsb and any combination of files
- Pivot tables
- Pivot charts
- Comments with rich text
- Formula calculation improvements: iterative calculation for circular references
- Extracts the image bytes from an Excel file
- Show/Hide worksheet gridlines
Note: For more details about the supported features please check the following document:
Detailed Specifications Sheet
2. 2-year subscription.
EasyXLS offers two year subscription with upgrade protection that includes two years of email/phone questions and answers including all patches, as well as all major version upgrades during the subscription. At least one major version upgrade is guaranteed even if the subscription has expired.
All major version upgrades and patches are free during the 2-year subscription.
If you have already purchased an earlier version, you can buy the subscription and you will receive the latest version and all new versions for the next 2 years.
EasyXLS Trial v8.4 released!
For download visit:
www.easyxls.com/trials
New features:
- Preserves macros between xlsx, xls, xlsb and any combination of files
- Pivot tables
- Pivot charts
- Comments with rich text
- Formula calculation improvements: iterative calculation for circular references
- Extracts the image bytes from an Excel file
- Show/Hide worksheet gridlines
Note: For more details about the supported features please check the following document:
Detailed Specifications Sheet
Bug fixes:
- xlsx: load shared formulas
- xlsx: load formulas containing union or concatenate range operators
- xlsx, xlsb: read-only images
- hyperlinks with https protocol
- formulas with a string containing quotes and separators at the same time
- formulas containing functions with no parameters
- formulas containing local names referred to in other sheets
Pivot tables and pivot charts
One of the most wanted features is now available. EasyXLS will allow you to create and handle pivot tables and pivot charts. Create a columnar report, set the source range for the pivot report, set the row and column headings, choose an auto format and a pivot table or pivot chart is available in a preferred look and feel.
Macros
EasyXLS will allow you to load an xls, xlsx or xlsb file that contains macros, add more data to the file and resave the file in any of the MS Excel file format. The macro will be preserved.
Comments
The rich text format for comments will be available in the next version. The RTF text is handled in a similar way as the cell RTF text, by means of HTML tags.
Formulas with circular references
The formulas that contain circular references are identified and can be calculated more accurately using an iterative calculation algorithm having a custom precision.
Images improvement
After loading an Excel file, the image bytes of an image inside the document can be extracted and used for particular purposes.
1. EasyXLS 8.3 suite is now out.
For more details visit our products page:
www.easyxls.com/products
Please visit the purchase page in order to get the latest version:
www.easyxls.com/purchase
New features for xlsx and xlsb files:
o Cell formatting full support:
- Alignment – text direction
- Diagonal borders
- Gradient fill
- Set colors as theme colors
- Set font as theme font
o Conditional formatting full support:
- Set colors as theme colors
- Set font as theme font
o Chart formatting full support:
- Fill settings for chart elements
- Border color settings for chart elements
- Border style settings for chart elements
- Shadow settings for chart elements
- 3-D format settings for chart elements
- Font settings for chart elements
o Images:
- GIF, PNG, WMF, EMF, BMP, TIFF images
All the new features maintain the compatibility for xls file.
Note: For more details about the supported features please check the following document:
Detailed Specifications Sheet
2. 2-year subscription.
EasyXLS offers two year subscription with upgrade protection that includes two years of email/phone questions and answers including all patches, as well as all major version upgrades during the subscription. At least one major version upgrade is guaranteed even if the subscription has expired.
All major version upgrades and patches are free during the 2-year subscription.
If you have already purchased an earlier version, you can buy the subscription and you will receive the latest version and all new versions for the next 2 years.
EasyXLS Trial v8.3 released!
For download visit:
www.easyxls.com/trials
New features for xlsx and xlsb files:
o Cell formatting full support:
- Alignment – text direction
- Diagonal borders
- Gradient fill
- Set colors as theme colors
- Set font as theme font
o Conditional formatting full support:
- Set colors as theme colors
- Set font as theme font
o Chart formatting full support:
- Fill settings for chart elements
- Border color settings for chart elements
- Border style settings for chart elements
- Shadow settings for chart elements
- 3-D format settings for chart elements
- Font settings for chart elements
o Images:
- GIF, PNG, WMF, EMF, BMP, TIFF images
All the new features maintain the compatibility for xls file.
Note: For more details about the supported features please check the following document:
Detailed Specifications Sheet
1. EasyXLS 8.2 suite is now out.
For more details visit our products page:
www.easyxls.com/products
Please visit the purchase page in order to get the latest version:
www.easyxls.com/purchase
New features:
- Formulas containing Analysis ToolPak Add-In functions (more than 130 new financial, date & time, math & trig, statistical, lookup & reference, text, logical, information and engineering functions)
- Formulas containing BAHTTEXT, IFERROR, COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS functions
- Formula computation optimization
- Numeric arrays of values for chart series
- Themes for xlsx and xlsb files
Note: For more details about the supported functions please check the following document:
Detailed Specifications Sheet
2. 2-year subscription.
EasyXLS offers two year subscription with upgrade protection that includes two years of email/phone questions and answers including all patches, as well as all major version upgrades during the subscription. At least one major version upgrade is guaranteed even if the subscription has expired.
All major version upgrades and patches are free during the 2-year subscription.
If you have already purchased an earlier version, you can buy the subscription and you will receive the latest version and all new versions for the next 2 years.