Set custom formatting for Excel range in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-custom-formatting.html

Set predefined formatting for Excel range in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-predefined-formatting.html

‪Column width and row height in Excel for C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-column-width-row-height.html

‪Import or export to Excel merged cells in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-merge-cells.html

‪Import and export rich text format to Excel cell in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-rich-text-format.html

‪Calculate Excel formulas by defining formulas with functions or loading template Excel files with predefined formulas in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/excel-calculation-engine.html

‪Import Excel formula, export Excel with formula and calculate Excel formulas in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/import-export-excel-formulas.html

‪Import data from Excel, export data to Excel in C#, VB.NET, Java, C++, PHP and other!
http://www.easyxls.com/manual/basics/import-export-excel-data.html

‪Create Excel files with multiple sheets in C#, VB.NET, Java, C++, PHP and other! EasyXLS™ library allows you to create Excel files with multiple sheets. There are two types of sheets: worksheets and chart sheets.
http://www.easyxls.com/manual/basics/create-excel-file-multiple-sheets.html

One of the challenges when creating Excel files is to protect the data inside the sheets from unintended editing or to restrict the access to data from some cells.

An Excel file has a feature that allows to locked specific cells. The feature is active only when the sheet is protected. Optionally, the sheet can be protected with a password.

EasyXLS is a spreadsheet component that facilitates the creation of Excel files and it supports to create protected Excel sheets.

EasyXLS offers a wide variety of code samples that explains how this feature can be integrated in C#, VB.NET, C++.NET, J#, PHP, ASP classic, VBS, VB6, C++, Java or ColdFusion and tutorials can be accessed staring from the following link:

How to protect Excel sheet from C#, VB.NET, Java, PHP, C++ and other?

EasyXLS component supports all MS Excel file formats including xlsx, xls, xlsm and xlsb file formats released by Microsoft over the last years like MS Excel 97, MS Excel 2003, MS Excel 2007, MS Excel 2010 and MS Excel 2013.

Furthermore, EasyXLS component supports password protected Excel files that bring the security at a higher level. The password protected Excel files are also encrypted. Check the following link for code samples:

How to protect Excel file with password in C#, VB.NET, Java, PHP, C++ and other?