Merge Cell values with PHPExcel - PHP

Question

I have a simple table like      - id  - first name - last name - email - phone    I m using PHPExcel to export my data in XLS format         rowNumber   1      while   row   mysql fetch row  result             col    A          foreach  row as  cell               objPHPExcel- getActiveSheet  - setCellValue  col  rowNumber  cell              col                     rowNumber            Now I want to merge the two fields first name  amp  last name in one Cell  I tried      rowNumber   1     while   row   mysql fetch row  result         objPHPExcel- getActiveSheet  - setCellValue  A   rowNumber  row  id                                     - setCellValue  B   rowNumber  row  first name                                     - setCellValue  C   rowNumber  row  last name                                                                           rowNumber         But I get errors and don t works  Any help

User · Answer

this- gt excel- gt setActiveSheetIndex 0 - gt mergeCells  A    p    B    p    for dynamic merging of cells

User · Answer

There is a specific method to do this    objPHPExcel- gt getActiveSheet  - gt mergeCells  A1 C1      You can also use    objPHPExcel- gt setActiveSheetIndex 0 - gt mergeCells  A1 C1      That should do the trick

User · Answer

Try this   objPHPExcel- gt getActiveSheet  - gt mergeCells  A1 C1

[php] Merge Cell values with PHPExcel - PHP

Examples related to php

Examples related to phpexcel

Examples related to phpspreadsheet