Creating Excel file in asp.net using vb without installing office

[mukeshmc]

I want create my output in excel file. But in server i cannot install office, its too costly

i am developing it with vishual studio2005 with vb.


so anybody can give the solution for this


thanks in advance

[tlhintoq]

You don't need Office installed to use the .Net framework, which has office namespace.

http://msdn.microsoft.com/en-us/library/bb726434.aspx

[YonngTyler]

If you open the output excel file within the browser(inline), you can just output a html with Response.ContentType = "application/vnd.ms-excel". In the html you can use a table to render you data.
If you need to generate a complex excel file and you don't know what the html codes should be, you can:
1. create a similar excel as what you want via Microsoft Excel.
2. save it as a html file, you will get the html codes.