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 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
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
Export DataGrid to Excel file in C# and VB.NET quick and effortless!
http://www.easyxls.com/manual/FAQ/export-datagrid-to-excel.html
I’m building my code a few kilometers away from Dracula’s Castle. It’s night. The full moon is up on the black sky. No star is shining up there. I hear a voice whispering in my ears. You have a BUUUUUG! I’m looking at my code. I see a black spot. The bug is THERE! But suddenly the bug is running away. It’s hiding deep into the darkness of my code. I’m trying to find it again. I’m debugging and debugging…I don’t know where it’s hiding. The night is almost over and the light will be here soon. I’m frustrated and I’m calling a friend to help me. The first sun ray is shining. I’m trying desperately to show him what the problem is. But, as if by miracle everything works just fine!
How many times has this happened to you?
EasyXLS & EU Outsourcing teams won the 1st and 2nd place on the Inter-Company Cross! Great team spirit! Congratulations!
EasyXLS Excel library makes easier the export of Excel reports in XLSX file format.
The Excel reports can be formatted to have an attractive look, exactly in the preferred mode, or one of the predefined looks can be selected.
The Excel library works without Excel installed and without Interop and it is perfect to be used from server environments or desktop applications.
Data structures like GridView, DataGridView, DataGrid, DataTable, DataSet, JTable and ResultSet can be exported to XLSX file with one single line of code.
EasyXLS can be used from programming languages like C#, VB.NET, C++.NET, J#, Java, PHP, ASP classic, C++, VB6, VBS or ColdFusion.
EasyXLS allows not only the export of data and formatting, but also offers other Excel features like conditional formatting, data validation, comments, images and print options.
Moreover, the data can be exported as charts, pivot tables or pivot charts.
The data can be protected with password and the Excel file can be encrypted.
The export of XLSX file is fast, so it is the best solution for exporting large xlsx files.
Read more details on how to export data to xlsx file in C#, VB.NET, Java, C++, PHP.
It’s never been easier. EasyXLS Excel library provides methods for exporting the DataSet to Excel with one single line of code.
See more details and code samples about how to export DataSet to Excel in C# and VB.NET.
Export SQL data to Excel using C# or VB.NET
EasyXLS makes it easy to take out data from database and export data to Excel in XLS and XLSX file formats. The data can be arranged in nice formatted reports. The component allows you to export data from any database, including MS SQL Server or MySQL.
Export to Excel in ASP.NET from DataSet
EasyXLS component can be used from ASP.NET web applications. If the data is displayed in a GridView, see export GridView to Excel in ASP.NET.
Export data from DataSet to Excel in C# and VB.NET from windows application
EasyXLS component can also be used from WinForms and windows applications. If data is displayed in a DataGridView, see how to export DataGridView to Excel in C#.
Export DataSet to Excel Open XML
EasyXLS supports Open XML file format and allows the export of XLSX files. It also supports XLSM and XLSB files.
Export DataSet to Excel 2003
EasyXLS supports Excel 2003 file format and allows the export of XLS files. It also supports XML Spreadsheet, CSV, TXT and HTML files.
ALL WITHOUT MS Excel installed, WITHOUT Interop!