Problem with hebrew in CSV

Topics: Developer Forum, Project Management Forum, User Forum
Sep 3, 2011 at 2:35 PM

Hi, I'm using phpexcel to copy an xls file to a new csv file.

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!

screen cap-

my code is this-

require_once 'Classes/PHPExcel.php';
$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- אבגדהוז
thank you.