"Ignora gli errori" in Excel XML

Grazie per l'aiuto!

Sto fondamentalmente creando un file excel via XML … tutto va bene, tranne che quando apro il file in excel, ha quella freccia verde fastidiosa su each cella … quella che fai clic e ha l'opzione "ignora errore "… fondamentalmente voglio che l'XML abbia una linea che direbbe eccellere per ignorare questi" errori ".

Non voglio andare a eccellere propierties e modificare come excel mostra questo … il motivo è che il file excel sarà aperto da centinaia di persone in diversi computer … voglio solo qualcosa nel XML per notificare excel di ignorare questi errori … ecco il mio XML …

<?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"> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s_body"> <Borders> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> </Style> <Style ss:ID="s_aqua"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> <Interior ss:Color="#CCFFFF" ss:Pattern="Solid"/> </Style> <Style ss:ID="s_yellow"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> <Interior ss:Color="#FFFF40" ss:Pattern="Solid"/> </Style> <Style ss:ID="s_green"> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font x:Family="Swiss" ss:Bold="1"/> <Interior ss:Color="#6FFF6F" ss:Pattern="Solid"/> </Style> <Style ss:ID="s_wrap"> <Alignment ss:Vertical="Bottom" ss:WrapText="1"/> </Style> <Style ss:ID="s8"> <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font x:Family="Swiss" ss:Size="24" ss:Bold="1"/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="11" ss:ExpandedRowCount="9" x:FullColumns="1" x:FullRows="1"> <Column ss:Index="1" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="70"/> <Column ss:Index="2" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="120"/> <Column ss:Index="3" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="50"/> <Column ss:Index="4" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="50"/> <Column ss:Index="5" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="100"/> <Column ss:Index="6" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="85"/> <Column ss:Index="7" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="95"/> <Column ss:Index="8" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="55"/> <Column ss:Index="9" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="103"/> <Column ss:Index="10" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="90"/> <Column ss:Index="11" ss:StyleID="s_wrap" ss:AutoFitWidth="0" ss:Width="100"/> <Row ss:Height="30"> <Cell ss:MergeAcross="10" ss:StyleID="s8"> <Data ss:Type="String">Example</Data> </Cell> </Row> <Row> <Cell ss:StyleID="s_aqua"> <Data ss:Type="String">Column 1</Data> </Cell> <Cell ss:StyleID="s_aqua"> <Data ss:Type="String">Column 2</Data> </Cell> <Cell ss:StyleID="s_aqua"> <Data ss:Type="String">Column 3</Data> </Cell> <Cell ss:StyleID="s_yellow"> <Data ss:Type="String">Column 4</Data> </Cell> <Cell ss:StyleID="s_yellow"> <Data ss:Type="String">Column 5</Data> </Cell> <Cell ss:StyleID="s_yellow"> <Data ss:Type="String">Column 6</Data> </Cell> <Cell ss:StyleID="s_yellow"> <Data ss:Type="String">Column 7</Data> </Cell> <Cell ss:StyleID="s_green"> <Data ss:Type="String">Column 8</Data> </Cell> <Cell ss:StyleID="s_green"> <Data ss:Type="String">Column 9</Data> </Cell> <Cell ss:StyleID="s_green"> <Data ss:Type="String">Column 10</Data> </Cell> <Cell ss:StyleID="s_green"> <Data ss:Type="String">Column 11</Data> </Cell> </Row> <Row> <Cell> <Data ss:Type="String">800000000051</Data> </Cell> <Cell> <Data ss:Type="String">434412321</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">3665382-4</Data> </Cell> <Cell> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String"> </Data> </Cell> <Cell> <Data ss:Type="String">4</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String"> </Data> </Cell> <Cell> <Data ss:Type="String">2</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">0</Data> </Cell> </Row> <Row> <Cell> <Data ss:Type="String">800000000051</Data> </Cell> <Cell> <Data ss:Type="String">434412321</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">3665382-4</Data> </Cell> <Cell> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String"> </Data> </Cell> <Cell> <Data ss:Type="String">4</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String">0</Data> </Cell> <Cell> <Data ss:Type="String"> </Data> </Cell> <Cell> <Data ss:Type="String">2</Data> </Cell> <Cell ss:StyleID="s_body"> <Data ss:Type="String">0</Data> </Cell> </Row> </Table> <DataValidation xmlns="urn:schemas-microsoft-com:office:excel"> <Range>R2C2:R1000C2</Range> <Type>List</Type> <CellRangeList/> <Value>"Red, Black, Green"</Value> </DataValidation> </Worksheet> </Workbook> 

I marcatori verdi indicano che esistono stringhe in una cella che somigliano ad Excel per essere un numero .

Provare ss:Type="Number" per tutti i valori numbersci invece di ss:Type="String" e si liberano i marcatori verdi, ad esempio

  <Cell> <Data ss:Type="Number">800000000051</Data> </Cell> <Cell> <Data ss:Type="Number">434412321</Data> </Cell> <Cell> <Data ss:Type="String">Some Text</Data> </Cell>