Create or read password protected Excel files in C#, VB.NET, Java, C++, PHP and other!
EasyXLS™ library enables you to protect your Excel file from unauthorized access by setting passwords for opening or / and modifying the document. If you set the password for opening the file, the Excel file will be encrypted.
http://www.easyxls.com/manual/basics/password-protected-excel-file.html
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.
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
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
Import Excel data to MySQL, SQL Server in PHP or ASP classic! The data can be imported from an Excel sheet or from the active Excel sheet. The entire sheet data or only data from a range of cells can be imported.
http://www.easyxls.com/manual/FAQ/import-excel-to-mysql.html
Import data from Excel file in PHP or ASP classic. The Excel file can have one or multiple sheets. You may also import from other sheet elements like cell formatting, charts, pivot tables, comments, images and others.
http://www.easyxls.com/manual/FAQ/import-excel-in-php-asp.html
Export data to an Excel file having one or multiple sheets in PHP or ASP classic! The data in cells can be formatted using predefined formats or user-defined formats.
http://www.easyxls.com/manual/FAQ/export-to-excel-in-php-asp.html
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