Hi,
The following is the requirement for our module.:
--> When the user updates data in UI, the data needs to be updated in the Excel template (Template 1)that is generated on the server.
--> When Template 1 is updated, another excel sheet --> Template 2 needs to be updated.
We are planning to evaluate Infragistics.Excel for the same. Please let me know if there are any known issues for the same.
Regards,
Yamini
What kind of objects are stored in your templates? If it is just data, images, shapes, validation rules and formulas, I don't see any problems. But charts, pivot-tables, and forms (such as button and labels) are not currently supported or round-tripped so they will be lost on a load/save operation. VBA data is round-tripped, so this will be maintained.
If buttons are not retained within the workbook created from a template, do you have a means for how I could recreate the button with C# code?
Forms, such as buttons, are currently not supported. You can submit a feature request for forms support.