excel的实际限制是1048576。 如果行达到该级别，则必须转到下一个工作表。 有什么建议

Question

Here is my code

$output = $filename.".xls";
$output = "../downloads/".$filename.".csv";
$output_zip = "../downloads/".$filename.".zip";
$fp = fopen($output, 'w');
$sheet = $objPHPExcel->getActiveSheet();
if ($fp==false) echo "Failed to pen file stream";
$myArr = array();
while ($finfo = mysqli_fetch_field($res)) {
    $myArr[]=$finfo->name;
}   
fputcsv($fp,$myArr);
$my_i=1;
while ($row = mysqli_fetch_row( $res )) {
    $myArr = array();
    foreach($row as $key=>$value) {
        $myArr[]=$value; 
    }
    fputcsv($fp,$myArr); $my_i++;
}                                
fclose( $fp );

Answer 1

A CSV or a text file can have many more rows than the Excel sheet limit.

If you want to bring that data into Excel, you can use Power Query to connect to a CSV file and make it available for processing in the spreadsheet. Power Query can also connect to many other data sources, any of which can return way more than the Excel row limit.

You may want to use 64 bit Office for projects that involve a lot of data.

Power Query is a free download for Excel 2010 and 2013. In Excel 2016 for Windows, it is integrated into the Data ribbon.