![]() |
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