//设置为文本格式
$objActSheet = $spreadsheet->getActiveSheet();
$column = 2;
$num=1;//序号重置
// var_dump($data);
$dataNum = count($data);
$perSize = 1000;
$pages = ceil($dataNum / $perSize);
for($i = 1; $i <= $pages; $i++){
foreach($data as $key => $rows){ //行写入
$span = 1;
foreach($rows as $keyName=>$value){// 列写入
$j = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($span);
if($keyName=="id")$value=$num;
$objActSheet->setCellValueExplicit($j.$column, $value, \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING);
$span++;
}
$column++;
$num++;
$ecost_total += $rows['ecost'];
$tecost_total += $rows['tecost'];
$wcost_total += $rows['wcost'];
$twcost_total += $rows['twcost'];
}
$spreadsheet->disconnectWorksheets();
unset($spreadsheet);
}