Updating some data to the same xlsx file using phpexcel.

Topics: Developer Forum, User Forum
Sep 24, 2013 at 11:00 AM
Edited Sep 24, 2013 at 11:05 AM
Hi All,
       I'm facing some issue while updating the same xlsx file with some new data's. The file is created with out any problem, While opening that file I can't able to see all data's which was previously available and after updating its not there. Here is my code
            $objPHPExcelres = PHPExcel_IOFactory::load("test.xlsx");
            $maxCellres = $objPHPExcelres->getActiveSheet()->getHighestRowAndColumn();
            $coln = $maxCellres["column"];
                    $objPHPExcelres->getActiveSheet()->getCell($coln.($ii+2))->setValue("test data");
            $objWriterRes = PHPExcel_IOFactory::createWriter($objPHPExcelres, 'Excel2007');
I'm trying to add an column comments with existing row datas. The above code is working fine with xls extension and not working xlsx extension

If anyone have a solution for this, please update me...