Export excel data using php

Two excel export methods are provided. 1. export excelheader (& amp; #39; Content-Type: application/vnd. ms-excel & amp; #39;); // you can set the file type to vnd. change ms-excel & amp; #39; to xml (export xml file) header (& amp; #39 two excel export methods are provided. 1. the simplest way to export an excel header ('content-Type: application/vnd. ms-excel '); // you can set the file type to vnd. change ms-excel 'to xml (export xml file) header ('content-Disposition: attachment; filename = "cloud platform user report .xls "'); // Set the exported excel name header ('cache-Control: max-age = 0'); echo iconv ("UTF-8", "gbk", "Time \ t error code \ t occurrences \ t error code meaning \ n "); // \ t is a tab character \ n is a linefeed 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 an excel file and download the phpexcel package. put the php and phpexcel packages in your project: require_once ('phpexcel. php '); // reference the two files require_once ('phpexcel/Writer/excel2007.php'); // export ex Cel $ 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. // Display the call only when multiple sheets are used. // By default, PHPExcel will automatically create the first sheet with the SheetIndex set to 0 $ objExcel-> setActiveSheetIndex (0); $ objActSheet = $ objExcel-> getActiveSheet (); // online games // Set the name of the current activity sheet $ objActSheet-> setTitle ('Online Games class'); $ 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 address'); $ objActSheet-> setCellValue ('F1', 'corresponding to the optimized route entry '); $ objActSheet-> setCellValue ('g1 ', 'keyword optimization'); $ objActSheet-> setCellValue ('h1', 'optimized line '); $ objActSheet-> setCellValue ('i1', 'optimized 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 class // 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'); $ reource_ready-> setCellValue ('C1', 'line attribute '); $ reource_ready-> setCellValue ('d1 ', 'Ip CIDR block'); $ reource_ready-> setCellValue ('e1 ', 'optimized line '); $ reource_ready-> setCellValue ('F1', 'optimized status'); foreach ($ result_website as $ k1 =>$ v2) {$ reource_ready-> setCellValue ('A '. ($ k1 + 2), $ v2 ["name"]); $ reource_ready-> setCellValue ('B '. ($ k1 + 2), $ v2 ['domain ']); $ reource_ready-> setCellValue ('C '. ($ k1 + 2), $ v2 ['line _ attribute']); $ reource_ready-> setCellValue ('D '. ($ k1 + 2), $ v2 ['IP']); $ reource_ready-> setCellValue ('E '. ($ k1 + 2), $ v2 ['line']); $ reource_ready-> setCellValue ('F '. ($ k1 + 2), $ v2 ['optimize _ status']);} // you can export an excel file containing multiple sheets.