Sharing of pdf word excel operation classes in php_PHP tutorial

In the early days, it was troublesome to use php to generate execl. I usually used csv instead. Now there are many such tools and they are relatively mature. Not only excel, word, pdf.

1.php excelreader operates the php class of excel, generates, reads excel, etc. The function is very powerful.

Download address: http://sourceforge.net/projects/phpexcelreader/

After decompression, there are many examples and the calling method is simple.

Example 1

The code is as follows

Copy code

代码如下

复制代码

/**  *  * @copyright 2007-2012 Xiaoqiang.  * @author Xiaoqiang.Wu  * @version 1.01  */   error_reporting(E_ALL);   date_default_timezone_set('Asia/ShangHai');   /** PHPExcel_IOFactory */ require_once '../Classes/PHPExcel/IOFactory.php';     // Check prerequisites if (!file_exists("31excel5.xls")) {  exit("not found 31excel5.xls.n"); }   $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿) $PHPExcel = $reader->load("31excel5.xls"); // 载入excel文件 $sheet = $PHPExcel->getSheet(0); // 读取第一??工作表 $highestRow = $sheet->getHighestRow(); // 取得总行数 $highestColumm = $sheet->getHighestColumn(); // 取得总列数 $highestColumm= PHPExcel_Cell::columnIndexFromString($colsNum); //字母列转换为数字列 如:AA变为27   /** 循环读取每个单元格的数据 */ for ($row = 1; $row     for ($column = 0; $column         $columnName = PHPExcel_Cell::stringFromColumnIndex($column);         echo $columnName.$row.":".$sheet->getCellByColumnAndRow($column, $row)->getValue()." ";     } }   ?>

/**
 *
 * @copyright 2007-2012 Xiaoqiang.
 * @author Xiaoqiang.Wu
 * @version 1.01
 */

error_reporting(E_ALL);

date_default_timezone_set('Asia/ShangHai');

/**PHPExcel_IOFactory*/
require_once '../Classes/PHPExcel/IOFactory.php';


// Check prerequisites
if (!file_exists("31excel5.xls")) {
exit("not found 31excel5.xls.n");
}

$reader = PHPExcel_IOFactory::createReader('Excel5'); //Set to Excel5 format (Excel97-2003 workbook)
$PHPExcel = $reader->load("31excel5.xls"); // Load excel file
$sheet = $PHPExcel->getSheet(0); // Read the first sheet
$highestRow = $sheet->getHighestRow(); // Get the total number of rows
$highestColumm = $sheet->getHighestColumn(); // Get the total number of columns
$highestColumm= PHPExcel_Cell::columnIndexFromString($colsNum); //Convert letter column to numeric column. For example: AA becomes 27

/**Loop to read the data of each cell*/
for ($row = 1; $row for ($column = 0; $column           $columnName = PHPExcel_Cell::stringFromColumnIndex($column);
echo $columnName.$row.":".$sheet->getCellByColumnAndRow($column, $row)->getValue()."
";
}
}

?>

Example 2

代码如下

复制代码

/**  *  * @copyright 2007-2012 Xiaoqiang.  * @author Xiaoqiang.Wu  * @version 1.01  */   error_reporting(E_ALL);   date_default_timezone_set('Asia/ShangHai');   /** PHPExcel_IOFactory */ require_once '../Classes/PHPExcel/IOFactory.php';     // Check prerequisites if (!file_exists("31excel5.xls")) {  exit("not found 31excel5.xls.n"); }   $reader = PHPExcel_IOFactory::createReader('Excel5'); //设置以Excel5格式(Excel97-2003工作簿) $PHPExcel = $reader->load("31excel5.xls"); // 载入excel文件 $sheet = $PHPExcel->getSheet(0); // 读取第一??工作表 $highestRow = $sheet->getHighestRow(); // 取得总行数 $highestColumm = $sheet->getHighestColumn(); // 取得总列数   /** 循环读取每个单元格的数据 */ for ($row = 1; $row     for ($column = 'A'; $column         $dataset[] = $sheet->getCell($column.$row)->getValue();         echo $column.$row.":".$sheet->getCell($column.$row)->getValue()." ";     } }   ?>

The code is as follows

Copy code

