php中调行高代码_phpexcel 自动调整行高

getProperties()->setCreator("C1G")

->setLastModifiedBy("C1G")

->setTitle("phpexcel Test Document")

->setSubject("phpexcel Test Document")

->setDescription("Test document for phpexcel, generated using PHP classes.")

->setKeywords("office 2007 openxml php c1gstudio")

->setCategory("Test");

//设置当前活动的sheet

$objPHPExcel->setActiveSheetIndex(0);

//设置sheet名字

$objPHPExcel->getActiveSheet()->setTitle('phpexcel demo');

//设置默认行高

$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(15);

//由PHPExcel根据传入内容自动判断单元格内容类型

$objPHPExcel->getActiveSheet()->setCellValue('A1', "Firstname");

$objPHPExcel->getActiveSheet()->setCellValue('B1', "Lastname");

$objPHPExcel->getActiveSheet()->setCellValue('C1', "Phone");

$objPHPExcel->getActiveSheet()->setCellValue('D1', "Fax");

$objPHPExcel->getActiveSheet()->setCellValue('E1', "Address");

$objPHPExcel->getActiveSheet()->setCellValue('F1', "ZIP");

$objPHPExcel->getActiveSheet()->setCellValue('G1', "DATE");

$objPHPExcel->getActiveSheet()-&g