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">---,Rate</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2010,"2,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2011,"7,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2012,"2,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2013,"9,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2014,"1,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2015,"1,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2016,"10,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2017,"3,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2018,"7,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2019,"8,000000"</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">2020,"6,000000"</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
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,