Subject:
|
Re: Working with Excel and XML?
|
Newsgroups:
|
lugnet.off-topic.geek
|
Date:
|
Tue, 14 Jun 2005 17:00:13 GMT
|
Viewed:
|
4074 times
|
| |
|
|
"Larry Pieniazek" <lar(at@at)miltontrainworks(dot.dot)com> wrote in message
news:IHx8rs.1Er8@lugnet.com...
> In lugnet.off-topic.geek, Mike Walsh wrote:
> > 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.
>
> 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 • put
> "" around text fields when you copy the columns.
>
> Doing it in Perl from a CSV like Dan suggests would certainly be easy but • if you
> don't know Perl yet, you'd have some work. I can share a sample spread • that
> generates HTML if it would be helpful.
Thanks for the suggestions. I had considered using CSV but was intrigued by
XML and the ability to do validation of the data. If I use CSV (or
something similar) I have to do the validation myself and if there is a
problem, let the client know which could impose a delay. I could also write
a VBA script which runs within Excel to do the validation and have it
generate the data I want as well (in XML or another format). I'd probably
go this route before introducing a Perl script into the process as it keeps
the number of pieces of the application to a minimum.
I have found some more data on the web (see this:
http://msdn.microsoft.com/office/understanding/excel/codesamples/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/odc_xlexpen.asp)
so will probably try this route first.
Mike
--
Mike Walsh - mike_walsh at mindspring.com
http://www.ncltc.cc - North Carolina LEGO Train Club
|
|
Message is in Reply To:
 | | 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
|
|
|
|
