Mar
16
Posted on 16-03-2015
Read Excel file in C# and VB.NET!
Filed Under (ASP classic, ASP.NET, C#, C++, EasyXLS, Eu Outsourcing, Excel, Features, Java, PHP, VB.NET, XLS, XLSB, XLSM, XLSX) by Oana

Read Excel file in C# and VB.NET.

Read Excel file in C# and VB.NET. Read entire sheet data or only data from a range of cells.

‪http://www.easyxls.com/manual/FAQ/read-excel-file-in-dot-net.html

(0) Comments    Read More   
Mar
02
Posted on 02-03-2015
Import Excel file to List in C#, VB.NET, Java, PHP, C++ and other programming languages!
Filed Under (ASP classic, ASP.NET, C#, C++, EasyXLS, Eu Outsourcing, Excel, Features, Import, Java, News, PHP, VB.NET, XLS, XLSB, XLSM, XLSX) by Oana

Import file to List in C#, VB.NET, Java, PHP, C++

Import Excel file to List in C#, VB.NET, Java, PHP, C++ and other programming languages! The entire sheet data or only data from a range of cells can be imported.

‪http://www.easyxls.com/manual/basics/import-excel-to-list.html

(0) Comments    Read More   
Feb
16
Posted on 16-02-2015
Import data from XLSM file in C#, VB.NET, Java, PHP, C++
Filed Under (ASP classic, ASP.NET, C#, C++, Excel, Import, Java, PHP, SQL, VB.NET, XLSM) by Oana

Import data from XLSM file in C#, VB.NET, Java, PHP, C++

EasyXLS is an Excel component that facilitates the import of XLSM files in applications written in C#, VB.NET, Java, C++, PHP or ASP classic.

The XLSM file format is the Microsoft Excel 2007-2013 file format for Excel files with macros included.

Using EasyXLS, you can import Excel data into GridView, DataGridView, DataGrid, DataTable, DataSet, List, JTable or ResultSet data structures with one single line of code.

Also, the imported Excel data can be inserted in databases like SQL Server, MySQL, Oracle or MS Access.

The data can be imported from specific sheets or from ranges of Excel cells inside a sheet.

Furthermore, EasyXLS component handles very well big volume of data. Large Excel files can be imported with less memory consumption and at a reasonable speed.

Besides the data inside the XLSM file, other information from the Excel file can be imported including cell formatting, hyperlinks, images, formulas, charts or pivot tables.

EasyXLS can be integrated in .NET applications like ASP.NET web application (inclusive MVC), WinForms or console applications.

EasyXLS can also be incorporated in Java applications or servlets, C++ applications (MFC), PHP or ASP classic web pages.

Check code samples about how to import data from xlsm file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Nov
24
Posted on 24-11-2014
Export large Excel file in C#, VB.NET, Java, C++, PHP and other programming languages
Filed Under (ASP classic, C#, C++, DataSet, DataTable, Excel, Export, GridView, Java, PHP, ResultSet, VB.NET, XLS, XLSB, XLSM, XLSX) by Oana

Export large data to Excel in C#, VB.NET, Java, C++, PHP and other programming languagesEasyXLS 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:

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.

(0) Comments    Read More