First Baidu Search Phpexcel package, put in this directory of the project
Next comes the export code in the controller.
/**
Export Scheduled product user Information
* Great White donkey 675835721
*2016-12-12
**/
Public Function Expuser () {
$p _name = $_post[' order_p_name ');
$m = m (' order_list ');
$datas [' order_p_name '] = $p _name;
$data = $m->field (' Order_id,order_p_name,order_p_price,order_p_username,order_p_tel,order_time ')->select () ;
foreach ($data as $k = $v)
{
$data [$k] [' Order_time ']= $v [' Order_time ']=date (' y-m-d ', $v [' order_time ']);
}
Import the Phpexcel class library because Phpexcel does not use a namespace, only inport import
Import ("Org.Util.PHPExcel");
Import ("Org.Util.PHPExcel.Writer.Excel5");
Import ("Org.Util.PHPExcel.IOFactory.php");
$filename = "Test_excel";
$HEADARR =array ("number", "Name", "Price", "name", "Phone", "date");
$this->getexcel ($filename, $HEADARR, $data);
}
Private Function Getexcel ($fileName, $HEADARR, $data) {
Verify the data
if (Empty ($data) | |!is_array ($DATA)) {
Die ("Data must is a array");
}
Check file name
if (empty ($fileName)) {
Exit
}
$date = Date ("Y_m_d", Time ());
$fileName. = "_{$date}.xls";
Create a Phpexcel object, note that there is no less \
$objPHPExcel = new \phpexcel ();
$objProps = $objPHPExcel->getproperties ();
Set up the table header
$key = Ord ("A");
foreach ($headArr as $v) {
$colum = Chr ($key);
$objPHPExcel->setactivesheetindex (0)->setcellvalue ($colum. ' 1 ', $v);
$key + = 1;
}
$column = 2;
$objActSheet = $objPHPExcel->getactivesheet ();
foreach ($data as $key = + $rows) {//Line write
$span = Ord ("A");
foreach ($rows as $keyName = + $value) {//Column write
$j = Chr ($span);
$objActSheet->setcellvalue ($j. $column, $value);
$span + +;
}
$column + +;
}
$fileName = Iconv ("Utf-8", "gb2312", $fileName);
Renaming a table
$objPHPExcel->getactivesheet ()->settitle (' Test ');
Set the activity Order index to the first table, so Excel opens this is the first table
$objPHPExcel->setactivesheetindex (0);
Ob_end_clean ();
Ob_start ();
Header (' Content-type:application/vnd.ms-excel ');
Header ("content-disposition:attachment;filename=\" $fileName \ "");
Header (' cache-control:max-age=0 ');
$objWriter = \phpexcel_iofactory::createwriter ($objPHPExcel, ' Excel5 ');
$objWriter->save (' php://output '); Files are downloaded through the browser
Exit
}
in front of the HTML, you can call it directly.
thinkphp 3.2.2 Using Phpexcel to complete the Excel export function