Hi, I'm using phpexcel to copy an xls file to a new csv
the problem I'm having is that my xls file is in hebrew and the new csv file created has some strange chars instead of hebrew letters!
I tried to copy from a csv file instead of an xls
but then I just get empty fields!
my code is this-
$objPHPExcel = new PHPExcel();
$objPHPExcel = PHPExcel_IOFactory::load("myfile.xls");
$sheet = $objPHPExcel->getActiveSheet();
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV')
->save(str_replace('.php', '.csv', __FILE__));
it works great when the file is only in english, no problem there. also I don't have any problems when the output file type is xls.
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', .xls', __FILE__));
I don't think I can use an csv file as an original, it's gonna be an xls saved as csv and when I save
it I get a msg that the file may contain features that are not compatible with CSV.
so I need a solution on how to turn my xls file to csv, but if it's only possible with csv I'd still
like to know the solution since I might get an original csv file somehow.
if someone needs some hebrew words to put in their test files and try and help me here- אבגדהוז