Re: [xml-dev] editing XML with Spreadsheets, most likely Excel

[Dave Pawson <davep@dpawson.co.uk>]

Stephen Green wrote:
> An afterthought:
> I've not tried it but maybe, if you use XSLT to create XML output from
> the underlying XML of the spreadsheet,


I used that method regularly. Spreadsheet entered in MS excel,
import into Open Office, save. Unzip the xml and process.
The empty cells weren't a problem. The information is present
to 'expand' them to make a complete matrix. Expand to a variable
then process in the normal way.


Note it was 'regular' data though.


regards

-- 
Dave Pawson
XSLT XSL-FO FAQ.
http://www.dpawson.co.uk