I've gotten the a dataset table document translated (using XSLCompiledTransform and an .xslt) into a XMLSpreadsheet that can be read by Excel
Problem is that the .xslt is hardcoded for this particular datatable format. I'm going to do the xlate for many datatables with different formats, and the files will change during development.
So I'd like to generate the .xslt dynamically for each dataset table. I can see the mechanics of creating and writing to the .xslt file, etc. and at the heart of it I can imagine something like:
For each wrkCol as column in datatable,
xsltString = xsltString & GeneratePieceOfXSLT_SpecificToColumn (wrkCol)
And I hope to learn enough of the xml node language to incorporate that, too.
Question: are there tools to make this easier, or examples that are already worked out along these lines?
Any guidance on this would be appreciated.