/**  *  * @copyright 2007-2012 Xiaoqiang.  * @author Xiaoqiang.Wu  * @version 1.01  */ error_reporting(E_ALL); date_default_timezone_set('Asia/ShangHai'); /**PHPExcel_IOFactory*/ require_once '../Classes/PHPExcel/IOFactory.php'; // Check prerequisites if (!file_exists("31excel5.xls")) { exit("not found 31excel5.xls.n"); } $reader = PHPExcel_IOFactory::createReader('Excel5'); //Set to Excel5 format (Excel97-2003 workbook) $PHPExcel = $reader->load("31excel5.xls"); // Load excel file $sheet = $PHPExcel->getSheet(0); // Read the first sheet $highestRow = $sheet->getHighestRow(); // Get the total number of rows $highestColumm = $sheet->getHighestColumn(); // Get the total number of columns /**Loop to read the data of each cell*/ for ($row = 1; $row for ($column = 'A'; $column $dataset[] = $sheet->getCell($column.$row)->getValue(); echo $column.$row.":".$sheet->getCell($column.$row)->getValue()." "; } } ?>

2, phpdocx operates the php class of word

PHPDocx is a PHP class library for generating fully dynamic, fully compatible Word documents.

You may need to generate reports directly from any data collection or table file. These reports may include icons, pictures, tables, beginning, ending and other data.

PHPDocx can use some predefined template files to generate Word documents, which greatly simplifies the workload. With a little bit of code, you can integrate PHPDocx into your WEB site or web application, providing a valuable service to your users or employees.

Example

Download address: http://sourceforge.net/projects/html2fpdf/?source=recommended

The code is as follows

代码如下

复制代码

Basic example // Include the PHPWord.php, all other classes were loaded by an autoloader require_once 'PHPWord.php'; // Create a new PHPWord Object $PHPWord = new PHPWord(); // Every element you want to append to the word document is placed in a section. So you need a section: $section = $PHPWord->createSection(); // After creating a section, you can append elements: $section->addText('Hello world!'); // You can directly style your text by giving the addText function an array: $section->addText('Hello world! I am formatted.', array('name'=>'Tahoma', 'size'=>16, 'bold'=>true)); // If you often need the same style again you can create a user defined style to the word document // and give the addText function the name of the style: $PHPWord->addFontStyle('myOwnStyle', array('name'=>'Verdana', 'size'=>14, 'color'=>'1B2232')); $section->addText('Hello world! I am formatted by a user defined style', 'myOwnStyle'); // You can also putthe appended element to local object an call functions like this: $myTextElement = $section->addText('Hello World!'); $myTextElement->setBold(); $myTextElement->setName('Verdana'); $myTextElement->setSize(22); // At least write the document to webspace: $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $objWriter->save('helloWorld.docx');

Copy code

Basic example
// Include the PHPWord.php, all other classes were loaded by an autoloader
require_once 'PHPWord.php';

// Create a new PHPWord Object
$PHPWord = new PHPWord();

// Every element you want to append to the word document is placed in a section. So you need a section:
$section = $PHPWord->createSection();

// After creating a section, you can append elements:
$section->addText('Hello world!');

// You can directly style your text by giving the addText function an array:
$section->addText('Hello world! I am formatted.', array('name'=>'Tahoma', 'size'=>16, 'bold'=>true));

// If you often need the same style again you can create a user defined style to the word document
// and give the addText function the name of the style:
$PHPWord->addFontStyle('myOwnStyle', array('name'=>'Verdana', 'size'=>14, 'color'=>'1B2232'));
$section->addText('Hello world! I am formatted by a user defined style', 'myOwnStyle');

// You can also put the appended element to local object an call functions like this:
$myTextElement = $section->addText('Hello World!');
$myTextElement->setBold();
$myTextElement->setName('Verdana');
$myTextElement->setSize(22);

// At least write the document to webspace:
$objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007');
$objWriter->save('helloWorld.docx');

Download address: http://www.phpdocx.com/

Online demo address: http://www.phpdocx.com/demo/sample-word-report

3, tcpdf PHP class for operating pdf

Online demonstration address: http://www.tcpdf.org/examples.php

After downloading, there are basically examples. The downloaded content is relatively large. This is because there are many examples in it, such as pdf and word files for examples, and there are also many font files. The class files to be used are actually not large. Record when you use it, so you don’t have to look for it everywhere. Ha ha. After TCPDF comes with 65 examples, you will be able to fully master how to use it. It can be roughly divided into the following 5 steps: 1. require_once imports the tcpdf.php file and the corresponding language of the config/lang/ directory 2. Instantiate TCPDF 3. Set the format of the PDF document, including document information, header, footer, font, outer spacing, picture border, paging, etc. 4. Import the content of a PDF document, which can be a single line or multi-line simple string, or a string in HTML format, etc.

5. Output PDF document

http://www.bkjia.com/PHPjc/631579.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631579.htmlTechArticleIn the early days, it was troublesome to use php to generate execl. I usually use csv instead. There are many such tools now and they are relatively mature. Not only excel, word, pdf. ...