Excel 2007 XML Export

  • Thread starter Thread starter biz7
  • Start date Start date
B

biz7

Hello,

Our bank just installed Microsoft Excel 2007. When I click on the Developer
tab in the Ribbon section & export, the file exports successfully. However,
I cannot import the file into my work application directly, "unless", I open
the file with notepad & delete the 1st line item which automatically is there
when I export from Excel 2007. The line item reads as follows: <?xml
version="1.0" encoding="UTF-8" standalone="yes"?>

Is there a way to remove this automatic line item from the xml? I am not
sure what is causing the xml export to add this line item automatically.
Otherwise, I would be able to skip a step (do not open notepad) & just import
the xml file. Please advise-thanks for your assistance!
 
Hi Jan,

Following is the export xml from Microsoft Excel 2007 Developer tab (please
see below). I am importing into a SQL web based application. In testing,
the xml file will import but will not update data with the first line item
there. When the first line item is removed, the data is updated. I have
tested it many times. Please advise, thanks.

XML export:
===================
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ExportEdits>
<tblScenarioData>
<Row Key1="4-299436" Key2="" Key3="" Key4="" Key5="" Attribute="CUSIP"
TableName="tblAssets" AttributeValue="03073JAH7" DataType="8" OverWrite="1"
Active="1"/>
</tblScenarioData>
</ExportEdits>
=====================
 
Back
Top