content type for xlsx file

Question

1.62/5 (3 votes)

See more:

pls give the content type for open a xlsx file in broowser....

i alredy used

VB

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

but it is not useful...i cant open the xlsx file...

pls help me

Posted 21-Oct-12 19:46pm

__PP__

Updated 29-Mar-19 4:55am

Add a Solution

2 solutions

Solution 2

hi,
I am also Facing Same Problem but I got some alternator If It can help u

(1)Check This One on stackoverflow

http://stackoverflow.com/questions/13724988/unable-to-generate-the-xlsx-file

2)always use
Response.ContentType = "application/vnd.ms-excel";

Just Change the File extention from xlsx to xls
and open it it will work

Posted 10-Dec-13 23:55pm

s.amittyagi

Comments

SALIM MANDREKAR 19-Aug-14 2:15am

its not working

SALIM MANDREKAR 19-Aug-14 2:16am

GridView2.DataSource = dt;
GridView2.DataBind();
DirectoryInfo dir = new DirectoryInfo(@"C:\Reports");
dir.Create();
StringBuilder Excelfile = new StringBuilder("ExcelReport(");
//Excelfile.Append(DateTime.Now.ToString("MMM dd, yyyy "));
Excelfile.Append(DateTime.Now.ToString("MMM dd,HH.mm"));
Excelfile.Append(").xlsx");
FileInfo file = new FileInfo(@"C:\Reports\" + Excelfile);//C:\List Data\
StreamWriter streamWriter = file.CreateText();

StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
GridView2.RenderControl(htmlTextWriter);
streamWriter.Write(stringWriter.ToString());

htmlTextWriter.Close();
streamWriter.Close();
stringWriter.Close();
Session.Remove("TempCatering");
byte[] Content = File.ReadAllBytes(@"C:\New List Reports\" + file.Name);
Response.ContentType ="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.SetCookie(new HttpCookie("token", Request.Form["token"]));
Response.AddHeader("content-disposition", "attachment; filename=" + file.Name);
Response.BufferOutput = true;
Response.OutputStream.Write(Content, 0, Content.Length);
Response.End();

kpranav 21-Oct-21 18:36pm

For Excel 2007 and above the MIME type differs, why is application/application twice?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Amy · Accepted Answer · 2012-10-21T19:55:00

The content type for .xlsx files is:

C#

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Or use this:

C#

Response.ContentType = "application/vnd.ms-excel";

Response.AppendHeader("content-disposition", "attachment; filename=myfile.xls");

For Excel 2007 and above the MIME type differs

C#

Response.ContentType = "application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

Response.AppendHeader("content-disposition", "attachment; filename=myfile.xlsx");

Or if you are trying to read the file then try this:

C#

DataSet objds = new DataSet();
string ConnStr = "";
if (FileExtension == ".xlsx")
{
    ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName + ";Extended Properties=\"Excel 12.0 Xml;HDR=No;IMEX=1\";";
}
else
{
    ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\";";

}
OleDbCommand selectCommand = new OleDbCommand();
OleDbConnection connection = new OleDbConnection();
OleDbDataAdapter adapter = new OleDbDataAdapter();
connection.ConnectionString = ConnStr;
string strSQL = "SELECT * FROM [Sheet1$]";
if (connection.State != ConnectionState.Open)
    connection.Open();
OleDbCommand cmd = new OleDbCommand(strSQL, connection);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(objds);
connection.Close();

All the best.
--Amit