phpexcel导出tp3注意非命名空间+\

最新推荐文章于 2023-08-17 10:08:14 发布

转载最新推荐文章于 2023-08-17 10:08:14 发布 · 84 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/bluestear/p/9830878.html

本文详细介绍如何使用PHPExcel库创建和编辑Excel文件，包括设置文档属性、处理各种数据类型、设置单元格样式、保护工作表及输出文件等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

require_once APP_PATH . '/Common/ORG/PHPExcel/PHPExcel.php';

require_once APP_PATH . '/Common/ORG/PHPExcel/PHPExcel/Writer/Excel2007.php';

$objExcel = new \PHPExcel();

// 保存excel—2007格式

$objWriter = new \PHPExcel_Writer_Excel2007($objExcel);

//或者$objWriter = new PHPExcel_Writer_Excel5($objExcel); 非2007格式

// $objWriter->save("haha.xlsx");

// 直接输出到浏览器

//设置文档基本属性

$objProps=$objExcel->getProperties();

$objProps->setCreator("ZealLi");

$objProps->setLastModifiedBy("ZealLi");

$objProps->setTitle("OfficeXLSTestDocument");

$objProps->setSubject("OfficeXLSTestDocument,Demo");

$objProps->setDescription("Testdocument,generatedbyPHPExcel.");

$objProps->setKeywords("officeexcelPHPExcel");

$objProps->setCategory("Test");

//设置当前的sheet索引，用于后续的内容操作。

//一般只有在使用多个sheet的时候才需要显示调用。

//缺省情况下，PHPExcel会自动创建第一个sheet被设置SheetIndex=0

$objExcel->setActiveSheetIndex(0);

$objActSheet=$objExcel->getActiveSheet();

//设置当前活动sheet的名称

$objActSheet->setTitle('测试Sheet');

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

$objActSheet->setCellValue('A1','字符串内容');//字符串内容

$objActSheet->setCellValue('A2',26);//数值

$objActSheet->setCellValue('A3',true);//布尔值

$objActSheet->setCellValue('A4','=SUM(A2:A2)');//公式

//显式指定内容类型

$objActSheet->setCellValueExplicit('A5','8757584',\PHPExcel_Cell_DataType::TYPE_STRING);

//合并单元格

$objActSheet->mergeCells('B1:C22');

//分离单元格

$objActSheet->unmergeCells('B1:C22');

//设置宽度

// $objActSheet->getColumnDimension('B')->setAutoSize(true);

$objActSheet->getColumnDimension('A')->setWidth(30);

$objStyleA5=$objActSheet->getStyle('A5');

$objStyleA5->getNumberFormat()->setFormatCode(\PHPExcel_Style_NumberFormat::FORMAT_NUMBER);

//设置字体

$objFontA5=$objStyleA5->getFont();

$objFontA5->setName('CourierNew');

$objFontA5->setSize(10);

$objFontA5->setBold(true);

$objFontA5->setUnderline(\PHPExcel_Style_Font::UNDERLINE_SINGLE);

$objFontA5->getColor()->setARGB('FFFF0000');

$objFontA5->getColor()->setARGB(\PHPExcel_Style_Color::COLOR_WHITE);

//$objFontA5->getFont()->setColor(PHPExcel_Style_Color::COLOR_RED);

//设置对齐方式

$objAlignA5=$objStyleA5->getAlignment();

$objAlignA5->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);

$objAlignA5->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);

$objAlignA5->setWrapText(true);//自动换行，前提是单元格内的值超列宽，或者在值内写入个\n

//设置边框

$objBorderA5=$objStyleA5->getBorders();

$objBorderA5->getTop()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);

$objBorderA5->getTop()->getColor()->setARGB('FFFF0000');//边框color

$objBorderA5->getBottom()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);

$objBorderA5->getLeft()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);

$objBorderA5->getRight()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);

//设置CELL填充颜色

$objFillA5=$objStyleA5->getFill();

$objFillA5->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);

$objFillA5->getStartColor()->setARGB('FFEEEEEE');

//从指定的单元格复制样式信息.

$objActSheet->duplicateStyle($objStyleA5,'B1:C22');

//添加图片

// $objDrawing = new \PHPExcel_Worksheet_Drawing();

// $objDrawing->setName('ZealImg');

// $objDrawing->setDescription('ImageinsertedbyZeal');

// $objDrawing->setPath('./zeali.net.logo.gif');

// $objDrawing->setHeight(36);

// $objDrawing->setCoordinates('C23');

// $objDrawing->setOffsetX(10);

// $objDrawing->setRotation(15);

// $objDrawing->getShadow()->setVisible(true);

// $objDrawing->getShadow()->setDirection(36);

// $objDrawing->setWorksheet($objActSheet);

//添加一个新的worksheet

$objExcel->createSheet();

$objExcel->getSheet(1)->setTitle('测试2');

//保护单元格

$objExcel->getSheet(1)->getProtection()->setSheet(true);

$objExcel->getSheet(1)->protectCells('A1:C22','PHPExcel');

//显示网格线:

$objExcel->getActiveSheet()->setShowGridlines(true);

//显示隐藏列

$objExcel->getActiveSheet()->getColumnDimension('C')->setVisible(true);

$objExcel->getActiveSheet()->getColumnDimension('D')->setVisible(false);

//显示隐藏行

$objExcel->getActiveSheet()->getRowDimension('10')->setVisible(false);

//默认列宽

$objExcel->getActiveSheet()->getDefaultColumnDimension()->setWidth(12);

//默认行宽

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

//worksheet默认style设置(和默认不同的需单独设置)

$objExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Arial');

$objExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(8);

$alignment = $objExcel->getActiveSheet()->getDefaultStyle()->getAlignment();

$alignment->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$alignment->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);

//输出内容

$outputFileName="output.xls";

//到文件通过文件路径再用Ajax无刷新页面

// $objWriter->save($outputFileName);

//到浏览器

header("Content-Type:application/force-download");

header("Content-Type:application/octet-stream");

header("Content-Type:application/download");

header('Content-Disposition:inline;filename="'.$outputFileName.'"');

header("Content-Transfer-Encoding:binary");

header("Last-Modified:".gmdate("D,dMYH:i:s")."GMT");

header("Cache-Control:must-revalidate,post-check=0,pre-check=0");

header("Pragma:no-cache");

$objWriter->save('php://output');

转载于:https://www.cnblogs.com/bluestear/p/9830878.html