PHPExcel set border and format for all sheets in spreadsheet

Question

I m currently trying to set all borders for my spreadsheet  also formatting such as autosize   My code below is working  for sheet 1  All other sheets inside the spreadsheet are completely untouched  I ve been trying to get it to work with all other sheets inside this spreadsheet but with no luck   Any ideas on how i can global set the formatting so that all sheets have borders and autosize  The layout of all sheets in this spreadsheet are all the same  I m exporting to XLSX file   Cheers      autosize   for   col    A    col     P    col           objPHPExcel- gt getActiveSheet  - gt getColumnDimension  col - gt setAutoSize true           Borders for all data        objPHPExcel- gt getActiveSheet  - gt getStyle       A2           objPHPExcel- gt getActiveSheet  - gt getHighestColumn           objPHPExcel- gt getActiveSheet  - gt getHighestRow    - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THIN          Borders for heading        objPHPExcel- gt getActiveSheet  - gt getStyle       A1 O1   - gt getBorders  - gt getAllBorders  - gt setBorderStyle PHPExcel Style Border  BORDER THICK     EXTRA QUESTION  I ve currently set headings  The headings do appear on sheet 1  but do not appear in any other sheets   is it possible to show the headings in all sheets  The headings are set in Row 1  and the results are from Row 2 down    objPHPExcel- gt getActiveSheet  - gt setCellValue  A1    Asset id     objPHPExcel- gt getActiveSheet  - gt setCellValue  B1    Asset name     objPHPExcel- gt getActiveSheet  - gt setCellValue  C1    Asset type     objPHPExcel- gt getActiveSheet  - gt setCellValue  D1    Asset make     objPHPExcel- gt getActiveSheet  - gt setCellValue  E1    Asset model

User · Answer

To answer your extra question   You can set which rows should be repeated on every page using    objPHPExcel- gt getActiveSheet  - gt getPageSetup  - gt setRowsToRepeatAtTopByStartAndEnd 1  5    Now  row 1  2  3  4 and 5 will be repeated

User · Answer

for   s 65   s lt  90   s            echo chr  s        objPHPExcel- gt getActiveSheet  - gt getColumnDimension chr  s  - gt setAutoSize true

User · Answer

You can set a default style for the entire workbook  all worksheets     objPHPExcel- gt getDefaultStyle       - gt getBorders       - gt getTop           - gt setBorderStyle PHPExcel Style Border  BORDER THIN    objPHPExcel- gt getDefaultStyle       - gt getBorders       - gt getBottom           - gt setBorderStyle PHPExcel Style Border  BORDER THIN    objPHPExcel- gt getDefaultStyle       - gt getBorders       - gt getLeft           - gt setBorderStyle PHPExcel Style Border  BORDER THIN    objPHPExcel- gt getDefaultStyle       - gt getBorders       - gt getRight           - gt setBorderStyle PHPExcel Style Border  BORDER THIN     or     styleArray   array         borders    gt  array             allborders    gt  array                 style    gt  PHPExcel Style Border  BORDER THIN                           objPHPExcel- gt getDefaultStyle  - gt applyFromArray  styleArray     And this can be used for all style properties  not just borders   But column autosizing is structural rather than stylistic  and has to be set for each column on each worksheet individually   EDIT  Note that default workbook style only applies to Excel5 Writer

[php] PHPExcel set border and format for all sheets in spreadsheet

Examples related to php

Examples related to phpexcel