PHP - How to export a table on my page in excell format or pdf

Asked By Olusegun A. on 14-Apr-11 11:44 AM
Hello gurus,
Am having a page on my site where each members can view their transactions. i echoed the transaction out in a table. i want to create a button whereby on clicking this button the page/table will be exported in microsoft excell format or pdf format, is this possible?
Ravi S replied to Olusegun A. on 14-Apr-11 12:25 PM
hi

  1. Open your PDF file that contains a table
  2. Choose the select tool by going to Tools > Select and Zoom > Select Tool
  3. Highlight the table in your PDF file
  4. Right click (or control click on Mac) on the selected table and choose Open Table in Spreadsheet.
  5. Microsoft Excel (or your default spreadsheet program) will open showing you the table
  6. You should note that the table formatting will not always be identical. This depends on how the PDF was originally made.
  7. Instead of choosing Open Table in Spreadsheet, you can also pick Copy as Table if you want to paste the table into Word or another program. You can also choose Save as Table, which will save the table as a CSV (Comma Separated Value) file that can be opened with Excel.
For further details check the following


http://techsupporthelp.org/export-pdf-tables-to-microsoft-excel/