Re: Export data to excel
Re: Export data to excel
- Subject: Re: Export data to excel
- From: Jonathon Mah <email@hidden>
- Date: Fri, 11 Feb 2005 03:25:45 +1030
On 9 Feb 2005, at 19:04, Nishant Singh wrote:
Hi,
I want to export Japanese text (or any multibyte characters) from a
table-view to an excel.
For english text I have been able to do this. The data is exported in
tabDelimetedText format.
However the Japanese characters show up as junk in excel.
Is there any way this can be done in cocoa?
Do I need to do some characterset mapping?
Playing around with a simple TextEdit document, it looks like Excel
doesn't properly recognize Japanese from a text file with UTF-8,
UTF-16, Japanese (Mac OS), or Japanese (Shift JIS). Microsoft Office
doesn't have particularly outstanding Unicode support (it was only
added in Office 2004), so I'm not surprised.
Trying one last thing with TextEdit gives a work-around. If you create
a new document in Excel, then copy and paste from TextEdit, it seems
that characters are treated properly. Perhaps you could get the user to
copy and paste (by supplying a command that copies it in the correct
format), or you could try using AppleScript to automate it.
Jonathon Mah
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden