Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XML defaulting ss:Type 4 all cells in a column, not ineach <data
I am creating an XML with many rows, report style. All cells in a given
column are always, numbers or strings. Is there any way to default the ss:Type in <Data to the column? so the file becomes substantially smaller? Current: <Cell<Data ss:Type="Number"30</Data</Cell Wanter: <Cell<Data30</Data</Cell Getting the following error in the log when opening the file if I remove the ss:Type="Number" XML ERROR in Table REASON: Missing Tag FILE: C:\r7b.xml GROUP: Cell TAG: Data ATTRIB: Type |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defaulting the margins | Excel Worksheet Functions | |||
I type in 1-2, how can I keep that from defaulting to a date? | Excel Discussion (Misc queries) | |||
How I type SOLD across column length without changing current data | Charts and Charting in Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |