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.
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.
Our Goal – “Being number one”
Over the last thirteen years, our team has strived to become the market leader by offering the best features, best compatibility, best performance, and best support possible. EasyXLS is determined to create the best Excel file programming library.
Our Vision – “Client always comes first”
We seek to understand our clients’ needs and we are focused on our clients’ success. EasyXLS grows on the clients’ requirements and requests. When the priority support clients encounter a problem, we work together to either find a solid workaround or our team provides a hot patch. EasyXLS provides to our customers the highest quality support.
Our Mission – “Difficult report? Easy task!”
What looks difficult or even impossible has never been easier! EasyXLS provides a tool for handling MS Excel file formats. The component offers an API for loading and saving reports from/to xls, xlsx, xlsb and even more file formats. Our 24 hour support team is always ready to answer to the clients’ questions when things become more difficult.
Our Objective – “Best coverage”
We plan to cover all MS Excel features. When Microsoft launches a new feature, EasyXLS is right behind. Our team puts its experience to work to ensure the best coverage. EasyXLS extends the supported features based on a release cycle of about 3-4 months. As a result, a 2-year subscription option comes to support this action. At least one major version upgrade is guaranteed even if the subscription has expired.
Follow us on our social networks:
Facebook Google+ Twitter LinkedIn
Help us to improve ourselves. Please fill in the survey.
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.
The previous version introduced the themes for MS Excel 2007-2010 files. The future version will come with an API that will dynamically allow setting the colors and fonts for cells, conditional formatting and chart elements, accordantly to a specific theme. Furthermore, the cell formatting will be improved with diagonal borders and gradient fill settings and the chart will have full formatting support for fill, border, shadow, 3D and font settings. All those new features, that complete the formatting of an Excel file, come as natural upgrade to MS Excel 2007-2010 new formatting features. All the new features maintain the compatibility for xls file in a similar way that MS Excel does.
Related to images, EasyXLS supported only JPEG format until now. Starting with the next version, the GIF, PNG, WMF, EMF, BMP, TIFF images will be also supported for xlsx and xlsb files.
For latest news please subscribe to newsletter.
EasyXLS is running a holiday sale until January 1st, 2013. All products, bundles and support options have a 20% discount.
Don’t hesitate and take full advantage of the best prices on the market!
As always, all our products come with a 30 day Money Back Guarantee.
Check out EasyXLS website for all our latest sale offers.
Happy Holidays and warm winter wishes for an enchanted holiday season!
EasyXLS Team
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.
1. EasyXLS 8.1 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:
- Password protection for the sheets
- Password protection for the workbook
- Password to open and password to modify for the xls, xlsx and xlsb files
- Encrypted xls, xlsx and xlsb files
- Search in cells
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.
In this article, I will focus on the export feature of EasyXLS component.
The component lets you export any Microsoft Excel file format like XLS, XLSX, XLSB, CSV, TXT, XML and even HTML files.
Microsoft Excel is not required to be installed on the machine that runs EasyXLS library, so you can save lots of money on the Microsoft Office server license you will be avoiding the nightmares caused by OLE Automation (OLE/ADO). The resources used are minimal, reducing the server load.
EasyXLS for .NET is compatible with any .NET programming language: C#, VB.NET, J#, C++.NET. It also includes a COM+ extension that widens the compatibility to include ASP, PHP, C++, VB6, VBS or any other language that supports COM technology. The only requirement is the installation of .NET Framework 1.1 or later, which is free and lately comes preinstalled in Windows operating system..
EasyXLS for Java is designed to cover all non Windows operating systems like Linux, MacOS, HP-UX, Solaris and others. JRE 1.4 or later installation is required.
I am posting a piece of code to show how easy it is to export an XLS file and get a nice look for your report. I chose C# as programming language. This sample extracts the data from a SQL database and generates an Excel file based on the dataset. The XLS file is generated in one line of code.
using System;
using System.Data;
using EasyXLS;
using EasyXLS.Constants;
public class Tutorial1
{
[STAThread]
static void Main()
{
Console.WriteLine("Tutorial 1\n-----------\n");
// Create an instance of the object that generates Excel files
ExcelDocument xls = new ExcelDocument();
// Create the database connection
String sConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(sConnectionString);
sqlConnection.Open();
// Create the adapter used to fill the dataset
String sQueryString = "SELECT TOP 100 CAST(Month(ord.OrderDate) AS varchar)+'/' + CAST(Day(ord.OrderDate) AS varchar) + '/' + CAST(year(ord.OrderDate) AS varchar) AS 'Order Date', " +
" P.ProductName AS 'Product Name', O.UnitPrice AS Price, O.Quantity , O.UnitPrice * O. Quantity AS Value" +
" FROM Orders AS ord, [Order Details] AS O, Products AS P WHERE O.ProductID = P.ProductID AND O.OrderID = ord.OrderID";
System.Data.SqlClient.SqlDataAdapter adp = new System.Data.SqlClient.SqlDataAdapter(sQueryString, sqlConnection);
// Populate the dataset
DataSet ds = new DataSet();
adp.Fill(ds);
// Generate the file
Console.WriteLine("Writing file C:\\Samples\\Tutorial1.xls.");
xls.easy_WriteXLSFile_FromDataSet("c:\\Samples\\Tutorial1.xls", ds, new ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1), "Sheet1");
// Confirm generation
String sError = xls.easy_getError();
if (sError.Equals(""))
Console.Write("\nFile successfully created. Press Enter to Exit...");
else
Console.Write("\nError encountered: " + sError + "\nPress Enter to Exit...");
// Close the database connection.
sqlConnection.Close();
// Dispose memory
xls.Dispose();
ds.Dispose();
sqlConnection.Dispose();
adp.Dispose();
Console.ReadLine();
}
}
Of course, you can export any other type of data; its source doesn’t have to be from a database. EasyXLS covers most of the features supported by Microsoft Excel. You can add hyperlinks, comments, images, charts and many more.
The next link will provide you with more samples and you can discover how to create complex Excel files using the library:
http://www.easyxls.com/manual/index.html
A presentation brochure is available at:
http://www.easyxls.com/docs/EasyXLS_DetailedSpecificationsSheet.pdf
If you are interested and want more details about the library, you can find more information on the following website:
http://www.easyxls.com