phpExecel 读写xlsx表格文件

最新推荐文章于 2024-09-05 16:11:33 发布

qq_33440662

最新推荐文章于 2024-09-05 16:11:33 发布

阅读量301

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/qq_33440662/article/details/81982097

版权

PHP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

到https://github.com/PHPOffice/PHPExcel下载PHPExcel

date_default_timezone_set(‘UTC’);
require_once ‘PHPExcel-1.8/Classes/PHPExcel.php’;
require_once ‘PHPExcel-1.8/Classes/PHPExcel/IOFactory.php’;

//打开
$objPHPExcel = PHPExcel_IOFactory::load(“test1.xlsx”);

// 确定要读取的sheet
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
//$highestColumn = $sheet->getHighestColumn();

// 读写数据数据
for ($row = 2; $row <= $highestRow; $row++){
echo $sheet->getCell(‘B’.$row)->getValue()；
echo $sheet->getCell(‘C’.$row)->getValue()；
$sheet->setCellValue(‘B’.$row, “hello”);
$sheet->setCellValue(‘C’.$row, “world”);
}

//保存
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007’);
$objWriter->save(“test1.xlsx”);