php phpexcel 内容靠最右边_php操作EXCLE（通过phpExcle实现向excel写数据）

php通过phpExcel进行写excel

require_once('/PHPExcel.php');

require_once('/PHPExcel/Writer/Excel2007.php');

$objPHPExcel = new PHPExcel();

//Set properties设置文件属性

$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");

$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");

$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");

$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");

$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");

$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");

$objPHPExcel->getProperties()->setCategory("Test result file");

//Add some data 添加数据

$objPHPExcel->setActiveSheetIndex(0);

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

$objPHPExcel->getActiveSheet()->setCellValue('A2',true);

$objPHPExcel->getActiveSheet()->setCellValue('A3',false);

$objPHPExcel->getActiveSheet()->setCellValue('B2','world');

$objPHPExcel->getActiveSheet()->setCellValue('B3','2');

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

$objPHPExcel->getActiveSheet()->setCellValue('D2','world!');

//循环添加数据

for($i = 1;$i<200;$i++){

$objPHPExcel->getActiveSheet()->setcellValue('A'.$i,$i);

$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,'Test value');

}

//日期格式化

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

$objPHPExcel->getActiveSheet()->getStyle('D1')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH);

//Add comment 添加注释

$objPHPExcel->getActiveSheet()->getComment('E11')->setAuthor('PHPExcel');

$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('PHPExcel:');

$objCommentRichText->getFont()->setBold(true);

$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun("\r\n");

$objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('Total amount on the current invoice, excluding VAT.');

//Add rich-text string 添加文字 可设置样式

$objRichText = new PHPExcel_RichTex