Skip to main content
We have a UI where we are showing list of the records in a grid/table structure on Visualforce page. Now the requirement is that we need to provide the ability to download those records in the xls sheet with custom format and color coding. Please find attached xls sheet as an example of format we want.

 

FYI : In Salesforce, we can save the VF page as xls but that is in very simple format without any color coding and formatting.
1 resposta
  1. 5 de set. de 2014, 16:10
    You would have to write a custom Apex controller for your page.  I don't think you want to try to write a binary XLS with all the attributes, but you might be able to come up with a way to translate your VF markup to RTF (rich text format) that Excel could read.

     

    Head on over to the forums and sample code at developer.salesforce.com. They focus on programming technologies related to Salesforce.