SyntaxFix

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

The same way as you'd set the type (number format mask) after writing a value to it:

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

or

$objPHPExcel->getActiveSheet()
    ->getStyle('A1')
    ->getNumberFormat()
    ->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.

Examples related to phpexcel

• How to center the text in PHPExcel merged cell • PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically • PHPExcel set border and format for all sheets in spreadsheet • Set Font Color, Font Face and Font Size in PHPExcel • PHPExcel - set cell type before writing a value in it • PHPExcel auto size column width • PHPExcel Make first row bold • How to export data to an excel file using PHPExcel • PHP Excel Header • PHPExcel - creating multiple sheets by iteration