Exporting CSV file with hebrew

[Ori Idan]

I have tested google docs with the same file translated using iconv to UTF-8
and it works great.
I still have a problem with excel, my customer claims he can not see the
hebrew in the file.
Does someone on this list has access to Excel and can tell me how to tell
excel the right encoding so it can import the hebrew?
I myself don't have access to Exccel and thus can not test it.
I can send a sample file.

-- 
Ori Idan


On Sat, Jul 31, 2010 at 12:47 AM, Omer Zak <w1 at zak.co.il> wrote:

> On Sat, 2010-07-31 at 00:20 +0300, Ori Idan wrote:
> >
> >
> > On Sat, Jul 31, 2010 at 12:17 AM, Omer Zak <w1 at zak.co.il> wrote:
> >         My experience is limited to whatever my CPA is using (I think
> >         he uses
> >         Excel).  By experimenting with utf-8, cp862, iso_8859-8 and
> >         windows-1255
> >         encodings, we found that windows-1255 worked for him.
> >
> >         If you find that Google Docs and Excel have contradictory
> >         expectations,
> >         then I suggest that you allow people to export the CSV file in
> >         either
> >         "Google Docs compatible" encoding or "Excel compatible"
> >         encoding.
> >
> > What is google docs compatible format?
>
> By trial, I found that utf-8 is the Google Docs compatible encoding:
> 1. Create in Google Docs a spreadsheet with Hebrew text.
> 2. Export it in CSV format to a file in your PC.
> 3. Open the file in gedit and modify some cells.
> 4. Import the file into Google Docs and demonstrate that it displays
> correctly the modified values.
> 5. By means of xxd -g 1 (or other means), confirm that the file is in
> utf-8 encoding.
>
> By the way, I expect Excel to be configurable to accept also other
> encodings - but you'll have to find how to do it, and to write clear
> instructions for the users.
>
> --- Omer
>
>
> --
> Bottom posters are filthy heretics and infidels and ought to be burned
> on the stake after having been tarred, feathered and having rotten eggs
> thrown at their faces!
> My own blog is at http://www.zak.co.il/tddpirate/
>
> My opinions, as expressed in this E-mail message, are mine alone.
> They do not represent the official policy of any organization with which
> I may be affiliated in any way.
> WARNING TO SPAMMERS:  at http://www.zak.co.il/spamwarning.html
>
>
> _______________________________________________
> Linux-il mailing list
> Linux-il at cs.huji.ac.il
> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20100731/bb8d9d06/attachment.html>