PHPExcel - set cell type before writing a value in it

Question

Do you know how can I set the cell type before writing a value in it  I would like to be able to set types like  General    Text  and  Number    Thank you

User · Answer

For Numbers with leading zeroes and comma separated:

You can put 'A' to affect the entire column'.

$objPHPExcel->getActiveSheet()->getStyle('A1')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);

Then you can write to the cell as you normally would.

User · Answer

The same way as you d set the type  number format mask  after writing a value to it    objPHPExcel- gt getActiveSheet       - gt getStyle  A1       - gt getNumberFormat       - gt setFormatCode          PHPExcel Style NumberFormat  FORMAT GENERAL          or   objPHPExcel- gt getActiveSheet       - gt getStyle  A1       - gt getNumberFormat       - gt setFormatCode          PHPExcel Style NumberFormat  FORMAT TEXT          Though  Number  isn t a valid format mask   You can find a list of pre-defined format masks in Classes PHPExcel Style NumberFormat php or set the value to any valid Excel number format masking string

User · Answer

I wanted the Number same as I get from database for example    1  00100 220000  2  00123  3  0000 0000100  So I modified the code as below   objPHPExcel- gt getActiveSheet       - gt setCellValue  A3    00100 220000     objPHPExcel- gt getActiveSheet       - gt getStyle  A3       - gt getNumberFormat       - gt setFormatCode  00000 000000       objPHPExcel- gt getActiveSheet       - gt setCellValue  A4    00123     objPHPExcel- gt getActiveSheet     - gt getStyle  A4    - gt getNumberFormat   - gt setFormatCode  00000       objPHPExcel- gt getActiveSheet       - gt setCellValue  A5    0000 0000100     objPHPExcel- gt getActiveSheet     - gt getStyle  A5    - gt getNumberFormat   - gt setFormatCode  0000 0000000

User · Answer

Followed Mark s advise and did this to set the default number formatting to text in the whole workbook    objPHPExcel   new PHPExcel      objPHPExcel- gt getDefaultStyle       - gt getNumberFormat       - gt setFormatCode          PHPExcel Style NumberFormat  FORMAT TEXT          And it works flawlessly  Thank you  Mark Baker

User · Answer

try this    currencyFormat             0 00             0 00        -               textFormat        General   0 00       excel- gt getActiveSheet  - gt getStyle  B1  - gt getNumberFormat  - gt setFormatCode  currencyFormat    excel- gt getActiveSheet  - gt getStyle  C1  - gt getNumberFormat  - gt setFormatCode  textFormat

User · Answer

When the text is a number with leading zeros  then do   Cuando el texto es un n  mero que empieza por ceros  hacer    objPHPExcel- gt getActiveSheet  - gt setCellValueExplicit  A1    val PHPExcel Cell DataType  TYPE STRING

[phpexcel] PHPExcel - set cell type before writing a value in it

Examples related to phpexcel