We are using Infragistics Professional 2019 and need a way to export PivotGrid data to Excel. We haven't been able to find a way to do this that doesn't involve having to install Excel on the server. Can someone please provide some direction on this?
Hello Paul,
Let me know if I may be of any further assistance.
Sincerely, Teodosia Hristodorova Associate Software Developer
Thanks - this sounds like an option that we can explore. Better than looking for a third party component. Ultimately would still be great if PivotGrid had this capability built in.
This is very unfortunate. I have seen this same response going back years and still nothing has been done about it.
Note that while there is no direct export to Excel for PivotGrid, the suite does include the Infragistics Excel engine which allows you to create Excel files without having Excel installed on the machine. So you could write code to read the data from the PivotGrid and create an Excel file yourself.