Excel sheet

akshay rasalakar

11y1.2k.NET

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pranay Kant11y ago
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.
+1
akshay rasalakar11y ago
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......
0
Bobby Milligan11y ago
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.
0
akshay rasalakar11y ago
Still im getting the same error
0
Khan Abrar Ahmed11y ago
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";
0
Rojalin Sahoo11y ago
If it is an empty file you want to create it through .Net then to stop this warning message you can build 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
+1