Create excel sheet without installing MS Office VB.NET
-
Hi, I'm developing a webservice which reads data from a database and exports to a excel sheet. This applciation works if i have MS Office installed in my system . Since i'm unable to install MS Office in teh server is there any alternate way to program this. Thanks in advance Priya
-
Hi, I'm developing a webservice which reads data from a database and exports to a excel sheet. This applciation works if i have MS Office installed in my system . Since i'm unable to install MS Office in teh server is there any alternate way to program this. Thanks in advance Priya
Hi XML files could be a option to export files to xls format, of course, these files are not excel format, but if you only want export your tables i believe about they are util to you. Example: you have this columns in excel Column1 Column2 Data1 Line1 Data2 Line2 Data3 Line3 In xml you can generate file (text plain file) some this and open in excel and work <?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"> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font/> <Interior/> <NumberFormat/> < Protection/> </Style> <Style ss:ID="s21"> <Font x:Family="Swiss" ss:Bold="1"/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="4" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="63.36" ss:DefaultRowHeight="12.959999999999999"> <Row> <Cell ss:StyleID="s21"> <Data ss:Type="String"> Column1</Data> </Cell> <Cell ss:StyleID="s21"> <Data ss:Type="String"> Column2</Data> </Cell> </Row> <Row> <Cell> <Data ss:Type="String"> Data1</Data> </Cell> <Cell> <Data ss:Type="String"> Line1</Data> </Cell> </Row> <Row> <Cell> <Data ss:Type="String"> Data2</Data> </Cell> <Cell> <Data ss:Type="String"> Line2</Data> </Cell> </Row> <Row> <Cell> <Data ss:Type="String"> Data3</Data> </Cell> <Cell> <Data ss:Type="String"> Line3</Data> </Cell> </Row> </Table> </Worksheet> </Workbook>
Manuel say: Greetings from Mexico, Cuando salga el sol, no estare aqui... --------------------------------------- Web: http://www.otakuzone-fanzine.com Forum: