Sharing of pdf word excel operation classes in php

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 <= $highestRow; $row++){//行数是以第1行开始
for ($column = 0; $column < $highestColumm; $column++) {//列数是以第0列开始
$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 <= $highestRow; $row++){//The number of rows starts with row 1
for ($column = 0; $column < $highestColumm; $column++) {//The number of columns starts with column 0
$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 <= $highestRow; $row++){//行数是以第1行开始
for ($column = 'A'; $column <= $highestColumm; $column++) {//列数是以A列开始
$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 <= $highestRow; $row++){//The number of rows starts with row 1
for ($column = 'A'; $column <= $highestColumm; $column++) {//The number of columns starts with column A
$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));

// 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

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. ...

Sharing of pdf word excel operation classes in php_PHP tutorial