ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Issues with excel 2000 xsl template (https://www.excelbanter.com/excel-programming/429298-issues-excel-2000-xsl-template.html)

Chandana

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.


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com