Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
What is "Problems during load"? | Excel Discussion (Misc queries) | |||
Do anyone know about "Problems During Load"? | Excel Discussion (Misc queries) | |||
unable to load "Excel" analysis toolpak tried the tools and brows | Excel Discussion (Misc queries) | |||
Opening An Excel Application and "Analysis ToolPac" does not load | Excel Programming |