Mette:
Yes, you can. Is it easy - it depends on the data. If the data
coming to and from the spreadsheet files are consistent, then you will
have better results. Without seeing the data I can't tell you the best
approach but here are a few ways to approach the problem:
1. Output from Excel (Windows 2000). Save as Web file and convert
from MS XML to required XML file using XSLT. Robust style sheets
from Excel will help this process dramatically.
2. Write a Macro within Excel and/or Lotus to wrap the data in conforming
XML elements then save as XML.
3. Write a filter in your favorite programming language to convert
a delimited file to XML. My favorite programming language for
this kind of conversion is Omnimark. Perl or other programming
language can also be used.
In order to ensure success, you have to analyze the data coming and
going to the spreadsheet.
Hope this helps.
Betty
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
Betty Harvey | Phone: 301-540-8251 FAX: 4268
Electronic Commerce Connection, Inc. |
13017 Wisteria Drive, P.O. Box 333 |
Germantown, Md. 20874 |
[EMAIL PROTECTED] | Washington,DC SGML/XML Users Grp
URL: http://www.eccnet.com | http://www.eccnet.com/xmlug/
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/
On Thu, 20 Jan 2000, Mette Marie Knudsen wrote:
> Dear all,
>
> I need a little help.
>
> A customer wants to exchange (EDI) MS Excel (Ofiice2000) and/or Lotus 1-2-3
> documents in XML. Is it possible? Do you know how to do? Do you have any
> experinces?
>
> Second, if it is possible to convert Excel (Ofiice2000) and/or Lotus 1-2-3
> documents to XML, can the document then refer to a DTD/schema?
>
> I thank you in advance.
>
> Br,
>
> Mette Marie Knudsen, Consultant
> Direct Tel. +45 3945 0781, Mobile Tel. +45 2622 7166
> Email: [EMAIL PROTECTED]
>
> Fischer & Lorenz A/S
> Tuborg Parkvej 10, DK-2900 Hellerup, Copenhagen, Denmark
> Tel. +45 3945 0700, Fax +45 3945 0777
> Web: http://www.fl.dk
>
> Independent IT advice for better results
>
>
> ==========================================
> XML/EDI Group members-only discussion list
> Homepage = http://www.xmledi.com
>
> Brought to you by: Online Technologies Corporation
> Home of BizServe - www.bizserve.com
>
> TO UNSUBSCRIBE: Send email to <[EMAIL PROTECTED]>
> Leave the subject blank, and
> In the body of the message, enter ONLY: unsubscribe
>
> Questions/requests should be sent to: [EMAIL PROTECTED]
> To join the XML/EDI Group complete the form located at:
> http://www.geocities.com/WallStreet/Floor/5815/mail1.htm
>
>
==========================================
XML/EDI Group members-only discussion list
Homepage = http://www.xmledi.com
Brought to you by: Online Technologies Corporation
Home of BizServe - www.bizserve.com
TO UNSUBSCRIBE: Send email to <[EMAIL PROTECTED]>
Leave the subject blank, and
In the body of the message, enter ONLY: unsubscribe
Questions/requests should be sent to: [EMAIL PROTECTED]
To join the XML/EDI Group complete the form located at:
http://www.geocities.com/WallStreet/Floor/5815/mail1.htm
