Generate excel report using templates embeded with macros programmatically?

Aspose.Cells Product Family
1

Before reading any documentation i am asking this question.

Currently we generate an excel report(97-2003 xls) which has a Header, Body and Footer.
Header contains Name, Address (contactInfo ) etc and ProductNames, where product names vary for each report (one report can have 1, 5 or more product). Body contains rows of data of contact-Info and number of products ordered for each ProductNames. In the end the footer contains sum of all orders for each productName. We send the report to user, he makes changes to the orders and sends us back. We have macros to lock, format and validate certain fields which is activated when user edits the file. Once we get the file we have to read the changes and save it in database.

Now we are trying to automate this process by making it web based using ASP.NET 3.5.
Basically we want the same business process. We have a template with macros we have to use, There are dynamic columns(ProductNames) which vary per request. generate the report at server, user will download, make changes and upload back.Server will read it and update database.

Can Aspose.Cell provide the solution?

Thanks

2

Hi,

Thanks for your inquiry.

Since your process is somehow manual oriented, I think Aspose.Cells may perform the task for your scenario. One thing you should be aware, Aspose.Cells does not have the capability to run or manipulate vbas/macros in the template files. But, it will preserve vba code / macros in the template file and save the file with them. It has almost all the features that MS Excel has, e.g Formatting cells, Data validations, Apply and Calculate Formulas, lock/protect worksheet or cells etc. See some reference documents in this regards:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/approaches-to-format-data-in-cells.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/creating-subtotals.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/using-formulasfunctions-to-process-data.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/protecting-worksheets.html

I think you may create an Asp.NET application based on your business model. You can dynamically generate excel reports. You can input data into your template sheet's fields/cells, here you may use Aspose.Cells Subtotals feature if it suits you, see the document for reference: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/creating-subtotals.html User can download the generated report and input data into the fields and then re-upload it back. Using Aspose.Cells API you may read the updated report and then update the database. Here, you may use, e.g Cells.ExportDataTable() to get a datatable, Cells.ExportArray() to get an array of worksheet data or get your desired calculated cells values before finally update the database using ADO.NET API. Check the document for reference: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/exporting-data-from-worksheets.html

Kindly let us know if you need further clarification.

Thank you.

3

Thank you. I will let you know how this goes