## php導出excel
* 使用開源插件: phpexcel
* github : [https://github.com/PHPOffice/PHPExcel](https://github.com/PHPOffice/PHPExcel)
>[info] 簡單封裝
~~~
class ReportExcel
{
private $objPHPExcel = null;
private $objSheet = null;
public function __construct()
{
$this->objPHPExcel = new PHPExcel();
$this->objSheet = $this->objPHPExcel->getActiveSheet();
}
/**
* 設置標題
* @param string $title
* @throws PHPExcel_Exception
*/
public function setTitle($title = 'Report')
{
$this->objPHPExcel->getProperties()->setCreator("sgfoot")
->setLastModifiedBy("sgfoot")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
$this->objSheet->setTitle($title);
}
//設置單元格
public function setCell($cell, $value)
{
$this->objSheet->setCellValue($cell, $value);
}
/**
* 設置列寬
* @param $column
* @param int $width
*/
public function setWidth($column, $width = 12)
{
$this->objSheet->getColumnDimension($column)->setWidth($width);
}
/**
* 設置文本
* @param $cell
* @param $value
* @throws PHPExcel_Exception
*/
public function setText($cell, $value)
{
$this->objSheet->setCellValueExplicit($cell, $value, PHPExcel_Cell_DataType::TYPE_STRING);
}
/**
* 設置字體和大小
* @param $columnName
* @param int $fontSize
* @param string $fimalyName
* @author: wzl
* @date: 2017
*/
public function setFont($columnName, $fontSize = 12, $fimalyName = 'DengXian')
{
$this->objSheet->getStyle($columnName)->getFont()->setName($fimalyName)->setSize($fontSize);
}
/**
* 設置字體顏色
* @param $columnName
* @param string $color
* @author: wzl
* @date: 2017
*/
public function setFontColor($columnName, $color = PHPExcel_Style_Color::COLOR_RED)
{
$this->objSheet->getStyle($columnName)->getFont()->getColor()->setARGB($color);
}
/**
* 設置單元格里的字體位置
* @param $columnName
* @param string $position
* @author: wzl
* @date: 2017
*/
public function setFontPosition($columnName, $position = 'left')
{
$this->objSheet->getStyle($columnName)->getAlignment()
->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)//設置單元格垂直居中
->setHorizontal($position);//單元格水平靠左
}
/**
* 設置字體為粗體 例:$obj->setBold('A1:J1');
* @param $columnName
* @author: wzl
* @date: 2017
*/
public function setBold($columnName)
{
$this->objSheet->getStyle($columnName)->getFont()->setBold(true);
}
/**
* 設置單元格垂直左右居中
* @param $columnName
* @author: wzl
* @date: 2017
*/
public function setCellCenter($columnName)
{
$this->objSheet->getStyle($columnName)->getAlignment()
->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)
->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER)
->setWrapText(true);
}
/**
* 設置下劃線
* @param $columnName
* @author: wzl
* @date: 2017
*/
public function setUnderline($columnName)
{
$this->objSheet->getStyle($columnName)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
}
/**
* 設置邊框
* @param $columnName
* @author: wzl
* @date: 2017
*/
public function setBorder($columnName)
{
$this->objSheet->getStyle($columnName)->applyFromArray($this->_setBorder());
}
/**
* 合并單元格
* @param $columnName
* @author: wzl
* @date: 2017
*/
public function mergeCells($columnName)
{
$this->objSheet->mergeCells($columnName);
}
/**
* 設置背景顏色,默認黃色
* const COLOR_BLACK = 'FF000000';
* const COLOR_WHITE = 'FFFFFFFF';
* const COLOR_RED = 'FFFF0000';
* const COLOR_DARKRED = 'FF800000';
* const COLOR_BLUE = 'FF0000FF';
* const COLOR_DARKBLUE = 'FF000080';
* const COLOR_GREEN = 'FF00FF00';
* const COLOR_DARKGREEN = 'FF008000';
* const COLOR_YELLOW = 'FFFFFF00';
* const COLOR_DARKYELLOW = 'FF808000';
* @param $i
* @param string $color
* @author: wzl
* @date: 2017
*/
public function setBackColor($i, $color = PHPExcel_Style_Color::COLOR_YELLOW)
{
$this->objSheet->getStyle($i)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);//填充顏色
$this->objSheet->getStyle($i)->getFill()->getStartColor()->setARGB($color);//填充顏色
}
/**
* 設置邊框
* @author: wzl
* @date: 2017
* @return array
*/
private function _setBorder()
{
$styleArray = array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,//細邊框
),
),
);
return $styleArray;
}
/**
* 導出
* @param string $filename
* @throws PHPExcel_Reader_Exception
* @throws PHPExcel_Writer_Exception
*/
public function output($filename = '')
{
if (empty($filename)) {
$filename = date('Ymd-' . mt_rand(100, 999)) . '.xlsx';
} else {
if (strpos($filename, '.xlsx') === false) {
$filename .= '.xlsx';
}
}
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0
$objWriter = PHPExcel_IOFactory::createWriter($this->objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
}
}
~~~
- 總導航
- 第一章 前端
- 1.0 js自定義模板
- 第二章 PHP
- 1.0 推薦博客
- 2.0 基礎理論
- 0.1 require和include區別
- 0.2 php運行機制
- 0.3 Http請求與響應
- 0.4 http響應狀態
- 3.0 Laravel框架
- 0.1 Eloquent ORM
- 0.2 時間處理
- 0.3 數據遷移
- 0.4 填充數據
- 4.0 composer安裝
- 5.0 緩存
- 0.1 Opcache
- 0.2 Memcache
- 0.3 Redis
- 0.4 Output buffer
- 第三章 MYSQL
- 1.0 新增和重置密碼
- 第四章 前端插件集
- 1.0 PreloadJS
- 0.1 LoadQueue
- 0.2 加載單個文件
- 0.3 加載進度顯示
- 0.4 加載指定目錄圖片
- 0.5 加載json圖片
- 2.0 Swiper
- 3.0 ECharts
- 0.1 簡單實例
- 0.2 title操作
- 0.3 tooltip操作
- 0.4 top顯示數字
- 0.5 雙數據顯示
- 0.6 大數據縮放顯示
- 0.7 綜合
- 4.0 Vue
- 0.1 模板語法
- 0.2 條件與循環
- 0.3 處理用戶輸入
- 0.4 計算屬性
- 0.5 事件綁定
- 0.6 動態渲染列表
- 5.0 layui
- 0.1 動態渲染nav
- 0.2 layer使用
- 6.0 IScroll
- 7.0 AlloyTouch
- 8.0 jquery.tagsinput
- 9.0 Editormd
- 第五章 應用軟件
- 1.0 Xshell
- 一螺集
- PHP
- 打印一天的區間時間
- 友好時間輸出
- 導出Excel
- JAVASCRIPT
- js回車事件