I'm looking for a simple code to take a file with ending XLS and resave it as xlsx type.
I don't want to get a new file, or open excel. just save as.. and give it a different type.
that's what I tried so far but it's creating a new file and the data is all messed up in it, everything is shifted into 1 column..
$objPHPExcel = new PHPExcel();
$objPHPExcel = PHPExcel_IOFactory::load("myfile.XLS");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('XLSchange.php', 'myfile.xlsx', __FILE__));
PHPExcel version 1.7.6, 2011-02-27