Export excel data with php_PHP tutorial-PHP Tutorial-php.cn

Export excel data with php_PHP tutorial

WBOY

Release： 2016-07-15 13:21:57

Original

1061 people have browsed it

Provide two methods to export excel

1 The simplest way to export excel

header('Content-Type: application/vnd.ms-excel'); //Set the file type You can also change vnd.ms-excel' to xml (export xml file)

header('Content-Disposition: attachment;filename="Cloud platform user report.xls"'); //Set the name of the exported excel

header('Cache-Control: max-age=0');

echo iconv("utf-8", "gbk", "Time t error code t number of occurrences t error code meaning n"); // t is a tab character n is a newline character

foreach ($arr as $key=>$val){ //$arr is the data to be exported

echo iconv("utf-8","gbk",date("Y-m-d",$val["time"])."t".$val["error_code"]."t".$val[ "num"]."t".$val["code_mean"]."n");

}

2. Use phpexcel to export excel

Go to the Internet to download the phpexcel compressed package and put phpexcel.php and the phpexcel compressed package into your project

Example:

require_once ('PHPExcel.php'); //Reference these two files

require_once ('PHPExcel/Writer/Excel2007.php');

//Export excel

$objExcel = new PHPExcel();

$objProps = $objExcel->getProperties();

$objProps->setCreator("Zeal Li");

$objProps->setLastModifiedBy("Zeal Li");

$objProps->setTitle("Office XLS Test Document");

$objProps->setSubject("Office XLS Test Document, Demo");

$objProps->setDescription("Test document, generated by PHPExcel.");

$objProps->setKeywords("office excel PHPExcel");

$objProps->setCategory("Test");

$objProps = $objExcel->getProperties();

$objProps->setCreator("Zeal Li");

$objProps->setLastModifiedBy("Zeal Li");

$objProps->setTitle("Office XLS Test Document");

$objProps->setSubject("Office XLS Test Document, Demo");

$objProps->setDescription("Test document, generated by PHPExcel.");

$objProps->setKeywords("office excel PHPExcel");

$objProps->setCategory("Test");

//************************************

//Set the current sheet index for subsequent content operations.

//Generally, display calls are only needed when using multiple sheets.

//By default, PHPExcel will automatically create the first sheet and set SheetIndex=0

$objExcel->setActiveSheetIndex(0);

$objActSheet = $objExcel->getActiveSheet();

//Online games

//Set the name of the current active sheet

$objActSheet->setTitle('Online Games');

$objActSheet->setCellValue('A1','Game Name'); //The first row of data in the first sheet in the generated excel

$objActSheet->setCellValue('B1','Specific domain name');

$objActSheet->setCellValue('C1','Server Description');

$objActSheet->setCellValue('D1','Line Attribute');

$objActSheet->setCellValue('E1','Submitted server IP');

$objActSheet->setCellValue('F1','corresponding to optimized routing entry');

$objActSheet->setCellValue('G1','Keyword Optimization');

$objActSheet->setCellValue('H1','Optimize Line');

$objActSheet->setCellValue('I1','Optimization status');

foreach($result_webgame as $k1=>$v1){ //Traverse the data read from the database

$objActSheet->setCellValue('A'.($k1+2),$v1["gamename"]);

$objActSheet->setCellValue('B'.($k1+2),$v1['domain']);

$objActSheet->setCellValue('C'.($k1+2),$v1['gameserver']);

$objActSheet->setCellValue('D'.($k1+2),$v1['line_attribute']);

$objActSheet->setCellValue('E'.($k1+2),$v1['server_ip']);

$objActSheet->setCellValue('F'.($k1+2),$v1['optimize_route']);

$objActSheet->setCellValue('G'.($k1+2),$v1['keyword']);

$objActSheet->setCellValue('H'.($k1+2),$v1['line']);

$objActSheet->setCellValue('I'.($k1+2),$v1['optimize_status']);

}

//Website category

//Add a new worksheet

$objExcel->createSheet();

$reource_ready=$objExcel->getSheet(1)->setTitle('Website Class');

$reource_ready->setCellValue('A1','Website Name');

$reource_ready->setCellValue('B1','Specific domain name');

$resource_ready->setCellValue('C1','Line Attribute');

$resource_ready->setCellValue('D1','IP network segment');

$resource_ready->setCellValue('E1','Optimized line');

$resource_ready->setCellValue('F1','Optimization status');

foreach($result_website as $k1=>$v2){

$resource_ready->setCellValue('A'.($k1+2),$v2["name"]);

$reource_ready->setCellValue('B'.($k1+2),$v2['domain']);

$reource_ready->setCellValue('C'.($k1+2),$v2['line_attribute']);

$resource_ready->setCellValue('D'.($k1+2),$v2['ip']);

$resource_ready->setCellValue('E'.($k1+2),$v2['line']);

$reource_ready->setCellValue('F'.($k1+2),$v2['optimize_status']);

}

//By analogy, you can export excel containing multiple sheets

Php8, I'm coming too

Learn website layout in 30 minutes

Shangguan Oracle Beginner to Proficient Video Tutorial

Your first line of UNI-APP code

Flutter from scratch to app launch

Brother Lian New Linux Video Tutorial

AXURE 9 Video Tutorial (Suitable for Product Manager Interactive Product Design UI)

Zero Basic Proficiency PS Video Tutorial

16 day UI video tutorial to get you started

PS Techniques and Slicing Techniques Video Tutorial

Alibaba Cloud Environment Construction and Project Launch Video Tutorial

Overview of Computer Networks - Basic Knowledge that Programmers Must Master

Essential Tutorial for Programmers - HTTP Protocol Explanation

Websocket Video Tutorial

Export excel data with php_PHP tutorial