Error Sentence excel.Save


#1

Hi!!!

This is te message of error to send me:

Server Error

The following error occurred:

[code=ICAP_RESPMOD_IO_BODY_FAIL] An IO failure occurred during the response modification of the body. Contact your system administrator.


Please contact the administrator.

This error aperce when use the sentence :

excel.Save("CVBU_FmttoCnsGral.xlS", SaveType.OpenInExcel, FileFormatType.Default, Me.Response)


#2

When calling Save method to send file to client browser, Aspose.Cells changes http headers in Reponse object. Maybe your machine don't allow such action.

Do you have any trouble to run our demos on your machine?


#3

We buy the license for de Aspose.Cells. In the development machine working fine, but when put de ASPs in the server where we have de site, the error appear.

We have some pages with this sentence, in one of them works perfectly, buy in other the error show.

What can I do?,

Actually we buy the control, mainly for the ease to send the information to Excel, but it doesn´t works, HELP ME!!!!


#4

I think you should contact your ASPs to check this problem.

Following is my code the send file to client with OpenInExcel option:

MemoryStream stream = new MemoryStream

this.Save(stream, fileFormatType);

byte[] data1 = stream.ToArray();

response.Clear();

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

//added in latest version v3.7.2

HttpCachePolicy cache = response.Cache;
cache.SetExpires(DateTime.Now - TimeSpan.FromMinutes(1));
cache.SetCacheability(HttpCacheability.Private);

response.AddHeader("pragma","no-cache");

response.AddHeader( "content-disposition","attachment; filename=book1.xls");
response.BinaryWrite(data1);
response.End();