EasyXLS in an Excel library for C# and VB.NET that can be used to import Excel files in C# or VB.NET applications, like ASP.NET web application (including MVC), WinForms applications or console applications.
The Excel library works without Excel installed and without OLEDB. It is not dependent on other additional software.
Great tips about importing Excel files using EasyXLS can be found on the following links:
EasyXLS allows the import of Excel data or any other information contained inside the Excel file.
This Excel library allows the importing of XLSX, XLS, XLSM or XLSB file formats for Microsoft Excel 97, 2003, 2007, 2010 and 2013.
The imported Excel files can have one sheet or multiple sheets. It also permits the import of ranges of Excel data.
EasyXLS can be used from ASP.NET applications and this code sample about how to import Excel to GridView in ASP.NET is handy.
EasyXLS can be also used from WinForms and this code sample about how to import Excel to DataGridView in C# or VB.NET is practical.
For importing Excel data to a more general data structure this code sample about how to import Excel to DataTable in C# and VB.NET is more useful.
Another common situation is related to Excel files and databases. This code sample shows how to import Excel data to SQL database in C# and VB.NET.
Import Excel file to DataTable in C# and VB.NET. The entire sheet data or only data from a range of cells can be imported.
http://www.easyxls.com/manual/FAQ/import-excel-to-datatable.html
Import Excel data to DataGrid from Excel sheet or from ranges of cells!
http://www.easyxls.com/manual/FAQ/import-excel-to-datagrid.html
Import Excel data to GridView in C# and VB.NET! The entire sheet data or only data from a range of cells can be imported.
http://www.easyxls.com/manual/FAQ/import-excel-to-gridview.html
Import Excel data to DataGridView, in C# and VB.NET, from an Excel sheet or from the active Excel sheet.
http://www.easyxls.com/manual/FAQ/import-excel-to-datagridview.html
EasyXLS Excel library makes possible the import of Excel file into SQL tables without OLEDB engine.
The Excel library can be used from WinForms or ASP.NET web applications that uses MS SQL Server, MySQL, MS Access, Oracle or any other database.
The data that can be imported from Excel file might be from XLSX, XLS, XLSM or XLSB files.
EasyXLS permits the import of data from entire Excel sheet or only from a range of cells.
See source code samples and more details about how to import Excel to SQL table in C# or VB.NET.
Import Excel file to DataSet in C# or VB.NET! Learn how to do it and save valuable time with EasyXLS!
http://www.easyxls.com/manual/basics/import-excel-to-dataset.html
EasyXLS is an Excel component that can be used to export Excel files programmatically. It also permits the export of large amount of data to Excel file.
EasyXLS is an optimal solution to:
- export large volume of data from MS SQL, MySQL, MS Access, Oracle database
- export large GridView to Excel
- export large DataSet to Excel
- export large DataTable to Excel
- export large ResultSet to Excel
The Excel component supports all MS Excel file formats: XLSX, XLS, XLSM, XLSB and XML Spreadsheet. The below links explains with source code samples how to export data to these file formats:
- How to export data to XLSX file format?
- How to export data to XLS file format?
- How to export data to XLSM file format?
- How to export data to XLSB file format?
However, the recommended file format for large Excel files is the binary format like XLSB or XLS formats. Binary files are faster by default.
For a fast export and better memory management, some steps must be followed. Check the below link for more technical details:
How to export large Excel file?
The Excel component can be used from C#, VB.NET, C++.NET, PHP, ASP classic, C++, Java, VBS, VB6 or ColdFusion.
Export DataGrid to Excel file in C# and VB.NET quick and effortless!
http://www.easyxls.com/manual/FAQ/export-datagrid-to-excel.html
EasyXLS is an Excel component that can be included in any C#, VB.NET or Java application.
Furthermore, it includes a .NET built DLL which is a COM+ library, that can be used from PHP, ASP classic, C++, VB6 or any other language that supports COM technology.
By including EasyXLS into your application, you can export Excel files that include macros or VBA code. The component supports XLSM file format, but, it also supports the older XLS format or the XLSB binary format.
EasyXLS preserves macros when the Excel file is loaded through the component. After working with loaded data or adding more data, the Excel file can be exported as XLSM file format or XLS, XLSB file.
For more technical details, read further how to export data to XLSM file.
EasyXLS can be used from any of the following environment and even more:
.NET version
- ASP.NET web pages
- Windows applications
- Windows Forms (WinForms)
- Console applications
- Windows service applications
- ASP.NET MVC web applications
COM+ version
- PHP web applications
- ASP classic web pages
- C++ applications
- MFC applications
- VB6 applications
- VBS scripts
Java version
- Java applications
- Java servlets
- ColdFusion web applications