K
Kan Tong
Hi,
I'm building XSLT files to transfomr XML data to XML Excel spreadsheet
files,
From the worksheet that I created with the XML data I am taking the data and
creating another worksheet with pivot table, the problem is that this
requiring except the source worksheet name the file name too... ?!
something like:
<ConsolidationReference>
<filename>[XSL Output.xml]Report Data</filename>
</ConsolidationReference>
The problem is that the file name is not static and it could change from
time to time... so...
Is there a way to tell Excel too look for the worksheet in the current file
? i have tried <filename>Report Data</filename> (note that "Report Data" is
the worksheet name) and it doesn't work
Is there a workaround for this problem ?
thanks very much for whoever can help
I'm building XSLT files to transfomr XML data to XML Excel spreadsheet
files,
From the worksheet that I created with the XML data I am taking the data and
creating another worksheet with pivot table, the problem is that this
requiring except the source worksheet name the file name too... ?!
something like:
<ConsolidationReference>
<filename>[XSL Output.xml]Report Data</filename>
</ConsolidationReference>
The problem is that the file name is not static and it could change from
time to time... so...
Is there a way to tell Excel too look for the worksheet in the current file
? i have tried <filename>Report Data</filename> (note that "Report Data" is
the worksheet name) and it doesn't work
Is there a workaround for this problem ?
thanks very much for whoever can help