Subject:Best way to transform existing excel XML spreadsheet? Author:dave garcia Date:10 Sep 2007 12:57 AM
I have an existing excel XML spreadsheet I would like to transform with XSLT and during the transformation replacing existing values in cells and adding new rows to existing tables in worksheets. What is the best approach for doing this?
Which seems to work for one cell, however the source excel XML spreadsheet I am transforming is pretty complex with 6 worksheets, formulas, etc. and now I am thinking it may be hard to manipulate all the excel XML using this approach.. Maybe I should simply start with:
and re-create the excel XML and during the process of it insert new values and rows by using Xpath to find the right places in the excel XML to do it in? Any sugggestions are appreciated.