Excel export to XML

S

Stephen

I have a spreadsheet with 800ish rows and 28 columns. I want to export it to
a custom XML file. I go to the XML data maping and map the xml file, it is
just an empty version of what I want. Map then export. The problem is that
it only exports the first row. Can anyone tell me how to get it to export
the entire spreadsheet without creating an XML file that has enough "room"
for all the cells in the spreadsheet?
 
C

challa prabhu

Hi

Follow these procedure;

Export XML data

Note XML features, except for saving files in the XML Spreadsheet format,
are available only in Microsoft Office Professional Edition 2003 and
Microsoft Office Excel 2003.

There are two ways to export XML data from an Excel worksheet.

The recommended method of getting XML data out of your worksheet is to use
the Export command on the XML submenu of the Data menu.
For backwards compatibility with previous XML functionality, you can still
use the Save As command on the File menu.
Export XML data in mapped cells to an XML data file
On the Data menu, point to XML, and then click Export.
If the Export XML dialog box appears, click the XML map that you want to
use, and then click OK.
The Export XML dialog box appears only if an XML list is not selected and
the workbook contains more than one XML map.

In the File name box, type a name for the XML data file.
Click Export.
Save XML data in mapped cells to an XML data file
On the File menu, click Save.
This step ensures that any changes made to your workbook won't be lost when
saving as an XML data file.

On the File menu, click Save As.
In the File name box, type a name for the XML data file.
In the Save as type list, click XML Data, and then click Save.
Click Continue when you receive an alert stating that saving the file as XML
data may result in the loss of features.
If the Export XML dialog box appears, click the XML map that you want to
use, and then click OK.
The Export XML dialog box appears only if an XML list is not selected and
the workbook contains more than one XML map.

Note You may have headings or labels in your worksheet different from the
the XML element names in the XML map. However, the XML element names are
always used when you export or save XML data from the worksheet.

Challa Prabhu
 
J

JackASP

I ran into this same issue with a project I was working on. The problem was
that I originally had my xml base file as something like:

<people>
<person>
<name></name>
<phoneNumber></phoneNumber>
</person>
</people>

When mapped to the data in the corresponding Excel columns, I would only get
the first row of data.

However, if you take your xml base file and add another "Person" entry, like
so:


<people>
<person>
<name></name>
<phoneNumber></phoneNumber>
</person>
<person>
<name></name>
<phoneNumber></phoneNumber>
</person>
</people>

Excel will know that the "person" tag (and, its child nodes) is meant to be
used multiple times. Coincidently, in the tree view of the XML data on the
right-hand window of the excel screen (the one you get from going to
Data>XML>XML Source...), you'll notice that the "file folder" icon associated
with the "Person" Tag will have a small blue square with a white "down" arrow
in it signifying that it is meant to be a repeated with different data.

Hope that helps.

Thanks,

Jack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top