PHPExcel在编辑现有Excel工作表后删除Excel工作表的数据验证选项

I am using PHPExcel for editing existing excel sheets.

I had already set up a Data Validation method in my excel sheet as below.

When i edit this excel using PHPExcel, this Excel Specific Data Validation vanishes.

Can anyone help me to overcome this issue. I need to edit the excel without changing its functionality.

My PHP code:

 //load existing template..
$objPHPExcel = PHPExcel_IOFactory::load('www/PHPExcelReader/Excel_Uploads/sample.xls');

// Set document properties
$objPHPExcel->getProperties()->setCreator("Logic Item")
                             ->setLastModifiedBy("Logic")
                             ->setTitle("List");
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('AZ1', $combination);

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$file_name='sample.xls';
$objWriter->save($file_name);
echo "Excel is ready to download now...";

From spreadsheet files that I've just created with data validation on cell A1 applying values from a list in $G1:$G4 and the following code:

$inputFileType = 'Excel5';
$inputFileName = './15datavalidationUnpopulated.xls';
$outputFileType = 'Excel5';
$outputFileName = './15datavalidationPopulated.xls';

$objPHPExcelReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objPHPExcelReader->load($inputFileName);

$objPHPExcel->getActiveSheet()->setCellValue('G1', "India")
                              ->setCellValue('G2', "America")
                              ->setCellValue('G3', "China")
                              ->setCellValue('G4', "Russia");

$objPHPExcelWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,$outputFileType);
$objPHPExcel = $objPHPExcelWriter->save($outputFileName);

works with both .xls and .xlsx files, showing India, America, China and Russia in the data validation dropdown list for cell A1