phpexcel set data type

Solutions on MaxInterview for phpexcel set data type by the best coders in the world

showing results for - "phpexcel set data type"
Enrico
17 Feb 2018
1$worksheet->getCell('A1:A50')->setDataType(PHPExcel_Cell_DataType::TYPE_STRING);
Luis
02 Apr 2018
1$objPHPExcel->setActiveSheetIndex(0)
2    ->setCellValue('A1', 'Field Name');
3    
4$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(50);
5
6$columnArray    = array("A","B","C","D","E","F","G","H");
7	
8$objPHPExcel->setActiveSheetIndex(0)
9->setCellValueExplicit("A", VALUE, PHPExcel_Cell_DataType::TYPE_STRING)