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
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.
EasyXLS Trial v8.2 released!
For download visit:
www.easyxls.com/trials
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
Bug fixes:
- xls: loading hidden sheets
- xlsx: loading the formatting settings (font, fill, border, alignment and protection)
The calculation engine was improved with more than 130 new functions, including financial, date & time, math & trig, statistical, lookup & reference, text, logical, information and engineering functions. The functions of Analysis ToolPak Add-In will be fully supported.
The appearance and the formatting of a document can be changed by using a theme. With the help of EasyXLS the user will be able to create, edit and set a theme to an xlsx or xlsb document. The formatting includes a color scheme, a font scheme and an effect scheme, that offers a modern look for the Excel document.
For latest news please subscribe to newsletter.
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.
EasyXLS Trial v8.1 released!
For download visit:
www.easyxls.com/trials
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
Bug fixes:
- xls: read empty strings
- xlsx: reading strings with phonetic settings
- set/get basic file properties if no section is present
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