I have a problem in PhpExcel and PhpSpreadsheet.
the problem is : When I load my excel(xlsx) with data validation in template excel, and i load and modified, the data validation is gone,
require('../excel/vendor/autoload.php');
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Csv;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
use PhpOffice\PhpSpreadsheet\Reader\Xls;
$location = '../tes/tes.xlsx';
$spreadsheet = PhpOffice\PhpSpreadsheet\IOFactory::load($location);
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(3);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Error !!!');
$objPHPExcel->getActiveSheet()->setTitle('Error Log');
$writer = PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, "Xlsx");
$writer->save("../tes/after_tes.xlsx");
i used Phpexcel and try to phpSpreadSheet but result its same, data vlidation still gone :(