Jan
19

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

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

The XLS file format is the old binary format used by Microsoft Excel 97-2003.

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 XLS 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 xls file in C#, VB.NET, Java, C++, PHP.

(0) Comments    Read More   
Post a Comment
Name:
Email:
Website:
Comments: