Subject:
|
Working with Excel and XML?
|
Newsgroups:
|
lugnet.off-topic.geek
|
Date:
|
Sat, 11 Jun 2005 03:25:51 GMT
|
Viewed:
|
2949 times
|
| |
 | |
Has anyone done any work with Excel and XML? I want to save the contents of
an Excel worksheet (a simple table of rows and columns will column headers)
in XML format so I can use it as part of a web application. The Excel XML
map process is confusing to say the least and the documentation is weak.
Mike
--
Mike Walsh - mike_walsh at mindspring.com
http://www.ncltc.cc - North Carolina LEGO Train Club
http://www.carolinatrainbuilders.com - Carolina Train Builders
http://www.bricklink.com/store.asp?p=mpw - CTB/Brick Depot
|
|
Message has 2 Replies:  | | Re: Working with Excel and XML?
|
| (...) Probably simpler to have excel save it as a CSV and use perl or somesuch to transform the CSV into XML. That's assuming the webapp couldn't be made to import the CSV directly... (20 years ago, 11-Jun-05, to lugnet.off-topic.geek)
|  | | Re: Working with Excel and XML?
|
| (...) I use Excel to generate HTML tags all the time. But I'm not using the Excel XML process myself, I am just using formulas to get the contents of tables into tagged HTML One thing that bites me somewhat regularly is the fact that Excel wants to (...) (20 years ago, 11-Jun-05, to lugnet.off-topic.geek)
|
4 Messages in This Thread:   
    
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|