Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 15th 05, 07:22 AM
 
Posts: n/a
Default Excel 2003, Convert EXISTING Worksheet Data to XML?

Hello.

First, I've read Excel help and worked through several on-line
tutorials on the Microsoft website in regards to XML support in Excel
2003. And, have searched web and Usenet looking for clues. So, please
forgive if this has been asked and answered; I didn't find it if it
has. Thanks!

I've got an Excel spreadsheet containing data.

I'd like to be able to export that as XML. Not via the "save as" an
XML spreadsheet method - too much extraneous data in the resultant
output. Too difficult to parse out the unwanted stuff. Microsoft
doesn't even recommend that method.

What I'd like to do is what Microsoft recommends anyway: Define an "XML
Map" and so on.

Problem: All the documentation seems to indicate that you can define
the map (either by supplying your own xml schema or by letting Excel
create one for you), and then you have to IMPORT xml data into your
spreadsheet where it is then stored when you save it.

Well, my data's ALREADY in a spreadsheet. Is there ANY way to get
Excel to accept THAT DATA as being xml data without me having to (a)
re-key it all into a new spreadsheet or (b) export it out via whatever
method and convert it to "well formed" xml BY HAND so I can re-bring it
back in again?

That really, really seems kind of ludicrous!

I've tried mapping my xml map to the existing data and it will happily
accept JUST THE ONE ROW as being xml data (and subsequently exports
just that one row).

I've tried making my data into an Excel "list" (2003 feature), and then
mapping the xml map to that. Seems to accept it. You see the fields
in the tree in the XML Source window jump around as you click on cells
in different columns in the data, so it seems to recognize the data as
being mapped in it's entirety. But, when you do to the Data menu, XML,
Export, it says "Cannot save or export XML data. The XML maps in this
workbook are not exportable."

Sigh. Come on. Surely many, many, many folks are in this position.
Don't tell me Microsoft went to all the trouble to add the level of XML
integration that they did to Excel, and negelected to provide some way
- any way - for folks to make use of their existing, legacy data?
(Without having to go through a needless conversion)

Answers, suggestions, tips welcome!!!! In advance, Thank You!

p.s. If you can answer the above, perhaps you can also answer this?
Say I have my XML map defined, have data that happily believes it's xml
in the worksheet, can export to "well formed" xml and so on.

Say I want to add a new column? One would think that Excel would then
allow you to define a new node in the XML Source tree. Nope. You can
add the column, but Excel refuses to accept that new column as xml.
Any suggestions? A procedure? Am I just not getting something
obvious? Again, thank you!


  #2   Report Post  
Old November 15th 05, 01:05 PM posted to microsoft.public.excel.misc
R.VENKATARAMAN
 
Posts: n/a
Default Excel 2003, Convert EXISTING Worksheet Data to XML?

there is a third party html maker try this url

http://puremis.net/excel/cgi-bin/cli...l=http://purem
is.net/excel/soft/HtmlMaker2.42.zip


wrote in message
oups.com...
Hello.

First, I've read Excel help and worked through several on-line
tutorials on the Microsoft website in regards to XML support in Excel
2003. And, have searched web and Usenet looking for clues. So, please
forgive if this has been asked and answered; I didn't find it if it
has. Thanks!

I've got an Excel spreadsheet containing data.

I'd like to be able to export that as XML. Not via the "save as" an
XML spreadsheet method - too much extraneous data in the resultant
output. Too difficult to parse out the unwanted stuff. Microsoft
doesn't even recommend that method.

What I'd like to do is what Microsoft recommends anyway: Define an "XML
Map" and so on.

Problem: All the documentation seems to indicate that you can define
the map (either by supplying your own xml schema or by letting Excel
create one for you), and then you have to IMPORT xml data into your
spreadsheet where it is then stored when you save it.

Well, my data's ALREADY in a spreadsheet. Is there ANY way to get
Excel to accept THAT DATA as being xml data without me having to (a)
re-key it all into a new spreadsheet or (b) export it out via whatever
method and convert it to "well formed" xml BY HAND so I can re-bring it
back in again?

That really, really seems kind of ludicrous!

I've tried mapping my xml map to the existing data and it will happily
accept JUST THE ONE ROW as being xml data (and subsequently exports
just that one row).

I've tried making my data into an Excel "list" (2003 feature), and then
mapping the xml map to that. Seems to accept it. You see the fields
in the tree in the XML Source window jump around as you click on cells
in different columns in the data, so it seems to recognize the data as
being mapped in it's entirety. But, when you do to the Data menu, XML,
Export, it says "Cannot save or export XML data. The XML maps in this
workbook are not exportable."

Sigh. Come on. Surely many, many, many folks are in this position.
Don't tell me Microsoft went to all the trouble to add the level of XML
integration that they did to Excel, and negelected to provide some way
- any way - for folks to make use of their existing, legacy data?
(Without having to go through a needless conversion)

Answers, suggestions, tips welcome!!!! In advance, Thank You!

p.s. If you can answer the above, perhaps you can also answer this?
Say I have my XML map defined, have data that happily believes it's xml
in the worksheet, can export to "well formed" xml and so on.

Say I want to add a new column? One would think that Excel would then
allow you to define a new node in the XML Source tree. Nope. You can
add the column, but Excel refuses to accept that new column as xml.
Any suggestions? A procedure? Am I just not getting something
obvious? Again, thank you!



  #3   Report Post  
Old November 15th 05, 10:55 PM posted to microsoft.public.excel.misc
 
Posts: n/a
Default Excel 2003, Convert EXISTING Worksheet Data to XML?

Hi. Thanks for the suggestion. I read the "readme" file for
HtmlMaker2.42, but there is no mention of XML in it at all... Am I
missing something?

Anyone else??? Come on, somebody has got to have gone through this by
now!!!! I'm sure I can't be the first to run into these issues!?!? ;-)

  #4   Report Post  
Old November 16th 05, 04:43 AM posted to microsoft.public.excel.misc
 
Posts: n/a
Default Excel 2003, Convert EXISTING Worksheet Data to XML?

Here's the answer:

<a
href="http://www.microsoft.com/downloads/details.aspx?familyid=72852247-6afd-425c-83b1-1f94e4ac2775&displaylang=en"Excel
2003 Add-in: XML Tools Add-in</a

p.s. How do you get a stinking link to work in Google Groups?? Gave up
screwing around with the above. Just wondering.

  #5   Report Post  
Old November 16th 05, 04:45 AM posted to microsoft.public.excel.misc
 
Posts: n/a
Default Excel 2003, Convert EXISTING Worksheet Data to XML?

Okay, so here's the answer to that: Their "preview" doesn't work the
same way as it does when you actually post. (Sigh)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting sheet disables import of extetrnal data in Excel 2003 MNord Excel Discussion (Misc queries) 0 August 31st 05 04:34 PM
importing data from Excel worksheet to another worksheet jbrick Excel Worksheet Functions 0 August 11th 05 05:51 PM
How do I convert Excel 2003 to Excel 98 format? Lady Layla New Users to Excel 8 March 31st 05 12:47 AM
How do I convert an existing MS Excel worksheet tracking a simple. [email protected] Excel Discussion (Misc queries) 0 January 4th 05 12:53 AM
How do I import data from Microsoft Project 2003 to Excel? RgilbertProjMgr Excel Discussion (Misc queries) 3 December 31st 04 01:07 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017