步骤:
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");
}
其中有隐藏的代码,用得着的时候打开。