I am using the Infragistics Excel class to create an Excel document and attach to an email.
I would like to add subtotals (in Excel accessed though the Data tab) by passing in the column for "At each Change In", a formula (sum, average, etc), and a list of columns to subtotal on). Does Infragistics have this feature?
I would also like to know about creating Pivot tables - is that supported in this Excel class?
Thank you
Thank you very much for your help.
This was perfect.
I have very professional looking Excel documents to send to my management team now!
Hello Katie,
Take a look at the OutlineLevel Property, it's intended for hierarchical grouping in Excel.
Thank you very much.
This was extremely helpful and I was able to adjust to my specifications.
The only thing I was unable to get was the little grouping section that Excel has to conveniently collapse or expand views.
Hello,
I actually finished the sample sooner than I estimated. I've attached it here for your review. Please take a look at it to get an example of how you can code your own actions similar to Subtotal with the Infragistics Excel Engine.
Please let me know if I can assist you further.
I am still working on a sample to demonstrate how you would write an action similar to Subtotal in code. You can expect the sample completed no later than close of business tomorrow.
Please note that this is just a proof of concept, and that it will not be fully tested water tight solution like the current MS Excel's Subtotal, but it should give you an idea of how to use the Excel Engine to write what you need for your purposes.