Issues with excel 2000 xsl template
Dev environment: Office 2003, VS2005
Server environment: Office 2000, Win 2003 server.
exporting data to excel using xsl. every thing works fine in my local
machine. But not in server. When i open the exported excel report on server,
it was showing entire data in the first cell. no formating , no header.
below is the xml spreedshet for you reference. I am able to see the proper
excel on my local pc but not on the server. Any help would be greatly
appreciated.
<?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"
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"
</ExcelWorkbook
<Styles
<Style ss:ID="Default" ss:Name="Normal"
<Alignment ss:Vertical="Bottom"/
<Borders/
<Font/
<Interior/
<NumberFormat/
<Protection/
</Style
</Styles
<Worksheet ss:Name="Sheet1"
<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1"
<Row
<Cell<Data ss:Type="String"test</Data</Cell
<Cell<Data ss:Type="String"test1</Data</Cell
<Cell<Data ss:Type="String"test2</Data</Cell
</Row
</Table
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<Selected/
<Panes
<Pane
<Number3</Number
<ActiveCol2</ActiveCol
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<Worksheet ss:Name="Sheet2"
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
<Worksheet ss:Name="Sheet3"
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
</Workbook
Regards,
Chandana.
|