Harwee
0
Q:

phpexcel set data type

$worksheet->getCell('A1:A50')->setDataType(PHPExcel_Cell_DataType::TYPE_STRING);
0
$objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue('A1', 'Field Name');
    
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50);

$columnArray    = array("A","B","C","D","E","F","G","H");
	
$objPHPExcel->setActiveSheetIndex(0)
->setCellValueExplicit("A", VALUE, PHPExcel_Cell_DataType::TYPE_STRING)
0

New to Communities?

Join the community