4,251
社区成员
发帖
与我相关
我的任务
分享
Apache2.2
php5.2.17
OLE-1.0.0RC2
Spreadsheet_Excel_Writer-0.9.3
require ("../plugin/spreadsheet/Excel/Writer.php");
$file_path=excel_file("".$file_name."_","xls");
$workbook = new Spreadsheet_Excel_Writer($file_path[2]);
$workbook->setCustomColor(20,146,208,80);
$workbook->setVersion(8);
$format_title_sty = & $workbook->addformat(array('Size'=>10,'Bold'=>1,'Border'=>1,'FgColor'=>20,'FontFamily'=>utf82gb("宋体")));
$format_cont_sty = & $workbook->addformat(array('Size'=>10,'Border'=>1,'FontFamily'=>utf82gb("宋体")));
$sheet_rows=40000;//单Sheet记录集个数
$sheet_id=0;
$i=0;
$sheet_i=0;
while($rs= mysqli_fetch_array($rows)){
$i++;
$sheet_i++;
$row_=$i%$sheet_rows;
if($row_==1){
if($row_counts_list<$sheet_rows+1){
$sheet_id="";
}else{
$sheet_id++;
}
$sheets =& $workbook->addWorksheet("".utf82gb($file_name.$sheet_id)."");
for ($f=0;$f<$field_count;$f++){
$sheets->writeString(0, $f,utf82gb($fields[$f]->name), $format_title_sty);
}
$sheet_i=1;
//$sheets->setRow(0,15);
}
for ($k=0;$k<$field_count;$k++){
$sheets->writeString($sheet_i,$k,utf82gb($rs[$k]),$format_cont_sty);
//$sheets->setRow($sheet_i,15);
}
}
$workbook->close();