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
Export data to XLSB file in C#.NET using EasyXLS Excel library! The file has multiple sheets and the first sheet is filled with data.
http://www.easyxls.com/manual/tutorials/csharp/export-data-to-xlsb-file.html
Export data to XLSX file in C#.NET using EasyXLS Excel library! The file has multiple sheets and the first sheet is filled with data.
http://www.easyxls.com/manual/tutorials/csharp/export-data-to-xlsx-file.html
Export data to Excel file in C#.NET with formatting styles using EasyXLS Excel library! http://www.easyxls.com/manual/tutorials/csharp/format-excel-cells.html
Export data to XLS file in C#.NET using EasyXLS Excel library! The file has multiple sheets and the first sheet is filled with data.
http://www.easyxls.com/manual/tutorials/csharp/export-data-to-xls-file.html
Export DataSet to Excel file with formatting in C#.NET using EasyXLS Excel library! The DataSet can contain data from a SQL database, GridView, DataGridView, DataGrid or other.
http://www.easyxls.com/manual/tutorials/csharp/export-dataset-to-excel-with-formatting.html
Export DataSet to Excel file in C#, using EasyXLS Excel library! The DataSet can contain data from a SQL database, GridView, DataGridView, DataGrid or other.
http://www.easyxls.com/manual/tutorials/csharp/export-dataset-to-excel.html