Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Incompatibility between Excel 11 (2003) and Excel 12 (2007)

I have a little problem I'm hoping someone can help with:

I have a Web application that creates an XLS file from XML/HTML data using
the following code:

private void doTheReportThing(string html, bool sendXLS) {
//Force this content to be downloaded
//as a excel document with the name of your choice
if (sendXLS) {
//Response.ClearHeaders();
//Response.ClearContent();
Response.AddHeader("Content-Type", "application/msexcel");
Response.AddHeader("Content-disposition", "attachment;
filename=" + this.form.ReportFilter.ToString() + ".xls");
Response.Charset ="utf-7";
Response.ContentEncoding = Encoding.UTF7;
Response.Write(html);
Response.End();
} else {
Response.Write("<html<body" + html + "</body</head");
}
}

The file it creates opens fine in Excel 11 (2003), but when I try to open it
in Excel 12 (2007), I get an error message from Excel which says: "cell data
too large" and the contents of the file are displayed in cell A1 of the
worksheet.

Can anyone give me any ideas as to why the files won't open correctly in
Excel 12 (2007)?

Thanks in advance,
pete
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible Bumpersnesty Excel Worksheet Functions 0 April 26th 10 09:44 PM
All-in-one printing incompatibility with EXCEL in landscape mode ccorley New Users to Excel 3 September 23rd 09 04:17 PM
2008-2003 incompatibility [email protected] Excel Programming 0 January 21st 08 05:43 AM
Excel 2000 and 2003 VBA and Macros Incompatibility Wboson Excel Programming 1 March 25th 05 10:35 PM
Excel 2000 v 2003 Macro & VBA Incompatibility Wboson Excel Programming 0 March 25th 05 09:13 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"