XML file import issue

 

Hello,

I have exported an Excel spread sheet as an XML 2003 spread sheet one.

When I import it in Aximmetry, I only get Workbook = <sub> on my collection output pin of the XML file module.

Here's the XML content:

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:o="urn:schemas-microsoft-com:office:office"

 xmlns:x="urn:schemas-microsoft-com:office:excel"

 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:html="http://www.w3.org/TR/REC-html40">

 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

  <Author>Eric Soulard</Author>

  <LastAuthor>Eric Soulard</LastAuthor>

  <Created>2022-08-19T15:34:16Z</Created>

  <Version>16.00</Version>

 </DocumentProperties>

 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

  <AllowPNG/>

 </OfficeDocumentSettings>

 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

  <WindowHeight>7193</WindowHeight>

  <WindowWidth>21585</WindowWidth>

  <WindowTopX>32767</WindowTopX>

  <WindowTopY>32767</WindowTopY>

  <ProtectStructure>False</ProtectStructure>

  <ProtectWindows>False</ProtectWindows>

 </ExcelWorkbook>

 <Styles>

  <Style ss:ID="Default" ss:Name="Normal">

   <Alignment ss:Vertical="Bottom"/>

   <Borders/>

   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>

   <Interior/>

   <NumberFormat/>

   <Protection/>

  </Style>

 </Styles>

 <Worksheet ss:Name="graph_1">

  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="12" x:FullColumns="1"

   x:FullRows="1" ss:DefaultColumnWidth="60" ss:DefaultRowHeight="14.25">

   <Row>

    <Cell><Data ss:Type="String">&#45;&#45;-,Rate</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2010,&quot;2,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2011,&quot;7,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2012,&quot;2,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2013,&quot;9,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2014,&quot;1,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2015,&quot;1,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2016,&quot;10,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2017,&quot;3,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2018,&quot;7,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2019,&quot;8,000000&quot;</Data></Cell>

   </Row>

   <Row>

    <Cell><Data ss:Type="String">2020,&quot;6,000000&quot;</Data></Cell>

   </Row>

  </Table>

  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

   <PageSetup>

    <Header x:Margin="0.3"/>

    <Footer x:Margin="0.3"/>

    <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>

   </PageSetup>

   <Selected/>

   <ProtectObjects>False</ProtectObjects>

   <ProtectScenarios>False</ProtectScenarios>

  </WorksheetOptions>

 </Worksheet>

</Workbook>


I also tried to copy directly this content in the XML text module text editor and got the same result.
Best


   Eric Soulard

 
Profile Image
Eifert@Aximmetry
  -  

Hi Eric,

You need to use a Subcollection module with the workbook Key:

We recently released related documentation on the Collection data type: https://aximmetry.com/learn/tutorials/for-content-creators/collection-for-databases/

Warmest regards,

;