Hi,
I use MS Office Excel 2007. I want to set the encoding option of the csv file as Unicode. I want to save unicode contents to the file.
Where can I find this option ( Encoding type ) in the Excel application. This option is usually seen in Notepad where we can select the encoding type. It is usually found in the Save As dialog.
Is this feature available? If so, I want the steps for the same.



Also when I save unicode data of the csv format, all the contents get saved in a single cell of the excel sheet. I set the encoding type from MFC (VC++). Is there any difference in the way csv format unicode data is recoginized in MS Office 2007?

Kindly clarify.

Thanks.....

AFAIK, it's no possible in old versions of Excel, not sure about 2007.

All programs should recognize unicode files by reading the first two or three bytes, it's standard. e.g. The first two bytes of UTF-16 file are 'FF FE'; the first 3 bytes of UTF-8 file are 'EF BB BF'. You can check it with VC++ or any text editor which supports HEX mode.

Can Excel 2007 import Unicode (either UTF-16 or UTF-8) .csv files?
Kindly clarify.
Is it necessary that the values need to be separated by tabs so that each value is written to a separate cell or will the use of commas suffice?