Announcement

Collapse
No announcement yet.

Excel Export, Groups to Excell sheets

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Export, Groups to Excell sheets

    Is there somebody in this forum who suceed to export a grid in Excell and dispatch each sql "group by" in a distinct sheet in the same xls file like in the screen copy.

    I would like to export user time sheet, each user in a distinct sheet.

    If yes, where is it specify in the parameters ?

    Laurent.


  • #2
    why not make an sql with your groupby
    1. to start make new worksheet with name of first groupby
      $objPHPExcel->createSheet(); $sheet = $objPHPExcel->setActiveSheetIndex($sheet); $sheet->setTitle("$value");
    2. loop through the record and paste cells - setCellValue('A1', Hello)
    3. when groupby changes (IF) make a new worksheet and paste the cells - createSheet(name);
    4. repeat steps

    just an idea

    Comment


    • #3
      I would like to use the scriptcase Excel native export functionality, but it is a good workaround.

      Thank you nonkelmike

      Comment

      Working...
      X