To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.off-topic.geekOpen lugnet.off-topic.geek in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Off-Topic / Geek / 5015
5014  |  5016
Subject: 
Working with Excel and XML?
Newsgroups: 
lugnet.off-topic.geek
Date: 
Sat, 11 Jun 2005 03:25:51 GMT
Viewed: 
2550 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... (19 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 (...) (19 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
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR