phpexcel类

2024-02-02 21:18
文章标签 phpexcel

本文主要是介绍phpexcel类，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

创建一个excel

 $objPHPExcel = new PHPExcel();
PHP类phpExcel保存excel—2007格式

 $objWriter = new PHPExcel_Writer_Excel2007( $objPHPExcel );
 $objWriter = new PHPExcel_Writer_Excel5( $objPHPExcel ); // 非2007格式
$objWriter -> save( " xxx.xlsx " );
直接输出到浏览器

 $objWriter = new PHPExcel_Writer_Excel5( $objPHPExcel );
 header ( " Pragma: public " );
 header ( " Expires: 0 " );
 header ( " Cache-Control:must-revalidate,post-check=0,pre-check=0 " );
 header ( " Content-Type:application/force-download " );
 header ( " Content-Type:application/vnd.ms-execl " );
 header ( " Content-Type:application/octet-stream " );
 header ( " Content-Type:application/download " );
 header ( ' Content-Disposition:attachment;filename="resume.xls" ' );
 header ( " Content-Transfer-Encoding:binary " );
 $objWriter -> save( " php://output " );
PHP类phpExcel设置excel的属性：

创建人
 $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 ”);

PHP类phpExcel设置当前的sheet
 $objPHPExcel -> setActiveSheetIndex( 0 );

设置sheet的name
 $objPHPExcel -> getActiveSheet() -> setTitle(’Simple’);

设置单元格的值
 $objPHPExcel -> getActiveSheet() -> setCellValue(’A1′ , ‘ String ’);
 $objPHPExcel -> getActiveSheet() -> setCellValue(’A2′ , 12 );
 $objPHPExcel -> getActiveSheet() -> setCellValue(’A3′ , true );
 $objPHPExcel -> getActiveSheet() -> setCellValue(’C5′ , ‘ = SUM(C2 : C4)’);
 $objPHPExcel -> getActiveSheet() -> setCellValue(’B8′ , ‘ = MIN (B2 : C5)’);

合并单元格
 $objPHPExcel -> getActiveSheet() -> mergeCells(’A18 : E22′);

PHP类phpExcel分离单元格
 $objPHPExcel -> getActiveSheet() -> unmergeCells(’A28 : B28′);

保护cell
 $objPHPExcel -> getActiveSheet() -> getProtection() -> setSheet( true ); // Needs to be set to true in order to enable any worksheet protection!
$objPHPExcel -> getActiveSheet() -> protectCells(’A3 : E13′ , ‘PHPExcel’);

设置格式
 // Set cell number formats
echo date (’H : i : s’) . ” Set cell number formats\n”;
 $objPHPExcel -> getActiveSheet() -> getStyle(’E4′) -> getNumberFormat() -> setFormatCode(PHPExcel_Style_NumberFormat :: FORMAT_CURRENCY_EUR_SIMPLE);
 $objPHPExcel -> getActiveSheet() -> duplicateStyle( $objPHPExcel -> getActiveSheet() -> getStyle(’E4′) , ‘E5 : E13′ );

PHP类phpExcel设置宽width
 // Set column widths
$objPHPExcel -> getActiveSheet() -> getColumnDimension(’B’) -> setAutoSize( true );
 $objPHPExcel -> getActiveSheet() -> getColumnDimension(’D’) -> setWidth( 12 );

设置font
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFont() -> setName(’Candara’);
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFont() -> setSize( 20 );
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFont() -> setBold( true );
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFont() -> setUnderline(PHPExcel_Style_Font :: UNDERLINE_SINGLE);
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFont() -> getColor() -> setARGB(PHPExcel_Style_Color :: COLOR_WHITE);
 $objPHPExcel -> getActiveSheet() -> getStyle(’E1′) -> getFont() -> getColor() -> setARGB(PHPExcel_Style_Color :: COLOR_WHITE);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D13′) -> getFont() -> setBold( true );
 $objPHPExcel -> getActiveSheet() -> getStyle(’E13′) -> getFont() -> setBold( true );

