Thanks for your counter-suggestion, David. You have a good point about
making a perfect spreadsheet starting from a given XML file. It might
be a bit clumsy with attribute values storing generic content, but it
works nevertheless with sufficiently tame examples.
What I'd like to ask is if you start first with populating spreadsheet
content, such as the small table below, and then saving it in "Other -
XML Format" under Excel. (I hope the table shows up properly in plain
text.)
this that UBL NAME NDR
123 a Address R 1
444 b Postcode r 2
222 c Line RR 3
I got the message "Cannot save as there is no XML mapping". It would
be tedious to work out a mapping for each sheet. In Excel-speak,
XML-Spreadsheet is just providing a default mapping from which applying
other XML transformation tools would get you the exact format you want.
Regards,
Chin Chee-Kai
David RR Webber (XML) wrote:
> You may be making this way too complex.
>
> <thisWorks>
> <row this="123" that="ABC" other="2008/04/03"/>
> <row this="124" that="ABCD" other="2008/04/07"/>
> <row this="129" that="ABCE" other="2008/04/08"/>
> <row this="132" that="ABCF" other="2008/04/09"/>
> </thisWorks>
>
> save this to XML - open in Excel. Will make perfect spreadsheet.
>
> I've used this very successfully outputting from XSLT and in combination
> with CAM templates.
>
> Thanks, DW
>
