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 :)

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

Answers (2)