How to export html table to excel or pdf in php

Question

In my php page i have a table and if the user requires he has to export that table to excel sheet     The code for displaying the table is    sql mysql query  SELECT   FROM attendance WHERE  year         mysql real escape string   SESSION  year          and   branch        mysql real escape string    SESSION  branch          and   sem        mysql real escape string    SESSION  sem          and  sec        mysql real escape string    SESSION  sec             print   lt body  background  bg jpg  gt                                                      Print   lt br gt  lt br gt  lt BR gt  lt center gt  lt table border  cellpadding 3 gt  lt tr gt  lt th gt idno lt  th gt  lt th gt name lt  th gt  lt th gt subject lt  th gt  lt th gt Held  Classes lt  th gt  lt th gt Attended Classes lt  th gt  lt  tr gt       while  data mysql fetch array    sql          echo   lt tr gt  lt td gt    data  idno      lt  td gt  lt td gt    data  name         lt td gt    data  subject      lt  td gt  lt td gt    data  heldcls         lt td gt    data  attendcls      lt  td gt       Print   lt  table gt  lt br gt  lt br gt  lt form action   excel php method   POST gt  lt input type     submit  name    submit  Value    Export to excel  gt  lt  form gt  lt  center gt      how do i export this table to excel sheet  And what should b the code in excel php  Please help me   thank you in advance

User · Answer

If all you want is a simple excel worksheet try this:

header('Content-type: application/excel');
$filename = 'filename.xls';
header('Content-Disposition: attachment; filename='.$filename);

$data = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">
<head>
    <!--[if gte mso 9]>
    <xml>
        <x:ExcelWorkbook>
            <x:ExcelWorksheets>
                <x:ExcelWorksheet>
                    <x:Name>Sheet 1</x:Name>
                    <x:WorksheetOptions>
                        <x:Print>
                            <x:ValidPrinterInfo/>
                        </x:Print>
                    </x:WorksheetOptions>
                </x:ExcelWorksheet>
            </x:ExcelWorksheets>
        </x:ExcelWorkbook>
    </xml>
    <![endif]-->
</head>

<body>
   <table><tr><td>Cell 1</td><td>Cell 2</td></tr></table>
</body></html>';

echo $data;

The key here is the xml data. This will keep excel from complaining about the file.

User · Answer

Either you can use CSV functions or PHPExcel   or you can try like below   lt  php  file  demo xls    test   lt table   gt  lt tr gt  lt td gt Cell 1 lt  td gt  lt td gt Cell 2 lt  td gt  lt  tr gt  lt  table gt    header  Content-type  application vnd ms-excel    header  Content-Disposition  attachment  filename  file    echo  test    gt    The header for  xlsx files is Content-type  application vnd openxmlformats-officedocument spreadsheetml sheet

User · Answer

Use a PHP Excel for generatingExcel file   You can find a good one called PHPExcel here  https   github com PHPOffice PHPExcel  And for PDF generation use http   princexml com

User · Answer

Easiest way to export Excel to Html table   file name   file name xls    excel file  Your Html Table Code   header  Content-type  application vnd ms-excel    header  Content-Disposition  attachment  filename  file name    echo  excel file

User · Answer

lt script src  jquery min js  gt  lt  script gt   lt table border  1  id  ReportTable  class  myClass  gt       lt tr bgcolor   CCC  gt         lt td width  100  gt xxxxx lt  td gt         lt td width  700  gt xxxxxx lt  td gt         lt td width  170  gt xxxxxx lt  td gt         lt td width  30  gt xxxxxx lt  td gt       lt  tr gt       lt tr bgcolor   FFFFFF  gt         lt td gt  lt  php                               date   date create  row Recordset3  fecha                 echo date format  date   d-m-Y                  gt  lt  td gt         lt td gt  lt  php echo  row Recordset3  descripcion      gt  lt  td gt         lt td gt  lt  php echo  row Recordset3  producto      gt  lt  td gt         lt td gt  lt img src  borrar png  width  14  height  14  class  clickable  onClick  eliminarSeguimiento  lt  php echo  row Recordset3  idSeguimiento      gt    title  borrar  gt  lt  td gt       lt  tr gt     lt  table gt      lt input type  hidden  id  datatodisplay  name  datatodisplay  gt         lt input type  submit  value  Export to Excel  gt     exporttable php   lt  php header  Content-Type  application force-download    header  Content-disposition  attachment  filename export xls       Fix for crappy IE bug in download  header  Pragma      header  Cache-Control      echo   REQUEST  datatodisplay      gt

[php] How to export html table to excel or pdf in php

Examples related to php