Ok, so here is the deal. I have a dataset that I want to export to excel using XML/XSLT. I have a fairly general idea about how all of this should work, and have found many resources on the 'net, but none seem to really get me going on how this whole thing should work.
So here is what I have...I have a stored procedure on my sql server that builds a dataset in my application. This dataset has dynamic headings (it is a crosstab query, so the headings from report to report can be different). I can understand the process for getting the dataset to excel, but I am giving myself a headache trying to figure out the xsl transform part.
How do I build a "dynamic" stylesheet, so that my xml spreadsheet can be exported into excel? Or am I thinking about this totally wrong? Is there a way to do this? Any help would be greatly appreciated!
So here is what I have...I have a stored procedure on my sql server that builds a dataset in my application. This dataset has dynamic headings (it is a crosstab query, so the headings from report to report can be different). I can understand the process for getting the dataset to excel, but I am giving myself a headache trying to figure out the xsl transform part.
How do I build a "dynamic" stylesheet, so that my xml spreadsheet can be exported into excel? Or am I thinking about this totally wrong? Is there a way to do this? Any help would be greatly appreciated!