ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel question: "Problems during load" - Table (https://www.excelbanter.com/excel-programming/377337-excel-question-problems-during-load-table.html)

Matt[_43_]

Excel question: "Problems during load" - Table
 
Hi, I'm getting an error trying to load an xml excel spreadsheet. It
says the error is on the table element, but I can't seem to see the
problem. Hoping someone might have an idea. Thanks!

<Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="3"
x:FullColumns="1" x:FullRows="1"
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="87"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="84"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="70.5"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="63.75"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="84"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="57.75"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="81"/
<Row ss:AutoFitHeight="0" ss:Height="39" ss:StyleID="s22"
<Cell ss:StyleID="s23"<Data ss:Type="String"Year</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Quarter</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Month</Data</Cell
<Cell ss:StyleID="s23"<Data
ss:Type="String"Reference</Data</Cell
<Cell ss:StyleID="s23"<Data
ss:Type="String"Directional</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Virtual</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Total</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Entered
By</Data</Cell
</Row
<Row ss:StyleID="s25"
<Cell ss:StyleID="s26"<Data ss:Type="Number"2006</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"SUMMER</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"JUNE</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"15</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"4</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"225</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"244</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"matt</Data</Cell
</Row
<Row
<Cell ss:StyleID="s27"<Data ss:Type="Number"2004</Data</Cell
<Cell<Data ss:Type="String"WINTER</Data</Cell
<Cell<Data ss:Type="String"JULY</Data</Cell
<Cell<Data ss:Type="Number"123</Data</Cell
<Cell<Data ss:Type="Number"343</Data</Cell
<Cell<Data ss:Type="Number"333</Data</Cell
<Cell<Data ss:Type="Number"234</Data</Cell
<Cell<Data ss:Type="String"matt</Data</Cell
</Row
</Table


Matt[_43_]

Excel question: "Problems during load" - Table
 
anyone?
Matt wrote:
Hi, I'm getting an error trying to load an xml excel spreadsheet. It
says the error is on the table element, but I can't seem to see the
problem. Hoping someone might have an idea. Thanks!

<Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="3"
x:FullColumns="1" x:FullRows="1"
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="87"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="84"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="70.5"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="63.75"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="84"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="47.25"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="57.75"/
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="81"/
<Row ss:AutoFitHeight="0" ss:Height="39" ss:StyleID="s22"
<Cell ss:StyleID="s23"<Data ss:Type="String"Year</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Quarter</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Month</Data</Cell
<Cell ss:StyleID="s23"<Data
ss:Type="String"Reference</Data</Cell
<Cell ss:StyleID="s23"<Data
ss:Type="String"Directional</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Virtual</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Total</Data</Cell
<Cell ss:StyleID="s23"<Data ss:Type="String"Entered
By</Data</Cell
</Row
<Row ss:StyleID="s25"
<Cell ss:StyleID="s26"<Data ss:Type="Number"2006</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"SUMMER</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"JUNE</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"15</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"4</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"225</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="Number"244</Data</Cell
<Cell ss:StyleID="s24"<Data ss:Type="String"matt</Data</Cell
</Row
<Row
<Cell ss:StyleID="s27"<Data ss:Type="Number"2004</Data</Cell
<Cell<Data ss:Type="String"WINTER</Data</Cell
<Cell<Data ss:Type="String"JULY</Data</Cell
<Cell<Data ss:Type="Number"123</Data</Cell
<Cell<Data ss:Type="Number"343</Data</Cell
<Cell<Data ss:Type="Number"333</Data</Cell
<Cell<Data ss:Type="Number"234</Data</Cell
<Cell<Data ss:Type="String"matt</Data</Cell
</Row
</Table




All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com