PHP生成Excel报表
<?php
$path = '/usr/share/pear'; // 你自定义的 PEAR 路径
set_include_path(get_include_path() . PATH_SEPARATOR . $path); // 设置 PHP 环境变量路径为除 php.ini 默认的以外, 再加上你自定义的 PEAR 路径
require '/usr/share/pear/Spreadsheet/Excel/Writer.php'; // 包含 PEAR::Spreadsheet_Excel_Writer 类文件
$name = 'atyu30';
$work = $_POST['file_body'];
$num = '10';
$filename = $_POST['file_name'];
$name_suffix01 = '_报告.xls';
$name_suffix02 = iconv('utf-8','gb2312',$name_suffix01);
$workbook = new Spreadsheet_Excel_Writer(); // 实例化 PEAR::Spreadsheet_Excel_Writer 类
$workbook->send($filename.$name_suffix02); // 发送 Excel 文件名供下载
$workbook->setVersion(8);
$worksheet =& $workbook->addWorksheet('sheet-1'); // 加入一个工作表 sheet-1
$worksheet->setInputEncoding('utf-8'); // 指定行编码
$data = array(
array('姓名', '节目清单', '上传数量'),
array($name, $work, $num),
array($name, $work, $num),
);
for ($row = 0; $row < count($data); $row ++) {
for ($col = 0; $col < count($data[0]); $col ++) {
$worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-1 中写入数据
}
}
$worksheet =& $workbook->addWorksheet('sheet-2'); // 加入一个工作表 sheet-2
$worksheet->setInputEncoding('utf-8'); // 指定行编码
$data = array(
array('姓名', '节目清单', '上传数量'),
array($name, $work, $num),
array($name, $work, $num),
);
for ($row = 0; $row < count($data); $row ++) {
for ($col = 0; $col < count($data[0]); $col ++) {
$worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-2 中写入数据
}
}
$workbook->close(); // 完成下载
echo $name;
?>
高评分电影
更新日志
- 公开赛魅影 The.Phantom.of.the.Open.2021.1080p.BluRay.AVC.DTS-HD.MA.5.1-INCUBO 26.74GB
- 男人 Men.2022.1080p.BluRay.AVC.DTS-HD.MA.5.1-FGT 36.11GB
- 公开赛魅影 The.Phantom.of.the.Open.2021.1080p.BluRay.REMUX.AVC.DTS-HD.MA.5.1-FGT 24.91GB
- 男人 Men.2022.1080p.BluRay.REMUX.AVC.DTS-HD.MA.5.1-FGT 26.58GB
- 最后的决斗[简繁英双语字幕].The.Last.Duel.2021.1080p.BluRay.1080p.DTS-HD.MA7.1.x265.10bit-ALT 9.73GB
- 爱人的最后一封情书[简繁英双语字幕].The.Last.Letter.from.Your.Lover.2021.BluRay.1080p.DTS-HD.MA5.1.x265.10bit-ALT 7.00GB
- 光年正传 Lightyear.2022.IMAX.1080p.WEBRip.x264-RARBG 2.01GB
- 终极胜利[国语音轨/简繁英字幕].The.Last.Race.2016.BluRay.1080p.TrueHD.5.1.x265.10bit-ALT 11.09GB
- 光年正传 Lightyear.2022.IMAX.2160p.DSNP.WEB-DL.DDP5.1.Atmos.DV.MP4.x265-DVSUX 12.73GB
- 最后一站[国英多音轨/简繁英双语字幕].The.Last.Station.2009.BluRay.1080p.2Audio.DTS-HD.MA5.1.x265.10bit-ALT 7.73GB
- 4.1周年庆版本“重置首冲双倍”能挽救拉胯的流水吗?
- 未完成的喜剧系列三通关攻略,任务攻略
- 4.1火角色武器选择推荐表,武器怎么选择
- 大上海[国粤英多音轨/简繁英字幕].The.Last.Tycoon.2012.BluRay.1080p.2Audio.DTS-HD.MA.7.1.x265.10bit-ALT 17.41GB
- 光年正传 Lightyear.2022.IMAX.2160p.DSNP.WEB-DL.DDP5.1.Atmos.DV.MKV.x265-SMURF 12.73GB
- 乐高幻影忍者大电影[国粤英多音轨/简繁英字幕].The.LEGO.Ninjago.Movie.2017.BluRay.1080p.3Audio.TrueHD.Atmos.7.1.x265.10bit-ALT 7.89GB
- 小偷[简繁英字幕].The.Little.Thief.1988.BluRay.1080p.DTS-HD.MA.2.0.x265.10bit-ALT 9.47GB
- 龙虾[繁英字幕].The.Lobster.2015.BluRay.1080p.DTS-HD.MA5.1.x265.10bit-ALT 8.78GB
- 癫佬正传[国粤英多音轨/繁英字幕].The.Lunatics.1986.BluRay.1080p.2Audio.TrueHD.7.1.x265.10bit-ALT 8.70GB
- 新仙鹤神针[粤语音轨/繁英字幕].The.Magic.Crane.1993.BluRay.1080p.TrueHD.5.1.x265.10bit-ALT 6.95GB