excel表格生成

最新推荐文章于 2024-08-12 10:31:29 发布

cidue9389

最新推荐文章于 2024-08-12 10:31:29 发布

阅读量206

点赞数

文章标签： php

原文链接：https://my.oschina.net/u/2310017/blog/484477

版权

require(DT_ROOT.'/include/excel_writer.class.php');

case 'excel';
  //exit("ddddddd");


   //$title= $_POST['title'];
   //exit('ddd :'.$title);
     //$datename="contract_".get_date('YmdHis',PHP_TIME);
     $datename="company_".get_date('His',time());   //下载表名中时间
     $outputFileName = DT_ROOT.'/api/excel/'.$datename.'.xls';   //表名全称
    // EXIT($outputFileName);

         $archive = array();
         $archive[]="<b>客户编号</b>";
   $archive[]="<b>供应商名称</b>";
   $archive[]="<b>联系人</b>";
   $archive[]="<b>手机</b>";
   $archive[]="<b>业务类型</b>";
   $archive[]="<b>来源</b>";
   $archive[]="<b>业务员</b>";

   $archive[]="<b>发布时间</b>";
   $content = array();
   $content[] = $archive;



     //$lists = $do->get_excel();
     //$sql = "SELECT * FROM ts_crm_supplier WHERE itemid>0";
     //print_r($lists);
     //exit("fff");

   $result=$db->query("SELECT * FROM ts_crm_supplier WHERE itemid>0");
   //print_r($result);
       //exit("dddddd");

   while ($row = $db->fetch_array($result)) {
          $archive = array();
    $archive[]=$row['itemid'];
    $archive[]=$row['title'];
    $archive[]=$row['contact'];
    $archive[]=$row['phone'];
    $archive[]=$row['suppliertype'];
    $archive[]=$row['supplierfrom'];
    $archive[]=$row['userid'];
    $archive[]=str_replace("-",".",$row['addtime']);
    $content[] = $archive;
        /*
    echo "<pre>";
  print_r($archive);
  echo "<pre>";
  */

   }


   /* echo "<pre>";
  print_r($content);
  echo "<pre>";
   exit("ddd");*/
  //pritn_r($content);
  //exit("FFFFFF");
$excel = new ExcelWriter($outputFileName);
if($excel==false)
  echo $excel->error;

foreach($content as $v){

  /*echo "<pre>";
  print_r($v);
  echo "<pre>";*/
  $excel->writeLine($v);
}
//exit('ddddddddd');
$excel->sendfile($outputFileName);
//$excel->

  //require_once 'module/crm/excel.php';
  break;

/******************引用文件***********************/

<?php

/*
[Office 515158] (C) 2009-2012 天生创想 Inc.
$Id: excel_writer.php 1209087 2012-01-08 08:58:28Z baiwei.jiang $
*/

Class ExcelWriter
{

var $fp=null;
var $error;
var $state="CLOSED";
var $newRow=false;

/*
* @Params : $file : file name of excel file to be created.
* @Return : On Success Valid File Pointer to file
*    On Failure return false
*/

function ExcelWriter($file="")
{
   return $this->open($file);
}

/*
* @Params : $file : file name of excel file to be created.
*    if you are using file name with directory i.e. test/myFile.xls
*    then the directory must be existed on the system and have permissioned properly
*    to write the file.
* @Return : On Success Valid File Pointer to file
*    On Failure return false
*/
function open($file)
{
   if($this->state!="CLOSED")
   {
    $this->error="Error : Another file is opend .Close it to save the file";
    return false;
   }

   if(!empty($file))
   {
    $this->fp=@fopen($file,"w+");
   }
   else
   {
    $this->error="Usage : New ExcelWriter('fileName')";
    return false;
   }
   if($this->fp==false)
   {
    $this->error="Error: Unable to open/create File.You may not have permmsion to write the file.";
    return false;
   }
   $this->state="OPENED";
   fwrite($this->fp,$this->GetHeader($file));
   return $this->fp;
}
function sendfile($filename){
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=".$filename);
readfile($filename);
exit();
}
/* @Params : Void
* @return : Void
* This function write the header of Excel file.
*/

function GetHeader($file)
{
   $header = <<<EOH
    <html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/html4/loose.dtd">
    <head>
    <meta http-equiv=Content-Type content="text/html; charset=utf-8">
    <meta name=ProgId content=Excel.Sheet>
    
    <style>
    
    </style>
    
    </head>
    <body link=blue vlink=purple>
    <table x:str border=0 cellpadding=0 cellspacing=0 style='border-collapse: collapse;table-layout:fixed;'>
EOH;

   return $header;
}
function GetFooter()
{
   return "</table></body></html>";
}

/*
* @Params : $line_arr: An valid array
* @Return : Void
*/

function writeLine($line_arr)
{
   if($this->state!="OPENED")
   {
    $this->error="Error : Please open the file.";
    return false;
   }
   if(!is_array($line_arr))
   {
    $this->error="Error : Argument is not valid. Supply an valid Array.";
    return false;
   }
   fwrite($this->fp,"<tr>");
   foreach($line_arr as $col)
    fwrite($this->fp,"<td class=xl24 width=64 x:num>$col</td>");
   fwrite($this->fp,"</tr>");
}
/*
* @Params : Void
* @Return : Void
*/
function writeRow()
{
   if($this->state!="OPENED")
   {
    $this->error="Error : Please open the file.";
    return false;
   }
   if($this->newRow==false)
    fwrite($this->fp,"<tr>");
   else
    fwrite($this->fp,"</tr><tr>");
   $this->newRow=true;
}
/*
* @Params : $value : Coloumn Value
* @Return : Void
*/
function writeCol($value)
{
   if($this->state!="OPENED")
   {
    $this->error="Error : Please open the file.";
    return false;
   }
   fwrite($this->fp,"<td class=xl24 width=64 >$value</td>");
}
/*
* @Params : Void
* @Return : Void
*/
function writeSingleRow($value)
{
   if($this->state!="OPENED")
   {
    $this->error="Error : Please open the file.";
    return false;
   }
   if($this->newRow==false)
    fwrite($this->fp,"<tr><td>".$value."</td></tr>");
}
}
?>

转载于:https://my.oschina.net/u/2310017/blog/484477

cidue9389

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
excel表格生成

require(DT_ROOT.'/include/excel_writer.class.php'); case 'excel';//exit("ddddddd"); //$title= $_POST['title']; //exit('ddd :'.$title)...
复制链接

扫一扫