PHP类phpExcel设置align
 $objPHPExcel -> getActiveSheet() -> getStyle(’D11′) -> getAlignment() -> setHorizontal(PHPExcel_Style_Alignment :: HORIZONTAL_RIGHT);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D12′) -> getAlignment() -> setHorizontal(PHPExcel_Style_Alignment :: HORIZONTAL_RIGHT);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D13′) -> getAlignment() -> setHorizontal(PHPExcel_Style_Alignment :: HORIZONTAL_RIGHT);
 $objPHPExcel -> getActiveSheet() -> getStyle(’A18′) -> getAlignment() -> setHorizontal(PHPExcel_Style_Alignment :: HORIZONTAL_JUSTIFY);
 // 垂直居中
$objPHPExcel -> getActiveSheet() -> getStyle(’A18′) -> getAlignment() -> setVertical(PHPExcel_Style_Alignment :: VERTICAL_CENTER);

PHP类phpExcel设置column的border
 $objPHPExcel -> getActiveSheet() -> getStyle(’A4′) -> getBorders() -> getTop() -> setBorderStyle(PHPExcel_Style_Border :: BORDER_THIN);
 $objPHPExcel -> getActiveSheet() -> getStyle(’B4′) -> getBorders() -> getTop() -> setBorderStyle(PHPExcel_Style_Border :: BORDER_THIN);
 $objPHPExcel -> getActiveSheet() -> getStyle(’C4′) -> getBorders() -> getTop() -> setBorderStyle(PHPExcel_Style_Border :: BORDER_THIN);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D4′) -> getBorders() -> getTop() -> setBorderStyle(PHPExcel_Style_Border :: BORDER_THIN);
 $objPHPExcel -> getActiveSheet() -> getStyle(’E4′) -> getBorders() -> getTop() -> setBorderStyle(PHPExcel_Style_Border :: BORDER_THIN);

设置border的color
 $objPHPExcel -> getActiveSheet() -> getStyle(’D13′) -> getBorders() -> getLeft() -> getColor() -> setARGB(’FF993300′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D13′) -> getBorders() -> getTop() -> getColor() -> setARGB(’FF993300′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’D13′) -> getBorders() -> getBottom() -> getColor() -> setARGB(’FF993300′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’E13′) -> getBorders() -> getTop() -> getColor() -> setARGB(’FF993300′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’E13′) -> getBorders() -> getBottom() -> getColor() -> setARGB(’FF993300′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’E13′) -> getBorders() -> getRight() -> getColor() -> setARGB(’FF993300′);

PHP类phpExcel设置填充颜色
 $objPHPExcel -> getActiveSheet() -> getStyle(’A1′) -> getFill() -> setFillType(PHPExcel_Style_Fill :: FILL_SOLID);
 $objPHPExcel -> getActiveSheet() -> getStyle(’A1′) -> getFill() -> getStartColor() -> setARGB(’FF808080′);
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFill() -> setFillType(PHPExcel_Style_Fill :: FILL_SOLID);
 $objPHPExcel -> getActiveSheet() -> getStyle(’B1′) -> getFill() -> getStartColor() -> setARGB(’FF808080′);

加图片
 $objDrawing = new PHPExcel_Worksheet_Drawing();
 $objDrawing -> setName(’Logo’);
 $objDrawing -> setDescription(’Logo’);
 $objDrawing -> setPath(’ ./ images / officelogo . jpg’);
 $objDrawing -> setHeight( 36 );
 $objDrawing -> setWorksheet( $objPHPExcel -> getActiveSheet());

 $objDrawing = new PHPExcel_Worksheet_Drawing();
 $objDrawing -> setName(’Paid’);
 $objDrawing -> setDescription(’Paid’);
 $objDrawing -> setPath(’ ./ images / paid . png’);
 $objDrawing -> setCoordinates(’B15′);
 $objDrawing -> setOffsetX( 110 );
 $objDrawing -> setRotation( 25 );
 $objDrawing -> getShadow() -> setVisible( true );
 $objDrawing -> getShadow() -> setDirection( 45 );
 $objDrawing -> setWorksheet( $objPHPExcel -> getActiveSheet());

