Free Support Forum - aspose.com

.cells technical questions

I need to have information to see if your product handles the following technical needs I am looking for before we purchase:


1. Excel templates (.xlt) and workbooks (.xls) including embedded functions (SUM, VLOOKUP, etc.)
2. VBA macros - especially Class Modules and User Defined Functions
3. Workbooks with multiple worksheets and cross-worksheet data references
4. Worksheet and Workbook protection at least at the Excel 2003 level (specifically protection w/ userInterfaceOnly support)
5. Mapping of data into and out of the spreadsheet in an easily user-modifiable (add/delete/change) method
6. Embedded controls/references:
* Microsoft Excel 11.0 Object Library
* Microsoft Office 11.0 Object Library
* Microsoft Forms 2.0 Object Library


This message was posted using Aspose.Live 2 Forum

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: http://www.aspose.com/demos/aspose.cells/default.aspx

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.