PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically

Question

I have form that I generate its content to Excel through PHPExcel  my problem is that  how can I set width and height and also styles to the heading cells   the excel generated demo is here     the excel i want is here    here is my code   for   col    A    col     J    col              objPHPExcel- gt getActiveSheet  - gt getColumnDimension  col - gt setAutoSize true                                       objPHPExcel- gt getProperties  - gt setCreator  HOO                                                           - gt setLastModifiedBy  HOO                                                           - gt setTitle  Jobs History                                                           - gt setSubject  PHPExcel Test Document                                                           - gt setDescription  Test document for PHPExcel  generated using PHP classes                                                            - gt setKeywords  office PHPExcel php                                                           - gt setCategory  Test result file                      objPHPExcel- gt setActiveSheetIndex 0 - gt mergeCells  A1 I1                     objPHPExcel- gt getActiveSheet  - gt setCellValue  A1    this- gt lang- gt line  history excel title                      objPHPExcel- gt getActiveSheet  - gt getStyle  A1  - gt getFont  - gt setBold true                     objPHPExcel- gt getActiveSheet  - gt getStyle  A2 I2  - gt getFill  - gt setFillType PHPExcel Style Fill  FILL SOLID                    objPHPExcel- gt getActiveSheet  - gt getStyle  A2 I2  - gt getFill  - gt getStartColor  - gt setARGB  29bb04                       Add some data                  objPHPExcel- gt getActiveSheet  - gt getStyle  A2 I2  - gt getFont  - gt setBold true                    objPHPExcel- gt getActiveSheet  - gt getStyle  A2 I2  - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                       echo date  H i s       Add some data    EOL                   objPHPExcel- gt setActiveSheetIndex 0                              - gt setCellValue  A2    this- gt lang- gt line  global no                                - gt setCellValue  B2    this- gt lang- gt line  history name                                - gt setCellValue  C2    this- gt lang- gt line  history type emp                                - gt setCellValue  D2    this- gt lang- gt line  history job title                                - gt setCellValue  E2    this- gt lang- gt line  history emp date                                - gt setCellValue  F2    this- gt lang- gt line  history emp duration                                - gt setCellValue  G2    this- gt lang- gt line  history duty                                - gt setCellValue  H2    this- gt lang- gt line  history contact duty                                - gt setCellValue  I2    this- gt lang- gt line  history salary                       objPHPExcel- gt getActiveSheet  - gt getRowDimension 1 - gt setRowHeight -1                     i  3                  foreach  details- gt result   AS  item                                         objPHPExcel- gt getActiveSheet  - gt getStyle  A   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  B   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  C   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  D   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  E   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  F   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  G   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  H   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                        objPHPExcel- gt getActiveSheet  - gt getStyle  I   i    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN                          Miscellaneous glyphs  UTF-8                      objPHPExcel- gt setActiveSheetIndex 0                              - gt setCellValue  A   i   i-2                              - gt setCellValue  B   i   item- gt employer office                              - gt setCellValue  C   i   item- gt job type                              - gt setCellValue  D   i   item- gt job title                              - gt setCellValue  E   i   item- gt job appointment date                              - gt setCellValue  F   i   item- gt job duration                              - gt setCellValue  G   i   item- gt job place                              - gt setCellValue  H   i   item- gt type of relation                              - gt setCellValue  I   i   item- gt monthly salary                        i

User · Answer

Try this        objPHPExcel- gt getActiveSheet  - gt getRowDimension  1  - gt setRowHeight 40

User · Answer

You can use   objWorksheet- gt getActiveSheet  - gt getRowDimension  1  - gt setRowHeight 40    objWorksheet- gt getActiveSheet  - gt getColumnDimension  A  - gt setWidth 100     or define auto-size    objWorksheet- gt getRowDimension  1  - gt setRowHeight -1

[phpexcel] PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically

Examples related to phpexcel