PHPExcel是一个用于处理和操作Excel文件的PHP库。它可以非常方便地读取、写入和操作Excel文件，并且可以在你的PHP应用程序中进行扩展和自定义。PHPExcel是一个流行的PHP库，因为许多公司和开发者都使用它来创建和处理Excel文档。
我们来看一个例子，假设你正在编写一个应用程序，需要在Excel文件中记录和保存一些数据。假设你要给客户发送一份产品报价表格，这个表格包括了产品的名称、价格、描述和其他一些重要的信息。你可以使用PHPExcel来创建这个文档，同时也可以方便地格式化和添加注释。以下是一个简单的PHPExcel示例：
<?php
// Include PHPExcel library
require 'PHPExcel/Classes/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("My Name")
->setLastModifiedBy("My Name")
->setTitle("Product Catalog")
->setSubject("Example Product Catalog")
->setDescription("This document describes the products available on our site.")
->setKeywords("products, catalog");
// Create worksheet
$objPHPExcel->setActiveSheetIndex(0);
$worksheet = $objPHPExcel->getActiveSheet();
// Set header row
$headers = array("Product Name", "Price", "Description");
$worksheet->fromArray($headers, NULL, 'A1');
// Add data rows
$products = array(
array("Product A", 19.99, "This is a great product."),
array("Product B", 29.99, "This product is awesome."),
array("Product C", 39.99, "Get this product now!")
);
$worksheet->fromArray($products, NULL, 'A2');
// Format cells
$worksheet->getStyle('A1:C1')->getFont()->setBold(true);
$worksheet->getStyle('A1:C1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB('F0F0F0');
$worksheet->getStyle('A1:C1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// Add comment
$comment = $worksheet->getComment('A2');
$comment->getText()->createTextRun('This is a comment.');
$comment->setAuthor('My Name');
// Save document as Excel file
$writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$writer->save('product_catalog.xlsx');<?php
// Include PHPExcel library
require 'PHPExcel/Classes/PHPExcel.php';
// Load Excel file
$objPHPExcel = PHPExcel_IOFactory::load("product_catalog.xlsx");
// Get worksheet
$worksheet = $objPHPExcel->getActiveSheet();
// Get highest row and column
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
// Loop through rows
for ($row = 1; $row<= $highestRow; $row++) {
// Loop through columns
for ($col = 'A'; $col<= $highestColumn; $col++) {
// Get cell value
$cellValue = $worksheet->getCell($col . $row)->getValue();
// Output cell value
echo $cellValue . " ";
}
echo "<br/>";
}