Visualforce To Excel

Posted by Unknown 02:11

In this short post I want to explain how we can generate an excel output from a VF page.  We already know to how to generate a PDF from VF page. (Read more to find out how). One of the common requirements is to convert a VF page with data into an Excel sheet, here are some things you may want to keep in mind

1. Use a separate VF page for export. It is advisable to use a separate VF page to export off, reason being, usually the VF page in which data resides contains buttons, links images etc. and that is not something you usually want in your excel
2. Use <apex:dataTable> : this gives you a consistent output and works for both windows and MAC. (Thank you Pratyush Kumar  for the Info)
3. Proper validation : Before the export page is reached, make sure all validations to ensure data will be present is  a good practice

How to add Drop-down list in Excel

Posted by Unknown 23:37

This is just a basic article to illustrate how to insert a drop-down list in excel worksheet.

In Microsoft Office 2007 it is not very difficult once we are used to it.