[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: editing XML with Spreadsheets, most likely Excel

• From: Dave Pawson <davep@d...>
• To: Stephen Green <stephengreenubl@g...>
• Date: Sun, 02 Dec 2007 08:36:20 +0000

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

• Follow-Ups:
  • Re: editing XML with Spreadsheets, most likely Excel
    • From: Nicholas Sushkin <nsushkin@o...>
  • Re: editing XML with Spreadsheets, most likely Excel
    • From: "Stephen Green" <stephengreenubl@g...>

• References:
  • editing XML with Spreadsheets, most likely Excel
    • From: "bryan rasmussen" <rasmussen.bryan@g...>
  • Re: editing XML with Spreadsheets, most likely Excel
    • From: "Stephen Green" <stephengreenubl@g...>
  • Re: editing XML with Spreadsheets, most likely Excel
    • From: "Stephen Green" <stephengreenubl@g...>