Problem Sending Excel Document to a Client Browser

Aspose.Cells Product Family
1

I am opening a document using excel.open, changing some cell values, and then trying to display the document in the browser. I am using the following code to open the doc:

excel.Save("ConferenceCallReport.xls", SaveType.OpenInExcel, FileFormatType.Default, Me.Response)

The result is a blank document with the first sheet titled ".xls]ConferenceCallReport[1]"

If I try to save the document to a directory, ie: excel.save("c:\text.xls"), the file saves correctly and all of the cell values are correct.

The demo program works correctly and allows me to open documents from the browser.

Any ideas?

2

Have you used http compression in your IIS? Or do you use https?

3

No http compression or https…

4

Could you please zip your project and post it here? I will check it ASAP.

5

And could you please try to run your program in another machine?

6

@ATrien,
Aspose.Cells supports saving file to the response object for the client browser. You can send files to browsers in any format like XLSX, XLS, PDF, etc. Here is an example that demonstrates sending the PDF file to the client browser.

HttpResponse Response = null;

// Initialize the workbook object
Workbook wb = new Workbook();

if (Response != null)
{
    // Send file in PDF format
    wb.Save(Response, dataDir + "output.pdf", ContentDisposition.Attachment, new PdfSaveOptions());
    Response.End();
}

P.S. Aspose.Excel is discontinued and no more available now. It is replaced by Aspose.Cells.

You may refer to the following article for more details about sending files to client browsers:
Saving file to Response Object

You can test the new product features by downloading the latest version here:
Aspose.Cells for .NET(Latest version)

A runnable solution is available here that can be used to test the new product without writing any code.