Question

我正在使用Sphpspreadsheet图书馆并测试上载的Excel文档。这些是我的法典

require  vendor/autoload.php ;
use PhpOfficePhpSpreadsheetIOFactory;
use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;

$excel_file = $_FILES[ excelFile ][ tmp_name ];
$reader = PhpOfficePhpSpreadsheetIOFactory::createReaderForFile($excel_file);
$reader->setReadDataOnly(TRUE);
$spreadsheet = $reader->load($excel_file);
$worksheet = $spreadsheet->getActiveSheet();

foreach ($worksheet->getRowIterator() as $row) {
    $cell_values = $row->toArray();
    if (empty($cell_values[0]) || empty($cell_values[1]) || empty($cell_values[2])) {
        $error =  Error: Date, Sample and Isolate columns must not be empty in row   . $row->getRowIndex();
        error_log($error, 3, $log_file);
    }
}

I am seeing this error: Fatal error: Uncaught Error: Call to undefined method PhpOfficePhpSpreadsheetWorksheetRow::toArray() on the line that corresponds to foreach ($worksheet->getRowIterator() as $row) { $cell_values = $row->toArray();

问题是什么? 请帮助我。

Answer 1

答辩太晚......

激光器不能直接进入Array,但能够解决问题,把罗伯茨人和哥伦伊斯特人结合起来。

require  vendor/autoload.php ;
use PhpOfficePhpSpreadsheetIOFactory;
use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;

$excel_file = $_FILES[ excelFile ][ tmp_name ];
$reader = PhpOfficePhpSpreadsheetIOFactory::createReaderForFile($excel_file);
$reader->setReadDataOnly(TRUE);
$spreadsheet = $reader->load($excel_file);
$worksheet = $spreadsheet->getActiveSheet();

foreach ($worksheet->getRowIterator() as $row) {
    $row_idx = $row->getRowIndex();
    foreach($worksheet->getColumnIterator() as $col ){
        $col_idx = $col -> getColumnIndex();
        $cell_value = $worksheet -> getCell($col_idx.$row_idx) -> getValue();
        if (empty($cell_value)) {
            $error =  Error: Date, Sample and Isolate columns must not be empty in row   . $row_idx;
            error_log($error, 3, $log_file);
            continue; //skip the loop
        }
    }
}

友情链接