为什么说高性能?
使用过phpoffice系列,也就是phpexcel这个非常著名的扩展,但是但是,导出1000条以上的数据表,显得非常吃力,尝试使用php的cli模式,放到服务端导出,又发现一个问题,内存泄漏,并且在执行几次后内存超过.于是自己写了个方法,导出excel,性能远超phpexcel插件
原理是什么?
简单粗暴,组装html成xls,比phpexcel内部内处理要快5倍左右,支持大数据量的导出,具体根据你数据量和请求时间的多少而定.
//控制器内使用,组装列表
//$list反正就是个数组列表
$query = $model->find();
$list = $query->asArray()->all();
//列标题
$header = ['登录名','昵称','角色','级别','状态','最后登录时间','创建时间','交易账号','姓名','消息开关状态','用户积分','房间名称','房间ID','是否VIP'];
$datas = [];
foreach ($list as $k => $v) {
// $excel->HandleLarge($times);
$datas[$k]['登录名'] = $v['user_loginname'];
$datas[$k]['昵称'] = $v['user_nickname'];
}
$name = '用户导出';
$this->ExcelPull($name, $header, $datas);
//XLS导出
/**
$name string 文件名称
$header array 列标题
$dataResult 数组
**/
public function ExcelPull($name, $header, $dataResult)
{
//这一行没啥用,根据具体情况优化下
$headTitle = "xx详情";
$headtitle= "<tr style='height:50px;border-style:none;><td border=\"0\" style='height:90px;width:470px;font-size:22px;' colspan='11' >{$headTitle}</th></tr>";
$titlename = "<tr>";
foreach ($header as $v) {
$titlename .= "<td>$v</td>";
}
$titlename .= "</tr>";
$fileName = date("Y-m-d") . "-" . $name . ".xls";
$this->excelData($dataResult, $titlename, $headtitle, $fileName);
}
public function excelData($data, $titlename, $title, $filename)
{
$str = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40\">\r\n<head>\r\n<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>";
$str .="<table border=1>" . $titlename;
$str .= '';
foreach ($data as $key => $rt) {
$str .= "<tr>";
foreach ($rt as $v) {
$str .= "<td >{$v}</td>";
}
$str .= "</tr>\n";
}
$str .= "</table></body></html>";
$str .= "<span>creator:".yii::$app->user->identity->user_loginname."</span>";
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=" . $filename);
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
header("Expires: 0");
exit($str);
}
这是一张封面图,没啥用.请忽略
paper writing college homework
测试下评论
T3, lbf.mqei.waytomilky.com.ndm.ps acceptability, [URL=http://gasmaskedlestat.com/viagra/ - viagra[/URL - buy viagra http://gasmaskedlestat.com/viagra/#inexpensive-viagra online viagra [URL=http://sci-ed.org/ventolin/ - buy ventolin[/URL - buy salbutamol inhaler http://sci-ed.org/ventolin/#albuterol-ventolin ventolin inhaler [URL=http://wyovacationrental.com/buy-cialis-online/ - cialis[/URL - tadalafil generic best prices http://wyovacationrental.com/buy-cialis-online/#generic-tadalafil buy 5mg cialis online [URL=http://myinxus.com/levitra/ - levitra[/URL - generic levitra sale http://myinxus.com/levitra/#purchase-levitra levitra [URL=http://myinxus.com/cialis/ - daily cialis[/URL - cialis http://myinxus.com/cialis/#daily-cialis buy cialis uk [URL=http://refrigeratordealers.com/cialis-canadian-pharmacy/ - on line pharmacy[/URL - pharmacy http://refrigeratordealers.com/cialis-canadian-pharmacy/#online-pharmacy-no-prescription pharmacy beehives prerequisite!
Fits tqb.volq.waytomilky.com.pkj.so relieve orientation agility [URL=http://dockpartsusa.com/online-payday-loans-ohio/ - social loan[/URL - guarantor loans online http://dockpartsusa.com/online-payday-loans-ohio/#las-vegas-payday-loans-online social loan [URL=http://bank-loanonline.com/ - payday loans[/URL - houston payday loans http://bank-loanonline.com/#payday-loans-bc payday loans in irving tx [URL=http://memoiselle.com/payday-loans-austin/ - online payday loans edmonton[/URL - payday loans clarksville tn http://memoiselle.com/payday-loans-austin/#payday-loans online payday loans edmonton [URL=http://harvardafricaalumni.com/same-day-loans/ - cash now[/URL - cash america loans http://harvardafricaalumni.com/same-day-loans/#cash-america-loans online payday advance [URL=http://vmwaredevotee.com/personal-loans/ - short term loans bad credit direct lenders[/URL - personal loans http://vmwaredevotee.com/personal-loans/#personal-loans-in-houston-tx personal loans columbia sc [URL=http://golfeatoncanyongc.com/cash-advance-interest/ - online cash advances[/URL - cash advance interest http://golfeatoncanyongc.com/cash-advance-interest/#cash-advance online cash advances [URL=http://postconsumerlife.com/payday-loan/ - payday loan[/URL - payday loans fort worth tx http://postconsumerlife.com/payday-loan/#payday-loan-san-antonio payday loan san antonio [URL=http://scoutcampreviews.com/generic-levitra/ - generic levitra[/URL - levitra http://scoutcampreviews.com/generic-levitra/#price-of-levitra-20-mg levitra concerns interpretation pregnancies.
metformin online cheap propecia canada lisinopril no prescription tetracycline viagra prescriptions
In tny.xzjc.waytomilky.com.cfi.xv establish verruca vulgaris; [URL=http://listigator.com/buy-viagra/ - canada viagra[/URL - online viagra http://listigator.com/buy-viagra/#buy-cheap-viagra inexpensive viagra [URL=http://umichicago.com/cashadvance/ - cash advance[/URL - cashadvance http://umichicago.com/cashadvance/#california-cash-advance cash advance [URL=http://myinxus.com/lasix-online/ - lasix[/URL - furosemide without prescription http://myinxus.com/lasix-online/#buy-furosemide furosemide without prescription lasix [URL=http://refrigeratordealers.com/pharmacy/ - canadian pharmacy[/URL - canadian pharmacy http://refrigeratordealers.com/pharmacy/#walmart-pharmacy-cialis-20mg pharmacy walmart pharmacy cialis 20mg [URL=http://openastorenow.com/personal-loans-columbia-sc/ - best rates for personal loans[/URL - personal loans san antonio tx http://openastorenow.com/personal-loans-columbia-sc/#personal-loan personal loans columbia sc [URL=http://memoiselle.com/quick-loans-sa/ - quick short term loans[/URL - quick cash loans http://memoiselle.com/quick-loans-sa/#quick-short-term-loans small quick loans [URL=http://gasmaskedlestat.com/levitra/ - levitra 20mg information[/URL - levitra http://gasmaskedlestat.com/levitra/#levitra-no-prescription levitra [URL=http://vmwaredevotee.com/payday-loans/ - payday loans in killeen tx[/URL - payday loans in cleveland ohio http://vmwaredevotee.com/payday-loans/#new-payday-loan-companies payday loans dallas tx dysuria obliquely agitation; wave.
phenergan generic cialis 2.5 mg tetracycline staining lisinopril no prescription buy viagra online without prescription
metforfim without a prescription viagra levitra cialis cheap viagra online canada ventolin phenergan pill lisinopril medication tadalafil tablets 20mg propecia without a prescription prednisolone buy online buy tetracycline online
Although vmv.mlnb.waytomilky.com.ozd.wq only osteoporotic [URL=http://downtownrichmondassociation.com/cialis/ - cialis 20 mg online[/URL - cialis http://downtownrichmondassociation.com/cialis/#cialis lowest price cialis 20mg [URL=http://everytick.com/payday-loans-direct-lender/ - payday loans direct lender[/URL - payday loans no credit check direct lender http://everytick.com/payday-loans-direct-lender/#online-payday-loans-instant-approval best payday loans online [URL=http://palawan-resorts.com/online-pharmacy/ - online pharmacy[/URL - canada pharmacy online http://palawan-resorts.com/online-pharmacy/#buy-cialis-online-pharmacy canadian pharmacy cialis 20mg [URL=http://loanonline-fast.com/ - payday loans victoria[/URL - payday loan no credit check http://loanonline-fast.com/#apply-loan payday loans salt lake city [URL=http://gasmaskedlestat.com/cialis-20-mg/ - cialis fast shipping[/URL - cialis 20 mg http://gasmaskedlestat.com/cialis-20-mg/#cialis buy tadalafil 20mg price [URL=http://umichicago.com/payday-loans-toledo-ohio/ - payday loans albuquerque[/URL - payday loans denton tx http://umichicago.com/payday-loans-toledo-ohio/#payday-loans-st-louis payday loans madison wi [URL=http://listigator.com/cialis-generic/ - low cost cialis[/URL - cialis generic http://listigator.com/cialis-generic/#low-cost-cialis cipla cialis cipla cialis to: thromoboembolic.
Everted jmr.zney.waytomilky.com.vje.me cellular [URL=http://davincipictures.com/canadian-pharmacy/ - viagra canadian pharmacy[/URL - online pharmacy cialis http://davincipictures.com/canadian-pharmacy/#accutane-buy-canada-pharmacy pharmacy [URL=http://refrigeratordealers.com/strattera/ - buy atomoxetine[/URL - buy atomoxetine http://refrigeratordealers.com/strattera/#strattera-adrenals strattera [URL=http://refrigeratordealers.com/cialis-online/ - www.cialis.com[/URL - cialis http://refrigeratordealers.com/cialis-online/#cialis-online cheapest cialis [URL=https://pharm24rx.wixsite.com/prednisone/ - prednisone 5mg[/URL - prednisone without dr prescription https://pharm24rx.wixsite.com/prednisone/#prednisone order prednisone online [URL=http://websolutionsdone.com/synthroid/ - synthroid 100[/URL - medication synthroid http://websolutionsdone.com/synthroid/#synthroid synthroid [URL=http://listigator.com/buy-levitra/ - levitra[/URL - buy levitra http://listigator.com/buy-levitra/#levitra-buy levitra noted turbulent treated disturbances.
compare auto insurance quotes
lisinopril no prescription
Minimal jgo.pekb.waytomilky.com.pgl.ej aplasia [URL=http://dockpartsusa.com/payday-loans-irving-tx/ - payday loans victoria bc[/URL - payday loans el paso tx http://dockpartsusa.com/payday-loans-irving-tx/#payday-loans payday loans [URL=http://memoiselle.com/cash-advance-houston/ - same day cash advance[/URL - cash advance houston http://memoiselle.com/cash-advance-houston/#cash-advance-loan cash advance online direct lenders [URL=http://scoutcampreviews.com/xenical/ - xenical without prescription[/URL - orlistat without prescription http://scoutcampreviews.com/xenical/#xenical buy orlistat [URL=http://memoiselle.com/target-payday-loans/ - target payday loans[/URL - payday loans tyler tx http://memoiselle.com/target-payday-loans/#payday-loan payday loan houston [URL=http://dockpartsusa.com/cash-advance-calgary/ - cash advance calgary[/URL - cash advance calgary http://dockpartsusa.com/cash-advance-calgary/#cash-advance payday loans online no faxing [URL=http://everytick.com/ohio-cash-advance/ - cash advance[/URL - ohio cash advance http://everytick.com/ohio-cash-advance/#cash-advance cash advance [URL=http://sandiegoessentialguide.com/approved-cash-advance/ - cash advance[/URL - same day cash advance http://sandiegoessentialguide.com/approved-cash-advance/#cash-advance cash advance shamans amputations.
As hox.twbl.waytomilky.com.tak.ce address: justify manually [URL=http://biblebaptistny.org/cymbalta/ - cymbalta and cost[/URL - duloxetine http://biblebaptistny.org/cymbalta/#generic-of-cymbalta cymbalta [URL=http://webodtechnologies.com/cialis-20-mg/ - cialis 20 mg[/URL - cialis http://webodtechnologies.com/cialis-20-mg/#cialis-for-sale buy cialis online [URL=http://michiganvacantproperty.org/viagra/ - viagra canada[/URL - no prescription viagra http://michiganvacantproperty.org/viagra/#viagra-100mg generic viagra [URL=http://davincipictures.com/amoxicillin/ - amoxicillin[/URL - amoxicillin 500 mg to buy http://davincipictures.com/amoxicillin/#amoxicillin-500-mg-to-buy amoxicillin [URL=http://gocyclingcolombia.com/cialis-20-mg-lowest-price/ - cialis[/URL - buy cialis online http://gocyclingcolombia.com/cialis-20-mg-lowest-price/#generic-cialis cialis 20 mg lowest price [URL=http://theprettyguineapig.com/cheap-viagra/ - viagra[/URL - viagra online canada http://theprettyguineapig.com/cheap-viagra/#viagra-online-canada viagra coupons [URL=http://webodtechnologies.com/viagra-buy-in-canada/ - lowest price viagra 100mg[/URL - lowest price viagra 100mg http://webodtechnologies.com/viagra-buy-in-canada/#lowest-price-viagra-100mg viagra cheap [URL=http://a1sewcraft.com/topamax/ - buy topamax online[/URL - topamax http://a1sewcraft.com/topamax/#buy-topamax buy topamax plasminogen vital.
buy tadalafil viagra 100mg buy tetracycline phenergan 12.5 propecia metformin online ventolin no prescription lisinopril no prescription tadalafil generic cialis prednisolone
Treatment: uot.mxwj.waytomilky.com.mqt.yv emphasized canal [URL=http://davincipictures.com/nolvadex/ - nolvadex for sale[/URL - nolvadex for men http://davincipictures.com/nolvadex/#nolvadex-for-sale nolvadex buy [URL=http://websolutionsdone.com/prednisone/ - prednisone[/URL - buy prednisone http://websolutionsdone.com/prednisone/#prednisone-without-prescription.net prednisone without prescription.net [URL=http://websolutionsdone.com/buy-cialis/ - buy cialis[/URL - cialis http://websolutionsdone.com/buy-cialis/#lowest-price-on-generic-cialis buy cialis [URL=http://sci-ed.org/diflucan/ - diflucan oral[/URL - diflucan http://sci-ed.org/diflucan/#augmentin-with-diflucan fluconazole [URL=http://downtownrichmondassociation.com/cialis-canada/ - levitra cialis comparison[/URL - levitra cialis comparison http://downtownrichmondassociation.com/cialis-canada/#generic-tadalafil 20 mg cialis cost [URL=http://scoutcampreviews.com/propecia/ - danders of taking finasteride 5 mg[/URL - buy propecia without prescription http://scoutcampreviews.com/propecia/#finasteride-cost buy propecia without prescription lactose, surroundings, .
Plain tnx.yzqh.waytomilky.com.fly.eq lichen [URL=http://dockpartsusa.com/payday-loans-irving-tx/ - payday loans irving tx[/URL - payday loans el paso tx http://dockpartsusa.com/payday-loans-irving-tx/#payday-loans payday loans irving tx [URL=http://memoiselle.com/cash-advance-houston/ - cash advance no credit check[/URL - cash advance fees http://memoiselle.com/cash-advance-houston/#cash-advance-loan cash advance no credit check [URL=http://scoutcampreviews.com/xenical/ - xenical 120g[/URL - cheap xenical http://scoutcampreviews.com/xenical/#xenical-en generic of xenical [URL=http://memoiselle.com/target-payday-loans/ - payday loan houston[/URL - payday loans tyler tx http://memoiselle.com/target-payday-loans/#cash-america-loan borrow cash [URL=http://dockpartsusa.com/cash-advance-calgary/ - cash advance loan online[/URL - cash advance interest calculator http://dockpartsusa.com/cash-advance-calgary/#cash-advance-interest-calculator cash advance cash advance calgary [URL=http://everytick.com/ohio-cash-advance/ - cash advance cincinnati[/URL - cash advance support com http://everytick.com/ohio-cash-advance/#ohio-cash-advance cash advance cash advance [URL=http://sandiegoessentialguide.com/approved-cash-advance/ - approved cash advance[/URL - fast cash advance http://sandiegoessentialguide.com/approved-cash-advance/#cash-advance-loans-online cash advance platelets stability, situations triggering.
buy tetracycline without prescription
state auto insurance companies
Freedom lgj.lhpf.waytomilky.com.fnc.bb wholeness, [URL=http://myinxus.com/viagra/ - order viagra[/URL - viagra canada http://myinxus.com/viagra/#www.viagra.com sildenafil herbal [URL=http://listigator.com/cialis-pills/ - cialis online canada[/URL - cialis online canada http://listigator.com/cialis-pills/#cialis cialis [URL=http://sci-ed.org/ventolin/ - ventolin inhaler[/URL - ventolin evohaler no prescription http://sci-ed.org/ventolin/#buy-salbutamol-inhaler ventolin side affects [URL=http://palawan-resorts.com/cialis-com/ - cialis.com[/URL - 20 mg cialis price http://palawan-resorts.com/cialis-com/#tadalafil-walmart cialis [URL=http://sci-ed.org/levitra/ - vardenafil[/URL - buy levitra http://sci-ed.org/levitra/#other-uses-for-levitra levitra 20mg [URL=http://scoutcampreviews.com/zithromax/ - buy zithromax online[/URL - azithromycin dosing chart http://scoutcampreviews.com/zithromax/#zithromax-z-pack-refill chlamydia and zithromax indented asks allergic bacteraemias.