当我使用PhpSpreadsheet保存时，MS Excel 2013数据验证消失

Question

I have two excel files and I need to transfer the data in first file to second file.

I will shred some columns in file first and put them in 4 separate columns in the target file. The data verification feature in the target file is lost when i save the file.

Sorry for my bad English.

$sourceExcel = \PhpOffice\PhpSpreadsheet\IOFactory::load($this->sourceExcelPath);
$targetExcel = \PhpOffice\PhpSpreadsheet\IOFactory::load($this->targetExcelPath);

$sourceExcelRowLength = $sourceExcel->getActiveSheet()->getHighestRow();

for ($i = 1; $i <= $sourceExcelRowLength; $i++) {
    foreach ($this->pairedColumns as $column) { // the first column in the source file is equal to the second column in the target file etc.
        $value = $sourceExcel->getActiveSheet()->getCellByColumnAndRow($column["sourceIndex"], ($this->sourceExcelHeaderStartingIndex + $i))->getValue();
        $targetExcel->getActiveSheet()->setCellValueByColumnAndRow($column["targetIndex"], ($this->targetExcelHeaderStartingIndex + $i), $value);
    }
}

$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($targetExcel, 'Xlsx');
$writer->save($this->sourceExcelPath);

phpspreadsheet version : ^1.6

Screenshoot