Hi,
Thanks for considering Aspose.
1. Excel templates (.xlt) and workbooks (.xls) including embedded functions (SUM, VLOOKUP, etc.)
Yes, Aspose.Cells supports to manipulate / process the excel formats having a variety of functions including your desired ones. Aspose.Cells fully supports to create excel file from the scratch with all the style formattings and you can also manipulate existing template files with ease.
2. VBA macros - especially Class Modules and User Defined Functions
Well, Aspose.Cells can load the files having vba/macors and save the file with (attached to) them. But Aspose.Cells does not support to manipulate vba / macros. Currently, you can only remove macros attached to the template file using Aspose.Cells APIs.
3. Workbooks with multiple worksheets and cross-worksheet data references
Yes, Aspose.Cells can support to create / manipulate workbooks with multiple worksheets having cross references etc.
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/managing-worksheets.html
4. Worksheet and Workbook protection at least at the Excel 2003 level (specifically protection w/ userInterfaceOnly support)
Yes, Aspose.Cells supports to protect / unprotect a workbook / worksheets / Cells and supports all the types protection attributes which MS Excel allows.
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/protecting-worksheets.html
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/advanced-protection-settings-since-excel-xp.html
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/unprotect-a-worksheet.html
5. Mapping of data into and out of the spreadsheet in an easily user-modifiable (add/delete/change) method
Yes, Aspose.Cells support this.
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/adding-data-to-cells.html
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/importing-data-to-worksheets.html
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/exporting-data-from-worksheets.html
6. Embedded controls/references:
* Microsoft Excel 11.0 Object Library
* Microsoft Office 11.0 Object Library
* Microsoft Forms 2.0 Object Library
I 'm not very sure about this query. You mean Excl automation libraries. Well, Aspose.Cells is an independent and a pure spreadsheet management .NET component (library). The component does not require MS Excel to be installed either on client or server side. The component can process all the excel formats including .xls, xlsx, xlsm, csv, tab delimited, SpreadsheetML etc.
For further reference, please check the Aspose.Cells Documentation with APIs: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/index.html and test our featured demos:
Hope, it will help you.
Feel free to contact us any time if you need further details and we will be glad to provide you soon.
Thank you.