<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>
<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>