PHPexcel 生成 excel 文件

最新推荐文章于 2024-02-23 10:17:21 发布

youliangtian

最新推荐文章于 2024-02-23 10:17:21 发布

阅读量513

点赞数

文章标签： Excel phpexcel

本文链接：https://blog.csdn.net/youliangtian/article/details/8941515

版权

<?php
include_once '/include/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setTitle('Simple');
//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1',mb_convert_encoding('优惠券去码','utf8','gbk'));
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1',mb_convert_encoding('日期','utf8','gbk'));
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1',mb_convert_encoding('限时','utf8','gbk'));
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1',mb_convert_encoding('备注','utf8','gbk'));

$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A2',mb_convert_encoding('优惠券去码2222','utf8','gbk'));

$objWriter->save("./test.xls");