Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save sheet as Unicode CSV
Hello
The problem has been asked before but I couldn't find any satisfactory answer. In short, I have Excel files which might contain extended characters such as russian, chinese and others, and I want to get a CSV out of a given sheet. From programming, that is via OLE. Is there any decent way to do this ? I mean other than going through every cell, hand-coding its contents to CSV and writing the file myself. Regards V. Simionescu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
save sheet as Unicode CSV
V,
Excel does have a SaveAs Unicode Text option (which seems to give you a Tab separated format), but as far as I see, csv will only give you ANSI characters. NickHK wrote in message oups.com... Hello The problem has been asked before but I couldn't find any satisfactory answer. In short, I have Excel files which might contain extended characters such as russian, chinese and others, and I want to get a CSV out of a given sheet. From programming, that is via OLE. Is there any decent way to do this ? I mean other than going through every cell, hand-coding its contents to CSV and writing the file myself. Regards V. Simionescu |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
save sheet as Unicode CSV
NickHK wrote: V, Excel does have a SaveAs Unicode Text option (which seems to give you a Tab separated format), but as far as I see, csv will only give you ANSI characters. NickHK wrote in message oups.com... Hello The problem has been asked before but I couldn't find any satisfactory answer. In short, I have Excel files which might contain extended characters such as russian, chinese and others, and I want to get a CSV out of a given sheet. From programming, that is via OLE. Is there any decent way to do this ? I mean other than going through every cell, hand-coding its contents to CSV and writing the file myself. Regards V. Simionescu Thanks. I knew that. I was hoping maybe the guys from MS will give an authoritative answer of either what is to be done or that nothing can be done. Vlad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make Excel save Unicode CSV data correctly? | Excel Discussion (Misc queries) | |||
How do I save a data as non-unicode text in am Excell sheet? | Excel Discussion (Misc queries) | |||
Changing a macro to save as Unicode text | Excel Programming | |||
Changing a macro to save as Unicode text | Excel Programming | |||
A macro to export a sheet as UTF8 encoded Unicode file | Excel Programming |