PHP exports the Excel class library, supporting accompanying images-PHP source code

PHP: a class library for exporting Excel files. it supports image files.

 GetProperties ()-> setCreator ("Maarten Balliauw")-> setLastModifiedBy ("Maarten Balliauw")-> setTitle ("Office 2007 XLSX Test Document ") -> setSubject ("Office 2007 XLSX Test Document")-> setDescription ("Document for Office 2007 XLSX, generated using PHP classes. ")-> setKeywords (" office 2007 openxml php ")-> setCategory (" Test result file "); $ objPHPExcel-> setActiveSheetIndex (0 ); $ objRichText = new PHPExcel_RichText (); $ objRichText-> createText (''); $ objPayable = $ objRichText-> createTextRun ('Excel exported by PHP '); $ objPayable-> getFont ()-> setColor (new PHPExcel_Style_Color (PHPExcel_Style_Color: COLOR_RED); $ objPayable-> getFont ()-> setBold (true ); $ objPayable-> getFont ()-> setSize (24); $ objPHPExcel-> getActiveSheet ()-> getCell ('b1 ')-> setValue ($ objRichText ); $ objPHPExcel-> getActiveSheet ()-> getStyle ('b1 ')-> getFont ()-> setBold (true); // bold $ objPHPExcel-> getActiveSheet () -> getStyle ('b1 ')-> getFont ()-> setSize (24); // font size $ objPHPExcel-> getActiveSheet ()-> getStyle ('b1 ') -> getFont ()-> getColor ()-> setARGB (PHPExcel_Style_Color: COLOR_RED); // text color $ objPHPExcel-> getActiveSheet ()-> getStyle ('A1: g1 ')-> getFill ()-> setFillType (PHPExcel_Style_Fill: FILL_SOLID); $ objPHPExcel-> getActiveSheet ()-> getStyle ('A1: g1')-> getFill () -> getStartColor ()-> setARGB ('00ffffe3 '); // shading // column width // $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('A ') -> setAutoSize (true); $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('A')-> setWidth (12); $ objPHPExcel-> getActiveSheet () -> getColumnDimension ('B')-> setWidth (18); $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('C')-> setWidth (12 ); $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('D')-> setWidth (18); $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('e ') -> setWidth (12); $ objPHPExcel-> getActiveSheet ()-> getColumnDimension ('F')-> setWidth (18); $ objPHPExcel-> getActiveSheet () -> getColumnDimension ('g')-> setWidth (20); // The row height for ($ I = 2; $ I <= 17; $ I ++) {$ objPHPExcel-> getActiveSheet ()-> getRowDimension ($ I)-> setRowHeight (22);} $ objPHPExcel-> getActiveSheet ()-> setCellValue ('A2 ', 'name'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('A3 ', 'php'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('A4 ', 'Excel '); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a5', ''); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a6 ', 'XXX'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a7 ', 'V'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a8 ', 'd); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a9 ', 'name'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a10 ', 'Description'); for ($ I = 2; $ I <= 16; $ I ++) {$ objPHPExcel-> getActiveSheet ()-> getStyle ('A '. $ I)-> getFont ()-> setBold (true); // bold} $ objPHPExcel-> getActiveSheet ()-> setCellValue ('B2 ', '[name]'); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('b3', 'Excel with image export '); $ objPHPExcel-> getActiveSheet () -> setCellValue ('B4 ', 'xxxxx'); // add an image to the excel file $ objDrawing = new PHPExcel_Worksheet_Drawing (); $ objDrawing-> setName ('photo '); $ objDrawing-> setDescription ('photo '); $ objDrawing-> setPath ('. /images/PIC.jpg '); $ objDrawing-> setHeight (170); $ objDrawing-> setWidth (120); $ objDrawing-> setCoordinates ('G2 '); $ objDrawing-> setWorksheet ($ objPHPExcel-> getActiveSheet (); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('a17', 'other requests '); $ objPHPExcel-> getActiveSheet ()-> setCellValue ('b17', '[other requirements]'); $ objPHPExcel-> getActiveSheet ()-> getStyle ('a17 ') -> getFont ()-> setBold (true); // bold $ objPHPExcel-> setActiveSheetIndex (0); $ objPHPExcel-> getActiveSheet () -> setTitle ('Excel table'); $ objWriter = PHPExcel_IOFactory: createWriter ($ objPHPExcel, 'excel5'); $ objWriter-> save('php excel.xls ');

2. [File]PHPExcel.rar

PHPExcel.rar