PHP类phpExcel在默认sheet后，创建一个worksheet
 echo date (’H : i : s’) . ” Create new Worksheet object \n”;
 $objPHPExcel -> createSheet();

 $objWriter = PHPExcel_IOFactory :: createWriter( $objExcel , ‘Excel5′);
 $objWriter - save(‘php : // output’);

这篇关于phpexcel类的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/671977。

相关文章

phpexcel读写excel表格详解

phpexcel读写excel表格详解

phpexcel代码地址：https://code.csdn.net/u013372487/phpexcel/tree/master 代码实例： 数据导入excel表格： 可以通过命令直接导出： <?php/*** php 输出excel文件到固定文件夹中 * 注意输出的是 xxx.xlsx文件，* 若想输出 .xls文件，将下面语句替换为 * include './PHPExcel
阅读更多...
利用PHPExcel读取Excel的和导出数据到Excel

利用PHPExcel读取Excel的和导出数据到Excel

导出数据到Excel <?phpheader("Content-Type:text/html;charset=UTF-8");require_once getcwd() . "/exportexcel/PHPExcel/IOFactory.php";require_once getcwd() . "/exportexcel/PHPExcel.php";require_once getcwd
阅读更多...
phpExcel 生成快递单

phpExcel 生成快递单

require_once 'PHPExcel.php';//定义路径$filePath = UPLOAD_PATH.'/shiptemplate/yt_excel.xls';$objPHPExcel = PHPExcel_IOFactory::load($filePath);$raw_data = $objPHPExcel->setActiveSheetIndex(0)->toArray();$d
阅读更多...
PHPExcel生成excel + mpdf导出pdf中文乱码处理

PHPExcel生成excel + mpdf导出pdf中文乱码处理

mpdf页眉页脚设置： $mpdf = new mPDF('+aCJK','A4','','',0,0,15,15,3,3);//字体，'','','',左右边距0，0，上下距离15，15，页眉页脚边距3，3$mpdf->autoScriptToLang = true;$mpdf->autoLangToFont = true;$mpdf->SetHTMLHeader($header);$
阅读更多...
PHPExcel类库---生成excel文件

PHPExcel类库---生成excel文件

<?   //设置PHPExcel类库的include path   set_include_path('.'. PATH_SEPARATOR .                    'D:\Zeal\PHP_LIBS' . PATH_SEPARATOR .                    get_include_path());        require_once 'PHPExc
阅读更多...
phpexcel 简单导出多个sheet

phpexcel 简单导出多个sheet

public function exportExcel(){require_once 'include/PHPExcel.php';$objPHPExcel = new PHPExcel(); //实例化Excel类//第一个sheet填入主标题$first_sheet_title = '入职';$objPHPExcel->getActiveSheet()->setCellValue('A1'
阅读更多...
使用phpexcel导出excel乱码问题解决方法

使用phpexcel导出excel乱码问题解决方法

在header() 前面加上ob_end_clean() 函数, 清除缓冲区, 这样就不会乱码了! ob_end_clean();//清除缓冲区,避免乱码 header('Content-Type: application/vnd.ms-excel');
阅读更多...
phpExcel用法

phpExcel用法

下面是总结的几个使用方法include 'PHPExcel.php';include 'PHPExcel/Writer/Excel2007.php';//或者include 'PHPExcel/Writer/Excel5.php'; 用于输出.xls的创建一个excel$objPHPExcel = new PHPExcel();保存excel—2007格式$objWriter = n
阅读更多...
使用PHPExcel导入excel文件

使用PHPExcel导入excel文件

用PHPExcel扩展导入excel文件，扩展请自行找度娘下载^^，直接上核心代码  public function exportExcel(){//扩展路径include APPPATH.'libraries/PHPExcel/IOFactory.php'; //excel文件路径$filepath = APPPATH."excel.xls"; $objPHPExcel = PHP
阅读更多...
使用PHPExcel实现数据批量导入到数据库

使用PHPExcel实现数据批量导入到数据库

此例子只使用execel2003的.xls文档,若使用的是其他版本，可以保存格式为“Execel 97-2003 工作簿(*.xls)”即.xls文件类型即可！ 功能说明：只能上传Excel2003类型的xls文件，大小不超过5M。可下载例子模板添加数据后即可上传！ 1 <!DOCTYPE html>2 <html>3 <head>4 <title></title>5 </hea
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2