Home > Article > Backend Development > Detailed explanation of two methods of exporting excel files natively in php

Detailed explanation of two methods of exporting excel files natively in php

墨辰丷Original: 2018-05-30 16:21:452238browse

This article mainly introduces two methods of exporting excel files natively in PHP. Interested friends can refer to it. I hope it will be helpful to everyone.

First method:

$filename=&#39;文件名称&#39;;
  $filetitle=&#39;你的标题&#39;;
  if($_POST){
    set_time_limit(10000)；
    $title = &#39;&#39;;
    ini_set(&#39;memory_limit&#39;,&#39;300M&#39;);
    header(&#39;Content-Type: application/vnd.ms-excel;charset=utf-8&#39;);
    $name = $title.".xls";
    header(&#39;Content-Disposition: attachment;filename=&#39;.$name.&#39;&#39;);
    header(&#39;Cache-Control: max-age=0&#39;);
    $where = "1=1";
    $sql = "";
    $query = DB::Query($sql);
    // PHP文件句柄，php://output 表示直接输出到浏览器 
    $fp = fopen(&#39;php://output&#39;, &#39;a&#39;);
    // 输出Excel列头信息 
    $head = array(&#39;ID&#39;);
    //字符替换
    $p_new_lines = array("\r\n", "\n","\t","\r","\r\n", "<pre class="brush:php;toolbar:false">","

","
","
","
"); $p_change_line_in_excel_cell = ''; foreach($head as $v){ echo iconv('utf-8','gb2312',$v) . "\t"; } echo "\n"; // 计数器 $cnt = 0; // 每隔$limit行，刷新一下输出buffer，节约资源 $limit = 100000; // 逐行取出数据，节约内存 while ($res = mysql_fetch_assoc($query)) { $cnt ++; if ($limit == $cnt) { //刷新一下输出buffer，防止由于数据过多造成问题 ob_flush(); flush(); $cnt = 0; } echo trim($res['id']). "\t"; echo "\n"; } }

Second Method:

$filename=&#39;文件名称&#39;;
  $filetitle=&#39;你的标题&#39;;
  if($_POST){
    $title = &#39;&#39;;
    ini_set(&#39;memory_limit&#39;,&#39;300M&#39;);
    header(&#39;Content-Type: application/vnd.ms-excel;charset=utf-8&#39;);
    $name = $title.".xls";
    header(&#39;Content-Disposition: attachment;filename=&#39;.$name.&#39;&#39;);
    header(&#39;Cache-Control: max-age=0&#39;);
    echo &#39;<html xmlns:o="urn:schemas-microsoft-com:office:office"
      xmlns:x="urn:schemas-microsoft-com:office:excel"
      xmlns="http://www.w3.org/TR/REC-html40">
    <head>
      <meta http-equiv="expires" content="Mon, 06 Jan 1999 00:00:01 GMT">
      <meta http-equiv=Content-Type content="text/html; charset=gb2312">
      <!--[if gte mso 9]><xml>
      <x:ExcelWorkbook>
      <x:ExcelWorksheets>
       <x:ExcelWorksheet>
       <x:Name></x:Name>
       <x:WorksheetOptions>
        <x:DisplayGridlines/>
       </x:WorksheetOptions>
       </x:ExcelWorksheet>
      </x:ExcelWorksheets>
      </x:ExcelWorkbook>
      </xml><![endif]-->
    </head>&#39;;
    $where = "1=1";

    $sql = " ";
    mysql_query(&#39;set names "utf8"&#39;);
    mysql_set_charset(&#39;utf8&#39;);
    $query = DB::Query($sql);

    // PHP文件句柄，php://output 表示直接输出到浏览器 
    $fp = fopen(&#39;php://output&#39;, &#39;a&#39;);
    // 输出Excel列头信息 
    $head = array(&#39;ID&#39;,&#39;xxx&#39;);
    //字符替换
    $p_new_lines = array("\r\n", "\n","\t","\r","\r\n", "<pre class="brush:php;toolbar:false">","

","
","
","
"); $p_change_line_in_excel_cell = ''; echo ""; echo ""; foreach($head as $v){ echo ""; } echo ""; // 逐行取出数据，节约内存 while ($res = mysql_fetch_assoc($query)) { echo ""; echo ""; echo ""; echo""; } echo "

".iconv('utf-8','gb2312',$v)."
".$res['id']."	".iconv('utf-8', 'gb2312', $res['xxx']."

"; }

The above is the entire content of this article, I hope it will be helpful to everyone's study.

Related recommendations:

phpMethod for deleting specified elements from an array

Exception and error parsing in
php

##php
Detailed explanation of the method of sorting arrays in pinyin order

######

The above is the detailed content of Detailed explanation of two methods of exporting excel files natively in php. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：PHP implements two-dimensional array time sortingNext article：PHP implements two-dimensional array time sorting

See more

Detailed explanation of two methods of exporting excel files natively in php

Related articles