K
kleine98
I have successfully implemented a XML pivot report transform that i
available via a web page. If you have experience with this you kno
about the consolidationreference tag. The consolidation reference ta
takes the filename of the excel file holding the pivot data.
Scenario:
I have a web page that generates (via XML/XSL) an excel file with tw
worksheets. Sheet one holds a pivot report. Sheet two contains th
pivot data.
The url (for example) to open the sheet is http://localhost/excel.xml
Everything is wonderful.
If I would like to add url parameters then the pivot fails reportin
that it is unable to find the pivot source sheet.
I.E. http://localhost/excel.xml?id=4455
All of this tracks back to the consolidationreference tag in ExcelML.
wish ExcelML had a notation for referencing "current file".
Has anyone experienced/solved this particular problem?
available via a web page. If you have experience with this you kno
about the consolidationreference tag. The consolidation reference ta
takes the filename of the excel file holding the pivot data.
Scenario:
I have a web page that generates (via XML/XSL) an excel file with tw
worksheets. Sheet one holds a pivot report. Sheet two contains th
pivot data.
The url (for example) to open the sheet is http://localhost/excel.xml
Everything is wonderful.
If I would like to add url parameters then the pivot fails reportin
that it is unable to find the pivot source sheet.
I.E. http://localhost/excel.xml?id=4455
All of this tracks back to the consolidationreference tag in ExcelML.
wish ExcelML had a notation for referencing "current file".
Has anyone experienced/solved this particular problem?