phptoexcel.xlsx

<meta http-equiv="content-type" content="text/html; charset=utf-8">

 <title>对excel的测试实例_1</title>

 <?php
set_time_limit(0);
session_start();
if(!isset($_SESSION['page1'])){
$_SESSION['page1']=0;  
}
 error_reporting(E_ALL);

 

 //设置时区

 date_default_timezone_set('Asia/Shanghai');

 

 require_once 'PHPExcel.php';

 

 echo '当前时间：'.date('Y-m-d H-i-s');

 

 //创建excel操作对象

 $objPHPExcel = new PHPExcel();

 

 $objPHPExcel->getProperties()->setCreator("Meteoric_cry")

                              ->setLastModifiedBy("Meteoric002")

                              ->setTitle("Php_excel_demo1")

                              ->setSubject("主题1")

                              ->setDescription("随便一个描述了")

                              ->setKeywords("关键字 用空格分开")

                              ->setCategory("分类 ");
/*
 $nam= iconv("utf-8","gb2312","姓名");
 $pho= iconv("utf-8","gb2312","电话");
 $tim= iconv("utf-8","gb2312","入网时间");
 $sch= iconv("utf-8","gb2312","所属学校");
 $cla= iconv("utf-8","gb2312","所属班级");
 $cou= iconv("utf-8","gb2312","登录次数");
 $act= iconv("utf-8","gb2312","角色");
 $are= iconv("utf-8","gb2312","区局");
 
  */
 

 //激活第一个选项， 然后填充数据

 $objPHPExcel->setActiveSheetIndex(0)
             ->setCellValue('A1', "姓名")
             ->setCellValue('B1', "电话")
             ->setCellValue('C1', "入网时间")
             ->setCellValue('D1', "所属学校")
             ->setCellValue('E1', "所属班级")
             ->setCellValue('F1', "登录次数")
             ->setCellValue('G1', "角色")
             ->setCellValue('H1', "区局");
            
$DB_Server = "";        
$DB_Username = "";
$DB_Password = "";
$DB_DBName = "jxt";
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
or die("Couldn@#t connect.");
$Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn@#t select database.");
$sql =$_SESSION["sql"]." limit ".$_SESSION['page1']."5000";
$ALT_Db = @mysql_select_db($DB_DBName, $Connect)
or die("Couldn@#t select database");
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
$result = @mysql_query($sql,$Connect)
or die(mysql_error());
 
$i = 2;
while($row = mysql_fetch_row($result))
{

for($j=0; $j<mysql_num_fields($result);$j++)
{

switch($j)
{
case 0:$l="A";break;
case 1:$l="B";break;
case 2:$l="C";break;
case 3:$l="D";break;
case 4:$l="D";break;
case 5:$l="F";break;
case 6:$l="G";break;
case 7:$l="H";break;
}
//$row1=iconv("utf-8","gb2312",$row[$j]);
$objPHPExcel->setActiveSheetIndex(0)
             ->setCellValue($l.$i,$row[$j]);
            // echo '.$j+1.</div>';
}

$i++;
}
 
//$result = mysql_query($sql1);
/*$i=1;
while($row = mysql_fetch_array($result))
{

 $nam1= iconv("utf-8","gb2312",$row['姓名'];
 $pho1= iconv("utf-8","gb2312",$row['电话'];
 $tim1= iconv("utf-8","gb2312",$row['入网时间'];
 $sch1= iconv("utf-8","gb2312",$row['所属学校'];
 $cla1= iconv("utf-8","gb2312",$row['所属班级'];
 $cou1= iconv("utf-8","gb2312",$row['登录次数'];
 $act1= iconv("utf-8","gb2312",$row['角色'];
 $are1= iconv("utf-8","gb2312",$row['区局'];
 
      $objPHPExcel->setActiveSheetIndex(0)
             ->setCellValue('A'.$i, $nam1)
             ->setCellValue('B'.$i, $pho1)
             ->setCellValue('C'.$i, $tim1)
             ->setCellValue('D'.$i, $sch1)
             ->setCellValue('E'.$i, $cla1)
             ->setCellValue('F'.$i, $cou1)
             ->setCellValue('G'.$i, $act1)
             ->setCellValue('H'.$i, $are1);
$i++;

}*/

 

 

 //对第一个选项进行重命名            

 $objPHPExcel->getActiveSheet()->setTitle('重新命令');

 

 

 $objPHPExcel->setActiveSheetIndex(0);

 

 //写操作

 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

 $objWriter->save(str_replace('.php', '.xlsx', date('Y-m-d H-i-s').'.xlsx'));

 

 echo "<br/>消耗的内存为：".memory_get_peak_usage(true) / 1024 / 1024;

 echo '<div>文件名：'.date('Y-m-d H-i-s').'.xlsx'.'</div>';

 echo '<div>php编译的行数：'.__LINE__.'</div>';

 //echo '<div>php的类名：'.__CLASS__.'</div>';
   echo '<div>每次最多导出5000条数据'.__CLASS__.'</div>';
$_SESSION['page1']=$_SESSION['page1']+5000;
 ?>
 <a href="0.php">继续导出excel</a>