File type different type warning export excel using MVC

Question

When I download excel using this code I am getting the warning. "The file type you are trying to open is in a different format...." How to avoid this?

 public FileResult ExportExcel()
        {
            DataTable  dt = new DataTable();
            DataRow dr = dt.NewRow();
            dt.Columns.Add("name");
            dr["name"] = "test";
            dt.Rows.Add(dr);

            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            string csv_text = ToCSV(dt);
            byte[] toBytes = Encoding.ASCII.GetBytes(csv_text);

            return File(toBytes, "application/ms-excel", "mytestfile.xls");
        }

Duplicate

Stacked
– Stacked

2016-06-22 17:19:02 +00:00
Commented Jun 22, 2016 at 17:19 — Stacked
– Stacked, Commented Jun 22, 2016 at 17:19

Alan Donnelly · Accepted Answer · 2016-06-23 08:56:53Z

1

What you're trying to download is a just CSV file, not an Excel spreadsheet, try changing the return statement to:

return File(toBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "mytestfile.csv");

If you need to create an Excel doc, use something like ExcelLibrary

answered Jun 23, 2016 at 8:56

Alan Donnelly

791 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

File type different type warning export excel using MVC

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related