Excel extraction using MSOGenerateExcelFile with corrupted data (Pivot and graphs)
We have a requirement to extract report through excel file . I have many tabs in excel template using for MSOGenerateExcelFile . The excel template have pivot tables and graphs in tabs but while downloading excel through MSOGenerateExcelFile ,The file seems to be corrupted saying pivot tables are not supported.But properties mapped using pxResults().XXX in one of the tabs are coming fine.
Is there a way to get pivot and graphs get updated with the report data in one of the tabs in excel ?
Thanks in advance
***Edited by Moderator: Lochan to update platform capability tags***