how to open a blank excel file with headers in asp.net using

Question

i want to generate excel file with only header in asp.net.. like Name Gender Standard

Ring Zhong · Answer

Create an excel file with the template of your choice place the file inside a directory of your website. Create link on a page to the file the link below may also help you. http://office.microsoft.com/en-in/excel-help/customizing-excel-defaults-with-templates-HA001054815.aspx

Sunny Sharma · Answer

Hi Hardik Use this code: ------------------------------------------------------------------- Application NewExcelApp = new ApplicationClass(){ Visible = false }; _Workbook NewWorkBook = NewExcelApp.Workbooks.Add(Missing.Value); _Worksheet NewWorkSheet = (_Worksheet)NewWorkBook.ActiveSheet; NewWorkSheet.Cells[1 1] = Name; NewWorkSheet.Cells[1 2] = Gender; NewWorkSheet.Cells[1 3] = Standard; NewWorkSheet.SaveAs(fname + .xls Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value Missing.Value); NewWorkBook.Close(Missing.Value Missing.Value Missing.Value); NewWorkSheet = null; NewWorkBook = null; NewExcelApp.Quit(); ---------------------------------------------------------------------------------------- HTH :)