2

I'm writing a Visualforce page which downloads an Excel file onto the user's computer. I have done this by adding the following to the <apex:page> tag: contentType="application/vnd.ms-excel#My File Name.xls" cache="true"

This successfully downloads a file which opens in Excel, however I get the error that the file format and extension don't match. This is because I am actually opening a Web Page in Excel. When I go to save it, I have to change the file type from Web Page to Excel Workbook.

Is there any way to automatically download the page as an Excel Workbook to avoid these two issues?

Thanks

2
  • try this content type contentType="application/x-excel#RenderAsTestFile.xls" – Tushar Sharma Oct 8 '15 at 12:44
  • @TusharSharma Sorry, that didn't make a difference. – fred Oct 8 '15 at 12:59
3

The content of the page must be tabular format to be displayed as excel file.

You can make sure of that as follows

  • Remove the sfdc html/style coponents
    <apex:page standardStylesheets="false" showHeader="false"/>

  • Render data in tabular format (Use standard HTML tags, instead of apex:dataTable)
    e.g.,

    <table> <thead><tr><th>Header</th></tr></thead> <tbody><tr><td>Data</td></tr></tbody> </table>

2
  • Sorry, that didn't work either. – fred Oct 9 '15 at 9:48
  • do not keep anything but the table. after the page tag, only data should remain inside tables. – San Tosh Oct 9 '15 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.