I have create a VFpage with PageblockTable which has header and footer and using contentType to export it in excel format, but in export file the header and footer are coming together at the top of the column.I need to use pageBlockTable only.
Restriction ,that I have to use pageblock table only to show data .But while exporting the data the Header and footer is comming together and below that column data is show.
You can put the data table inside a div and use Jquery or Java Scrip onClick function which would download the table. Regards,
Avishek
Output In excel