Hello,
We are having issues with opening an generated xlsx file. Our application saves the xlsx file in the database (the content). Now when the client machine searches and accesses the xlsx file, the content is sent through response and header mentioning the according MIME type.
The client machines having Office 2007 installed are able to view the files, however the machine that has only Office 2007 compatbility pack is unable to view the files. Should we include any additional code when we send the content through response for xlsx? Please let us know
Hi,
Please try the following code and let us know if it works fine:
'Save in xlsx format and send the file to user so that he may open the file in
'some application or save it to some location
workbook.Save("Report.xlsx", FileFormatType.Excel2007Xlsx, SaveType.OpenInExcel, Response)
Response.End()
And for reference, please check the last part of the document:
http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/saving-files.html
Thank you.
Amjad,
Thanks for the reply. Will the code provided open the xlsx file using respsone on a client machine that has no Office 2007 installed but only compatability pack for Office 2007?
As there is no full insatllation we suspect the browser is not able to recognize the new file type. Please let us know.
Hi,
Well, I think you need to install MS Excel 2007 on the client end if your client want to display/view the generated xlsx file on the fly.
Thank you.
Amjad,
Will the office 2007 compatability installed on the client machine identify the response type and open the xlsx file?
Hi,
Yes, I think you may open/view the generated Excel 2007 xlsx files into an Excel upgraded with office 2007 Compatibility Pack. Please check the document for your reference: open 2007 file in IE :http://support.microsoft.com/kb/948615
Thank you.