【PHPExcel】各种数据类型

最新推荐文章于 2023-12-26 13:55:08 发布

原创最新推荐文章于 2023-12-26 13:55:08 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍如何使用 PHPExcel 库创建包含多种数据类型的 Excel 文件，并设置了文档属性、字体样式及日期时间格式等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//错误处理 时区设置
error_reporting(E_ALL);
ini_set('display_errors',TRUE);
ini_set('display_startup_errors',TRUE);
date_default_timezone_set('PRC');

require_once './Classes/PHPExcel.php';

$obj = new PHPExcel();
//设置文档属性
$obj->getProperties()->setCreator('IIIThSoul')//创建者
					->setLastModifiedBy('IIIThSoul')//最后修改者
					->setTitle('PHPExcel Test Document')//标题
					->setSubject('PHPExcel Test Document')//主题
					->setDescription('PHPExcel测试文档')//设置文档描述
					->setKeyWords('office PHPExcel php')//关键词
					->setCategory('Test result file');//分类

//设置默认字体
$obj->getDefaultStyle()->getFont()->setName('Arial')->setSize(10);

//添加一些数据 数据格式要不同
$obj->getActiveSheet()->setCellValue('A1','String')
					  ->setCellValue('B1','Simple')
					  ->setCellValue('C1','PHPExcel');

$obj->getActiveSheet()->setCellValue('A2','String')
					  ->setCellValue('B2','Symbols')
					  ->setCellValue('C2','!+&()~');

$obj->getActiveSheet()->setCellValue('A3','String')
					  ->setCellValue('B3','UTF-8')
					  ->setCellValue('C3','Создать MS Excel Книги из PHP скриптов');

$obj->getActiveSheet()->setCellValue('A4','Number')
					  ->setCellValue('B4','Integer')
					  ->setCellValue('C4',12);

$obj->getActiveSheet()->setCellValue('A5','Number')
					  ->setCellValue('B5','Float')
					  ->setCellValue('C5',35.32);

$obj->getActiveSheet()->setCellValue('A6','Number')
					  ->setCellValue('B6','Negative')
					  ->setCellValue('C6',-12.23);

$obj->getActiveSheet()->setCellValue('A7','Boolean')
					  ->setCellValue('B7','True')
					  ->setCellValue('C7',true);

$obj->getActiveSheet()->setCellValue('A8','Boolean')
					  ->setCellValue('B8','False')
					  ->setCellValue('C8',false);
$dateTimeNow = time();
$obj->getActiveSheet()->setCellValue('A9','Date/Time')
					  ->setCellValue('B9','Date')
					  ->setCellValue('C9',PHPExcel_Shared_Date::PHPToExcel($dateTimeNow));
$obj->getActiveSheet()->getStyle('C9')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2);

$obj->getActiveSheet()->setCellValue('A10','Date/Time')
					  ->setCellValue('B10','Time')
					  ->setCellValue('C10',PHPExcel_Shared_Date::PHPToExcel($dateTimeNow));
$obj->getActiveSheet()->getStyle('C10')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4);

$obj->getActiveSheet()->setCellValue('A11','Date/Time')
					  ->setCellValue('B11','Date and Time')
					  ->setCellValue('C11',PHPExcel_Shared_Date::PHPToExcel($dateTimeNow));
$obj->getActiveSheet()->getStyle('C11')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME);

$obj->getActiveSheet()->setCellValue('A12','NULL')
					  ->setCellValue('C12',NULL);

//创建富文本对象
$objRichText = new PHPExcel_RichText();
$objRichText->createText('你好');

$objPayable = $objRichText->createTextRun('你 好 吗 ？');
$objPayable->getFont()->setBold(true);//设为粗体
$objPayable->getFont()->setItalic(true);//设为斜体
//设置字体颜色
$objPayable->getFont()->setColor(new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_DARKGREEN));

$objRichText->createText(',unless specified otherwise on the invoice.');

$obj->getActiveSheet()->setCellValue('A13','Rich Text')
					  ->setCellValue('C13',$objRichText);

$obj->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);//设置B列宽度自动
$obj->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);

$obj->getActiveSheet()->setTitle('DataTypes');
$obj->getActiveSheetIndex(0);

$obj = PHPExcel_IOFactory::createWriter($obj,'Excel2007');
$obj->save(str_replace('.php','.xlsx',__FILE__));