ExportToExcelML and Office 2000

[Simone]

Hi 

Is ExportToExcelML compatible with Office 2000 ?

Attached there is an example how Excel 2000 shows it.

The content of xls file :

<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Styles>
<Style ss:ID="CellStyle0">
<Alignment ss:Horizontal="Center" ss:Vertical="Center"></Alignment>
<Font ss:FontName="Segoe UI" ss:Color="#000000"></Font>
<Interior ss:Pattern="Solid" ss:Color="#D9E7F9"></Interior>
<NumberFormat></NumberFormat></Style>
<Style ss:ID="CellStyle1">
<Alignment ss:Horizontal="Left" ss:Vertical="Center"></Alignment>
<Font ss:FontName="Segoe UI" ss:Color="#000000"></Font>
<Interior ss:Pattern="Solid" ss:Color="#FFFFFF"></Interior>
<NumberFormat></NumberFormat></Style>
<Style ss:ID="CellStyle2">
<Alignment ss:Horizontal="Left" ss:Vertical="Center"></Alignment>
<Font ss:FontName="Segoe UI" ss:Color="#000000"></Font>
<Interior ss:Pattern="Solid" ss:Color="#FFFFFF"></Interior>
<NumberFormat ss:Format="gg/mm/aaaa"></NumberFormat></Style>
<Style ss:ID="CellStyle3">
<Alignment ss:Horizontal="Right" ss:Vertical="Center"></Alignment>
<Font ss:FontName="Segoe UI" ss:Color="#000000"></Font>
<Interior ss:Pattern="Solid" ss:Color="#FFFFFF"></Interior>
<NumberFormat></NumberFormat></Style></Styles>
<Worksheet ss:Name="Lavori">
<Table>
<Column ss:Width="150"></Column>
<Column ss:Width="150"></Column>
<Column ss:Width="150"></Column>
<Column ss:Width="150"></Column>
<Column ss:Width="60"></Column>
<Column ss:Width="90"></Column>
<Column ss:Width="90"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="90"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="90"></Column>
<Column ss:Width="50"></Column>
<Column ss:Hidden="1" ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Column ss:Width="50"></Column>
<Row ss:Height="24">
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Cliente</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Utente</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Argomento</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Descrizione</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Attivo</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Assegnazione</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Inizio</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Priorità</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Termine Previsto</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Termine</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Consegna</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Riferimenti_Consegna</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Contratto</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Importo</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Num_Fattura</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Data_Fattura</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Note_Fattura</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">ID_Argomento</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">Consegnato</Data></Cell>
<Cell ss:StyleID="CellStyle0">
<Data ss:Type="String">D.Revisione</Data></Cell></Row>
<Row ss:Height="19">
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String">XXXXX S.p.A.</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String">Vincenzo</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String">YYYYY - VdR Chimico</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="Boolean">1</Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="Boolean">1</Data></Cell>
<Cell ss:StyleID="CellStyle3">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="Number">25</Data></Cell>
<Cell ss:StyleID="CellStyle1">
<Data ss:Type="Boolean">0</Data></Cell>
<Cell ss:StyleID="CellStyle2">
<Data ss:Type="DateTime">1900-01-01T00.00.00.000</Data></Cell></Row></Table></Worksheet></Workbook>

Thanks
Simone

[Martin Vasilev]

Hello simone bartoccioni,

Thank you for writing.

Unfortunately MS Office 2000 does not support the ExcelML format. This format can be used with MS Excel 2002 (MS Office XP) or newer. You can try Export to Excel via Primary Interop Assemblies or use ExportToCSV instead. 

Let me know if you have any additional questions.

Regards,
Martin Vasilev
the Telerik team

[Simone]

Thanks Martin  !

Sorry for my oversight.... ;)

Simone