Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,254
Total Threads: 80,792
Total Posts: 566,472
There are 1622 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

Excel to XML

Thread title: Excel to XML
Closed Thread    
    Thread tools Search this thread Display Modes  
05-16-2006, 04:20 PM
#1
brendan is offline brendan
brendan's Avatar
Status: Member
Join date: Nov 2005
Location:
Expertise:
Software:
 
Posts: 189
iTrader: 0 / 0%
 

brendan is on a distinguished road

  Old  Excel to XML

Anybody know a way to convert a spreadsheet into an XML document, where the column headings are the markup tags? Or point me me in the direction of maybe figuring this out?

05-16-2006, 04:32 PM
#2
Zane is offline Zane
Status: Making Money
Join date: Aug 2005
Location: Surrey, England, UK
Expertise:
Software:
 
Posts: 1,674
iTrader: 0 / 0%
 

Zane is on a distinguished road

Send a message via MSN to Zane

  Old

File > Save as > Save as type - XML > Save

Thats basically it.

05-17-2006, 08:54 PM
#3
brendan is offline brendan
brendan's Avatar
Status: Member
Join date: Nov 2005
Location:
Expertise:
Software:
 
Posts: 189
iTrader: 0 / 0%
 

brendan is on a distinguished road

  Old

Originally Posted by netspeak
File > Save as > Save as type - XML > Save

Thats basically it.
that doesn't make the column headings the markup tags

05-21-2006, 11:02 PM
#4
Michael Boutros is offline Michael Boutros
Status: I'm new around here
Join date: May 2006
Location:
Expertise:
Software:
 
Posts: 7
iTrader: 0 / 0%
 

Michael Boutros is on a distinguished road

  Old

What format would the excel file be? Do you want to upload the excel file and then have an XML file created and shown?

05-26-2006, 04:25 AM
#5
brendan is offline brendan
brendan's Avatar
Status: Member
Join date: Nov 2005
Location:
Expertise:
Software:
 
Posts: 189
iTrader: 0 / 0%
 

brendan is on a distinguished road

  Old

we ended up having to use a different workflow so i don't need help on this anymore, but the excel file would be a native .xls sheet, and i wanted to turn that into an xml with each row as a record with the column headings as markup, like:
<record>
<heading1>data</heading1>
<heading2>data</heading2>
<heading3>data</heading3>
</record>
<record>
<heading1>another</heading1>
<heading2>another</heading2>
<heading3>another</heading3>
</record>

if someone knows a simple way though i'd still be interested

Closed Thread    


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed