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

["Stephen Green" <stephengreenubl@gmail.com>]

Plus you can automate it all for hundreds of documents using
Ant/Ant Contrib or an Open Office macro. Works very nicely.

On 02/12/2007, Dave Pawson <davep@dpawson.co.uk> wrote:
> 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
>


-- 
Stephen Green

Partner
SystML, http://www.systml.co.uk
Tel: +44 (0) 117 9541606

http://www.biblegateway.com/passage/?search=matthew+22:37 .. and voice