EasyXLS is an API to import, export and convert MS Excel files without Microsoft Excel installed from various programming languages. The Excel library is used for creating, reading and manipulating MS Excel files, including support for advanced features like formatting, formulas, charts, macros, images and pivot tables.
EasyXLS for .NET is compatible with C#, VB.NET, C++.NET, ASP.NET web pages, Windows Forms or Windows Services and Python.
EasyXLS for COM+ is compatible with all programming languages that support COM technology like PHP, Clasic ASP, C++, VB6 or VBScript.
EasyXLS for Java is compatible with Java, ColdFusion, Python, PHP, Java Server Pages or Java Server Faces.
EasyXLS library is designed to be easy to use, with a straightforward API and comprehensive documentation. It is also highly performant, with optimized algorithms for handling large Excel files.
- Create Excel files, new files or from Excel templates
- Import Excel data, modify Excel file and resave the file
- Convert Excel files, between MS Excel file formats (XLSX, XLSM, XLSB, XLS and SpreadsheetML) and also text formats (HTML, XML, CSV and TXT).
- Format cells, rows, and columns with background, foreground, fonts, borders, alignments, number and date formats and other formatting elements. Conditional formatting is also supported.
- Multiple sheets
- Complex formulas and functions, named ranges and formulas, formula calculation engine included
- Hyperlinks, comments and images
- Data validation for cell values, including drop-down selection
- Print options and page breaks
- Group rows and columns, split and freeze panes, filter and auto-filter
- Charts with various supported types and formatting
- Pivot tables and pivot charts
- Encryption and password protection to protect the Excel file from unauthorized access, protect sheet data inside sheet from altering
- VB code and macros preservation
- File properties with details about the author and company that generated the Excel file or custom properties
- Import/export from data structures, SQL databases, lists of data, export DataTable to Excel, import Excel to DataTable, import/export from GridView or DataGridView, import/export ResultSet to Excel
MS Excel Open XML: XLSX, XLSM
MS Excel Binary: XLSB, XLS
XML: SpreadsheetML, XML specific schema
Web: HTML, mso attributes, CSS
Text: CSV, TXT
Download EasyXLS from nuget.org and execute below line in Package Manager Console from Visual Studio:
Install-Package easyxls.professional
or search for EasyXLS in NuGet Package Manager in Visual Studio and install.
Generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.
Setup the license file into your project using the guidelines.
You can execute the code below in C# to create an Excel file having two sheets and a value set in "A1" cell.
// Create an instance of the class that creates Excel files, having two sheets
ExcelDocument workbook = new ExcelDocument(2);
// Get the table of data for the first sheet
ExcelTable xlsTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable();
// Add data in A1 cell
xlsTable.easy_getCell("A1").setValue("Hello world!");
// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx");
Download installer from easyxls.com and run the setup.
Generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.
Setup the license file into your project using the guidelines.
You can execute the code below in PHP to create an Excel file having two sheets and a value set in "A1" cell.
// Create an instance of the class that creates Excel files
$workbook = new COM("EasyXLS.ExcelDocument");
// Create two sheets
$workbook->easy_addWorksheet_2("First sheet");
$workbook->easy_addWorksheet_2("Second sheet");
// Get the table of data for the first worksheet
$xlsTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable();
// Add data in A1 cell
$xlsTable->easy_getCell("A1")->setValue("Hello world!");
// Create Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Excel file.xlsx");
Download JAR file from easyxls.com.
Generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.
Setup the license file into your project using the guidelines.
You can execute the code below in Java to create an Excel file having two sheets and a value set in "A1" cell.
// Create an instance of the class that creates Excel files, having two sheets
ExcelDocument workbook = new ExcelDocument(2);
// Get the table of data for the first sheet
ExcelTable xlsTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable();
// Add data in A1 cell
xlsTable.easy_getCell("A1").setValue("Hello world!");
// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Excel.xlsx");
EasyXLS website provides detailed information on how to use the various features and functionalities of the EasyXLS library, including a complete User Guide, tutorials, demos, and API documentation.
Product Page / Trial License / Getting Started / Tutorials / Documentation / FAQ / Support