这样导出是只有第一行有值,但如果我把第一个红框里的代码删了,第二,三,四...行就有值了。
第一行的值是标题,如性别,年龄等。
第二,三,四...行是对应的性别,年龄等的值。
求帮忙,,,十万火急。。。
回复讨论(解决方案)
图太小,看不清
你就不能贴代码吗?
for($m_k=0,$column_num0='A';$m_k<$column_max,$column_num0<'ZZ';$column_num0++,$m_k++) { //$objectPHPExcel->getActiveSheet()->getColumnDimension($column_num0)->setWidth(10); //$objectPHPExcel->setActiveSheetIndex(0)->setCellValue($column_num0.'1',$m_arr[$m_k]); //$objectPHPExcel->getActiveSheet()->getStyle((string)($column_num0.'1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); } for($key_num=0;$key_num<$row_max;$key_num++) { $row_num=$key_num+2; //数组的索引是行号-2 $avar_arr=array_filter(explode('|',$data[$key_num]['avar'])); $answer_arr=array_filter(explode('|',$data[$key_num]['aanswer'])); $d_arr=array_combine($avar_arr,$answer_arr); foreach($d_arr as $k=>$v) { foreach($m_arr as $k1=>$v1) { if(!isset($d_arr[$v1])) { $d_arr[$v1]=' '; } } } ksort($d_arr); $d_arr=array_values($d_arr); for($column_num='A',$column_num2=1;$column_num<'ZZ',$column_num2<301;$column_num++,$column_num2++) { foreach($d_arr as $k=>$v) { if($k==($column_num2-1)) { $objectPHPExcel->getActiveSheet()->setCellValue($column_num.$row_num,$v); $objectPHPExcel->getActiveSheet()->getStyle((string)($column_num.$row_num))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); } } } } header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.date('Ymd-His').'.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objectPHPExcel, 'Excel5'); $objWriter->save('php://output');
@
图太小,看不清
你就不能贴代码吗?
版主```那三行是我测试时候注释掉的,,帮忙看看,,
图太小,看不清
你就不能贴代码吗?
第一个for循环是设置第一行的值
第二个for循环是设置第二,三,四...行的值
这样导出只有第一行是有值的,第二,三,四...行没有值。
如果注释掉第一个for循环,第二,三,四...行就有值了。
该怎么解决呢?

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
