php generate excel file_PHP tutorial

php generate excel file This article collects three PHP code programs for generating excel files. The first one is a relatively comprehensive generation function. The next two are very simple, but not as good as the first one. Now let’s take a look at the principle of generating excel.

php tutorial to generate excel file
This article collects three PHP code programs for generating excel files. The first one is a relatively comprehensive generation function. The next two are very simple, but not as good as the first one. Now let’s take a look at the principle of generating excel.
*/

class excel{ 


var $header = "
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/tr/rec-html40">";

var $footer = "";
var $lines = array ();
var $worksheet_title = "table1";
 
Function addrow ($array) {


         $cells = "";                                                                                                            
foreach ($array as $k => $v):
                                                                                                                              // Add a judgment between strings and numbers to avoid warnings that numbers are stored in strings in the generated excel
If(is_numeric($v)) {
// Prevent 0 loss after the first letter is 0
If(substr($v, 0, 1) == 0) {
                             $cells .= "" . $v . "n"; 
                                                                                                                           $cells .= "" . $v . "n"; 
                                                                                                                                                                                                                       $cells .= "" . $v . "n";                                                                           
Endforeach;

// transform $cells content into one row
          $this->lines[] = "n" . $cells . "n";                                                       
}  
                     
function addarray ($array) {

                 // run through the array and add them into rows                                                                   foreach ($array as $k => $v):
                      $this->addrow ($v);                                                           Endforeach;

}  
 
Function setworksheettitle ($title) {

// strip out special chars first
         $title = preg_replace ("/[|:|/|?|*|[|]]/", "", $title);                                
               // now cut it to the allowed length                                                                       $title = substr ($title, 0, 31);                                    
// set title
            $this->worksheet_title = $title;                                                      
}  

function generatexml ($filename) {


            header("content-type: application/vnd.ms-excel; charset=utf-8");                                         header("content-disposition: inline; filename="" . $filename . ".xls"");

echo strips tutorial lashes ($this->header);
echo "nworksheet_title . "">n

n";
echo "n";
echo implode ("n", $this->lines);
echo "nn";
echo $this->footer;

}  

} 


/**
* Non-framework usage
*
* require_once('excel.php');
* $doc = array (
*     0 => array ('China', 'Chinese people', 'Chinese people', '123456");
* );
* $xls = new excel;
* $xls->addarray ( $doc );
* $xls->generatexml ("mytest");
*/

?>

Method 2
In fact, when making real applications, you can take the data out of the database tutorial, and then echo it out by adding t at the end of each column of data and n at the end of each row of data. Use header("content at the beginning of php -type:application/vnd.ms-excel"); indicates that the output is an excel file. Use header("content-disposition:filename=test.xls"); to indicate that the output file name is text.xls. That's OK.

header("content-type:application/vnd.ms-excel");

header("content-disposition:filename=test.xls");

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

echo "test1";

echo "test2";

?>

Method 3

header("content-type: application/octet-stream"); ​​
header("accept-ranges: bytes");
header("content-type:application/vnd.ms-excel");
header("content-disposition:attachment;filename=export_excel_gshjsl.xls");

$tx='header';
echo $tx."nn";
echo "number"."t";
echo "Name"."t";
echo "n";

echo "="411481198507150666""."t";
echo "="0123456""."t";
echo "n";
?>

http://www.bkjia.com/PHPjc/630801.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630801.htmlTechArticlephp generates excel files. This article collects three php code programs for generating excel files. The first one is more comprehensive. Generating functions, the latter two are very simple, but not as good as the first one, now...