This is a migrated thread and some comments may be shown as answers.

ExportToExcelML and Office 2000

2 Answers 47 Views
GridView
This is a migrated thread and some comments may be shown as answers.
simone bartoccioni
Top achievements
Rank 1
simone bartoccioni asked on 10 Apr 2011, 12:12 PM
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

2 Answers, 1 is accepted

Sort by
0
Accepted
Martin Vasilev
Telerik team
answered on 12 Apr 2011, 12:43 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
simone bartoccioni
Top achievements
Rank 1
answered on 12 Apr 2011, 07:37 PM
Thanks Martin  !

Sorry for my oversight.... ;)

Simone
Tags
GridView
Asked by
simone bartoccioni
Top achievements
Rank 1
Answers by
Martin Vasilev
Telerik team
simone bartoccioni
Top achievements
Rank 1
Share this question
or