C# Excel 2007 Error

Question

I have a simple code like this. This code simply exporting gridwiev to excel file..

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=cat5.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");
//Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "windows-1254";
//Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.ContentType = "application/vnd.ms-excel";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();

But our company some users usign Excel 2003, some user using Excel 2007. When i run this code, there is no problem Excel 2003. But there is some problem in Excel 2007 like this pictures.

alt text

How can i solve this problem? Is there anybody have an idea?

Best Regards, Soner.

Does this happen for all gridsizes? I had problems exporting to Excel from some library that got "solved" by appending some empty rows to get the filesize above (I think) 7k. — Hans Keﬆing
– Hans Keﬆing, Commented Dec 22, 2010 at 9:04
I don't calculate any filesize of gridsize or what? Just writing this code and run it. MY question is what is the different excel 2003 and excel 2007.. — Soner Gönül
– Soner Gönül, Commented Dec 22, 2010 at 9:26

VinayC · Accepted Answer · 2010-12-22 09:53:39Z

2

I believe that this is by design (in Excel 2007): see http://blogs.msdn.com/b/vsofficedeveloper/archive/2008/03/11/excel-2007-extension-warning.aspx

Possible work-around can be generating either csv file on server (but you will loose formatting) or generating actual excel file (using excel automation or 3rd party tool).

answered Dec 22, 2010 at 9:53

VinayC

49.6k7 gold badges64 silver badges74 bronze badges

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

1 Comment

Tom Over a year ago

I too have encountered this before and I specified a .xlsx extension and all was well. Fortunately I could rely on the fact we were all using Office 2007, but that's a bit more tricky here.

markmolamhoi · Accepted Answer · 2014-03-14 09:16:57Z

0

try to remove this line:

Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");

Then Cell data too large will be fixed.

answered Mar 14, 2014 at 9:16

markmolamhoi

1411 silver badge4 bronze badges

Collectives™ on Stack Overflow

C# Excel 2007 Error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related