Create Excel filter or autofilter‪Create Excel pivot tables in C#.NET, VB.NET, Java, C++, PHP and other, using EasyXLS Excel library! The pivot tables are reports in Excel that summarize worksheet data for a customized and clearer view over it. EasyXLS library allows you to create a pivot table in Excel, to set the data source and to arrange its data and fields into desired areas.
http://www.easyxls.com/manual/basics/excel-pivot-table.html

If not familiar with pivot tables in MS Excel or for technical related details, learn about Excel pivot tables.

(0) Comments    Read More   

Create Excel filter or autofilter‪Create Excel filter or autofilter in C#.NET, VB.NET, Java, C++, PHP and other, using EasyXLS Excel library! It permits to filter a range of data from an Excel sheet and hide records that don’t meet your criteria, displaying just a subset of data in a range of cells.
http://www.easyxls.com/manual/basics/excel-filter-and-autofilter.html

(0) Comments    Read More   

Create Excel chart types in C#, VB.NET, Java, PHP, C++ and other programming languages‪How many chart types can you create in Excel, using EasyXLS Excel library, in C#, VB.NET, Java, PHP, C++ and other programming languages?

http://www.easyxls.com/manual/basics/excel-chart-types.html

(0) Comments    Read More   

Create Excel chart sheet in C#, VB.NET, Java, PHP, C++ and other programming languages‪Create Excel charts that can be placed in a separate sheet. A chart can have two positions, as a distinct sheet or as an object in a worksheet. EasyXLS also allows you to read Excel files that contain charts and extract chart information.

http://www.easyxls.com/manual/basics/excel-chart-sheet.html

(0) Comments    Read More   

Create Excel charts inside a worksheet in C#, VB.NET, Java, PHP, C++ and other programming languages


Create Excel charts that can be positioned inside a worksheet in C#, VB.NET, Java, PHP, C++ and other programming languages! A chart can have two positions, as a distinct sheet or as an object in a worksheet.

http://www.easyxls.com/manual/basics/excel-chart-inside-sheet.html

(0) Comments    Read More   

Read large data from Excel file with fast reading time in C#, VB.NET, Java, PHP, C++ and other programming languages

Read large data from Excel file with fast reading time in C#, VB.NET, Java, PHP, C++ and other programming languages! The supported Excel file formats are XLSX, XLSM, XLS and XLSB.

http://www.easyxls.com/manual/tips-and-tricks/read-large-excel-file.html

(0) Comments    Read More   
Mar
16

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   

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   

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   

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

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

The XLSB file format is the new binary format used by Microsoft Excel 2007-2013.

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

(0) Comments    Read More