PHPExcel 导出功能 php

斯文狂

已于 2023-12-12 13:09:28 修改

阅读量349

点赞数 9

分类专栏： PHP 文章标签： php excel

于 2023-12-11 11:13:29 首次发布

本文链接：https://blog.csdn.net/weixin_42541422/article/details/134922264

版权

PHP 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

步骤：

1、引入 -phpexcel插件插件（我的资源里有这个插件）

2、计算代码

下面开始具体代码：(php)

$exdata = [];
foreach($huizong as $v){
    $kahao = "JJM00" . $v['user_id'];
	$exdata[] = [$v['riqi'],$kahao,$v['name'],$v['age'],$v['object_name'],$v['cishu'],$v['product_price'],$v['yingshou'],$v['fukuan'],$v['fukuan'],$v['xianjinpay'],$v['shuakapay'],$v['cunkuanpay'],$v['docor'],$v['kaifa'],$v['guwen'],$v['source'],$v['chuzhen']]; //插入表格的数据 array 
}
$header = ["营业日期","客户卡号","姓名","年龄","手术项目/产品","次数","单价","应付金额","已付金额","收款金额","其中现金","其中卡额","存款支付","医生/主刀医生","所属开发人员","所属顾问","信息来源","初诊日期"]; //表格的TITLE
ExpensHistoryExport($exdata,$header,$timec,$timed,$filename="项目数据");  //调用function

调用的函数（其实也可以写在一起，为了复用，才用的函数）

 function ExpensHistoryExport($exdata,$header,$timec,$timed,$filename){
	require("phpexcel/PHPExcel.php");

	if (!is_array ($exdata) || !is_array ($header)) return false;

	$objPHPExcel = new \PHPExcel();

	// Set properties
	$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
	$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
	$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
	$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
	$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
	// Add some data
	$objPHPExcel->setActiveSheetIndex(0);
	//添加头部
	$hk = 0;
	
	foreach ($header as $k => $v)
	{
		$colum = \PHPExcel_Cell::stringFromColumnIndex($hk);
		$objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum."1", $v);
		$hk += 1;
	}

	$column = 2;
	$objActSheet = $objPHPExcel->getActiveSheet();
	$span = 0;
	foreach($exdata as $key => $rows)  //行写入
	{
		if (is_array($rows)) {
			$span = 0;
			foreach($rows as $keyName => $value) // 列写入
			{
				$j = \PHPExcel_Cell::stringFromColumnIndex($span);
				$objActSheet->setCellValue($j.$column, $value);
				$span++;
			}
			$column++;
		} else {
			$j = \PHPExcel_Cell::stringFromColumnIndex($span);
			$objActSheet->setCellValue($j.$column, $rows);
			$span++;          
		}
	}

			//写总计
	// $highestRow = $objActSheet->getHighestRow(); // 取得总行数

	// $objActSheet->setCellValue("A".($highestRow+1), '信息总条数：');
	// $objActSheet->getStyle("A".($highestRow+1))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);//文字右对齐
	// $objActSheet->getStyle("A".($highestRow+1))->getFont()->setBold(true);//加粗

	// $objActSheet->setCellValue("B".($highestRow+1), $total);
	// $objActSheet->getStyle("B".($highestRow+1))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//金额居中
	// $objActSheet->getStyle("B".($highestRow+1))->getFont()->setBold(true);//加粗
	
	
	// $objActSheet->setCellValue("A".($highestRow+2), '商标注册总数：');
	// $objActSheet->getStyle("A".($highestRow+2))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);//文字右对齐
	// $objActSheet->getStyle("A".($highestRow+2))->getFont()->setBold(true);//加粗

	// $objActSheet->setCellValue("B".($highestRow+2), $zpts);
	// $objActSheet->getStyle("B".($highestRow+2))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//金额居中
	// $objActSheet->getStyle("B".($highestRow+2))->getFont()->setBold(true);//加粗


	// Rename sheet
	$objPHPExcel->getActiveSheet()->setTitle('sheet Title');
	// Save Excel 2007 file
   // $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
	$objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
	header("Pragma:public");
	header("Content-Type:application/x-msexecl;name=\"$timec | $timed | $filename.xls\"");
	header("Content-Disposition:inline;filename=\"$timec | $timed | $filename.xls\"");   
	$objWriter->save("php://output");


 }

其中有隐藏的代码，用得着的时候打开。