PHPExcel Make first row bold

Question

I am trying to make cells in first row are bold   This is the method I have created for that purpose   function ExportToExcel  tittles  excel name        objPHPExcel   new PHPExcel       objRichText   new PHPExcel RichText         Set properties    objPHPExcel- gt getProperties  - gt setCreator  SAMPLE1       objPHPExcel- gt getProperties  - gt setLastModifiedBy  SAMPLE1       objPHPExcel- gt getProperties  - gt setTitle  SAMPLE1       objPHPExcel- gt getProperties  - gt setSubject  SAMPLE1       objPHPExcel- gt getProperties  - gt setDescription  SAMPLE1           Add some data    objPHPExcel- gt setActiveSheetIndex 0       letters   range  A   Z       count  0     cell name       foreach  tittles as  tittle          cell name    letters  count   1       count        value    tittle      objPHPExcel- gt getActiveSheet  - gt SetCellValue  cell name   value         Make bold cells     objPHPExcel- gt getActiveSheet  - gt getStyle  cell name - gt getFont  - gt setBold true            Save Excel 2007 file    objWriter   new PHPExcel Writer Excel2007  objPHPExcel        objWriter- gt save str replace   php     xlsx     FILE         objWriter- gt save  excel name   xlsx         The problem is in output excel file the cells are not bold

User · Answer

objPHPExcel- gt getActiveSheet  - gt getStyle  A1    objPHPExcel- gt getActiveSheet  - gt getHighestDataColumn    1  - gt getFont  - gt setBold true     I found this to be a working solution  you can replace the two instances of 1 with the row number  The HighestDataColumn function returns for example C or Z  it gives you the last highest column that s in the sheet containing any data  There is also getHighestColumn    that one would include cells that are empty but have styling or are part of other functionality

User · Answer

Assuming headers are on the first row of the sheet starting at A1  and you know how many of them there are  this was my solution    header   array       Header 1        Header 2       objPHPExcel   new PHPExcel     objPHPExcelSheet    objPHPExcel- gt getSheet 0    objPHPExcelSheet- gt fromArray  header  NULL    first letter   PHPExcel Cell  stringFromColumnIndex 0    last letter   PHPExcel Cell  stringFromColumnIndex count  header -1    header range      first letter 1   last letter 1    objPHPExcelSheet- gt getStyle  header range - gt getFont  - gt setBold true

User · Answer

Use this    sheet- gt getStyle  A1    sheet- gt getHighestColumn    1  - gt getFont  - gt setBold true

User · Answer

Try this           objPHPExcel   new PHPExcel         objPHPExcel- getProperties  - setCreator  Maarten Balliauw                                    - setLastModifiedBy  Maarten Balliauw                                    - setTitle  Office 2007 XLSX Test Document                                    - setSubject  Office 2007 XLSX Test Document                                    - setDescription  Test document for Office 2007 XLSX  generated using PHP classes                                     - setKeywords  office 2007 openxml php                                    - setCategory  Test result file         objPHPExcel- setActiveSheetIndex 0        sheet    objPHPExcel- getActiveSheet         sheet- setCellValue  A1    No         sheet- setCellValue  B1    Job ID         sheet- setCellValue  C1    Job completed Date         sheet- setCellValue  D1    Job Archived Date         styleArray   array           font     array           bold     true                       sheet- getStyle  A1  - applyFromArray  styleArray        sheet- getStyle  B1  - applyFromArray  styleArray        sheet- getStyle  C1  - applyFromArray  styleArray        sheet- getStyle  D1  - applyFromArray  styleArray        sheet- getPageSetup  - setRowsToRepeatAtTopByStartAndEnd 1  1         This is give me output like below link  https   www screencast com t ZkKFHbDq1le

User · Answer

You can try   objPHPExcel- gt getActiveSheet  - gt getStyle 1 - gt getFont  - gt setBold true

User · Answer

objPHPExcel- gt getActiveSheet  - gt getStyle  1 1  - gt getFont  - gt setBold true     That way you get the complete first row

User · Answer

These are some tips to make your cells Bold  Big font  Italic  Let s say  I have columns from A to L  A1 - is your starting cell  L1 - is your last cell   objPHPExcel- gt getActiveSheet  - gt getStyle  A1 L1  - gt getFont  - gt setBold true    objPHPExcel- gt getActiveSheet  - gt getStyle  A1 L1  - gt getFont  - gt setSize 16    objPHPExcel- gt getActiveSheet  - gt getStyle  A1 L1  - gt getFont  - gt setItalic true

User · Answer

This iterates through a variable number of columns of a particular row  which in this case is the 1st row    rownumber   1   row    this- gt objPHPExcel- gt getActiveSheet  - gt getRowIterator  rownumber - gt current      cellIterator    row- gt getCellIterator     cellIterator- gt setIterateOnlyExistingCells false    foreach   cellIterator as  cell         cell- gt getStyle  - gt getFont  - gt setBold true

User · Answer

Try this for range of cells    from    A1      or any value  to    B5      or any value  objPHPExcel- gt getActiveSheet  - gt getStyle   from  to  - gt getFont  - gt setBold  true      or single cell   cell name    A1    objPHPExcel- gt getActiveSheet  - gt getStyle   cell name  - gt getFont  - gt setBold  true      hope that helps

User · Answer

Try this   objPHPExcel- gt getActiveSheet  - gt getStyle  A1 D1  - gt getFont  - gt setBold true

User · Answer

The simple way to make bold headers   row   1  foreach  tittles as  index   gt   tittle         worksheet- gt getStyleByColumnAndRow  index   1   row - gt getFont  - gt setBold true        worksheet- gt setCellValueByColumnAndRow  index   1   row   tittle

[php] PHPExcel Make first row bold

Examples related to php

Examples related to phpexcel