php 導(dǎo)出excel數(shù)據(jù)實(shí)例代碼

2024-05-04 21:49:14

字體：大中小

供稿：網(wǎng)友

在php中要導(dǎo)入excel表格我們最簡單的就是輸入csv文件,還有一種辦法就是使用PHPExcel插件來實(shí)現(xiàn),常用的都是使用PHPExcel插件了,它有強(qiáng)大的功能,下面我們來看個(gè)實(shí)例.

很多網(wǎng)站都有導(dǎo)出數(shù)據(jù)為excel的功能,最開始想用js導(dǎo)出但是網(wǎng)上的文章幾乎都一樣而且瀏覽器兼容性還有問題,總之不太好用,那只好用php導(dǎo)出了服務(wù)器端處理不存在瀏覽器兼容的問題.

首先是獲取數(shù)據(jù)發(fā)送到php端處理,代碼如下:

require_once '../Classes/PHPExcel.php';

require_once '../Classes/PHPExcel/IOFactory.php';

$objPHPExcel = new PHPExcel();

$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");

$objPHPExcel->setActiveSheetIndex(0);

$objRichText = new PHPExcel_RichText();

$objRichText->createText('');

$objPayable = $objRichText->createTextRun('即時(shí)監(jiān)測數(shù)據(jù)');

$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_RED ));

$objPayable->getFont()->setBold(true);

$objPayable->getFont()->setSize(24);

$objPHPExcel->getActiveSheet()->getCell('B1')->setValue($objRichText);

$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);  // 加粗

$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(24);   // 字體大小

$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); // 文本顏色

$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);

$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFill()->getStartColor()->setARGB('00FFFFE3');//底紋

// 列寬

//$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(18);

$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);

$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(18);

$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);

$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(18);

$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);

// 行高

for($i = 2; $i <= 17; $i++) {

$objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(22);

}

$objPHPExcel->getActiveSheet()->setCellValue('A2', '姓名');

$objPHPExcel->getActiveSheet()->setCellValue('A3', 'PHP');

$objPHPExcel->getActiveSheet()->setCellValue('A4', 'EXCEL');

$objPHPExcel->getActiveSheet()->setCellValue('A5', '');

$objPHPExcel->getActiveSheet()->setCellValue('A6', 'XXX');

$objPHPExcel->getActiveSheet()->setCellValue('A7', 'V');

$objPHPExcel->getActiveSheet()->setCellValue('A8', 'd');

$objPHPExcel->getActiveSheet()->setCellValue('A9', 'name');

$objPHPExcel->getActiveSheet()->setCellValue('A10', '描述');

for($i = 2; $i <= 16; $i++) {

$objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getFont()->setBold(true);  // 加粗

}

$objPHPExcel->getActiveSheet()->setCellValue('B2', '[姓名]');

$objPHPExcel->getActiveSheet()->setCellValue('B3', '導(dǎo)出帶圖片的EXCEL');

$objPHPExcel->getActiveSheet()->setCellValue('B4', 'XXXXX');

// 為excel加圖片

//$objDrawing = new PHPExcel_Worksheet_Drawing();

//$objDrawing->setName('Photo');

//$objDrawing->setDescription('Photo');

//$objDrawing->setPath('../images/touxiang.jpg');

//$objDrawing->setHeight(170);

//$objDrawing->setWidth(120);

//$objDrawing->setCoordinates('G2');

//$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

$objPHPExcel->getActiveSheet()->setCellValue('A17', '其它要求');

$objPHPExcel->getActiveSheet()->setCellValue('B17', '[其它要求]');

$objPHPExcel->getActiveSheet()->getStyle('A17')->getFont()->setBold(true);  // 加粗Vevb.com

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->setTitle('即時(shí)監(jiān)測數(shù)據(jù)');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('PHPExcel.xls');