Excel sheet

Question

string fname = drop.SelectedValue + .xls; string namee = fname; System.IO.FileInfo finfo = new System.IO.FileInfo(fname); Response.Clear(); Response.AppendHeader(content-type application/x-msexcel); Response.AppendHeader(content-disposition attachment; filename= + drop.SelectedItem.Text + .xls); Response.End(); // I have created empty Excel Sheet but the problem is while opening its show me error like the file u r trying to open filename.xls is in a different format than specified by the file extension verify that the file is not corrupted and it from a trusted source before opening the file

Pranay Kant · Answer

You could refer to the article from codeproject Using C# to create an Excel or you could simple use some third party library like free Spire.XLS to create Excel with simple code.

Rojalin Sahoo · Answer

If it is an empty file you want to create it through .Net then to stop this warning message you can b uild the file as .csv with .csv extension but leave the content-type as Excel so that it opens with Excel. Response.AppendHeader(content-type application/x-msexcel); Response.AppendHeader(content-disposition attachment; filename=file1.csv); To find more you can follow these : excel-2007-extension-warning How to export excel(xls)file without warning message Warning message

akshay rasalakar · Answer

Can Anybody Know how to create Excel Sheet in asp.net with c# and the file extension must be .xls it should not be corrupted while opening the file and Thanks In Advance......

Bobby Milligan · Answer

Your problem is not with the Response's header you problem is with the Response's content that you are writing. The code that you posted does not write anything so I presume it will create a completely empty XLS file which is of course invalid. Is that a complete code that you use? If not then post the part regarding the Response's writing so that we may take a look at it. If it is then your code is not complete nevertheless here is how you can create an excel file in C# . The article demonstrates how to generate a new XLS file by using this C# component for excel files . I hope it helps.

akshay rasalakar · Answer

Still im getting the same error

Khan Abrar Ahmed · Answer

Hi try this string fname = drop.SelectedValue + .xls; string namee = fname; System.IO.FileInfo finfo = new System.IO.FileInfo(fname); Response.Clear(); Response.AddHeader(Content-Disposition attachment; filename= + drop.SelectedItem.Text + .xls); Response.ContentType = application/x-msexcel; Response.End(); if contenet type will not work then try the below content type Response.ContentType = application/vnd.ms-excel;