Re: unicode CSV files

Hi John,

I made some tests and if you don't really want the end user to have to go
through the import data routine for every file that gets created, your csv
file can be only with format ANSI or UTF-8.
Import & Export of a CSV file depends on the Regional & Language Options in
the Windows Control Panel (for English (United States) the separator is the
comma).

Regards,
MP

"John Clennett" <JohnClennett@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
message de news: B2454726-8E33-4AD3-8554-3540CE744FD8@xxxxxxxxxxxxxxxx
I'm using Excel 2003 as well.
What I'm getting is that the dotnet application writes the csv file but
when
the file is double-clicked Excel says 'The file is not in recognizable
format' & doesn't give any option to open it other than all the data in a
single cell. I don't really want the end user to have to go through the
import data routine for every file that gets created.

John

"Michel Pierron" wrote:

Re John,
Which version of Excel do you have ?
The csv files are text files. With Excel 2003, if I separately create a
unicode (UTF-16 or UTF-8) txt file with the comma, semicolon or tabulator
like separator and that records it with the csv extension, when I open
this
file with Excel, I have the dialogbox allowing choice for the type of
data
(delimited or not) and the separator.

MP

"John Clennett" <JohnClennett@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
message de news: B5179B7D-9924-4A05-B1CA-A4F9F04E2931@xxxxxxxxxxxxxxxx
Yes. Same problem when the file has a txt extension.

"Michel Pierron" wrote:

Re John,
If you rename your file with the txt extension and that you open it
with
Excel, do you have the same error ?
MP

"John Clennett" <JohnClennett@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans
le
message de news: DE419CF9-395F-458F-9141-DE99031EBEC7@xxxxxxxxxxxxxxxx
Hi Michel,

Opening in Word it prompts you to select the required encoding. Once
Unicode
is selected it opens OK.
Excel doesn't have the same prompt

John

"Michel Pierron" wrote:

Hi John,
Do you have the same problem if you to try to open this file with
Word
?
MP

"John Clennett" <JohnClennett@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit
dans
le
message de news:
6BB54E32-B77A-43F1-A68D-65044677FD5E@xxxxxxxxxxxxxxxx
I need to write unicode csv files from a dotnet application to be
opened
in
Excel.
I can write the files OK by setting
Response.ContentEncoding = System.Text.Encoding.Unicode
but when I try & open them in Excel it says 'The file is not in a
recognizable format'.
I haven't been able to see any settings to change the acceptable
formats.
Anyone any ideas as to how this can be done?

Thanks,

John











.

Relevant Pages

  • RE: WorkbookOpen in COMAddin for CSV-files
    ... I 'm starting to think that the CSV path name may be too long. ... Maybe try putting the CSV file on a short path or Map ... Another possibility is the command line that opens the CSV file is modified. ... Because you are dealing with a CSV file something is opening excel using the ...
    (microsoft.public.excel.programming)
  • Re: CSV Downloads
    ... Open/Save As prompt when you click your bank statement (.CSV file). ... > am presented with a file download box. ... On the XP machine I select CSV and Excel is opened ... >> opens in IE, just do File/Save As and save it as .xls or whatever. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: in which folder can you save a .CSV file?
    ... For sure you saved as an Excel *.xls workbook but get the "cannot access the ... Excel opens and the info gets copied to an Excel worksheet. ... open it and re-save as a *.csv to that folder. ... To save your email address book as a *.CSV file you must do that though Oulook, ...
    (microsoft.public.excel.misc)
  • Re: read csv file in iframe as text file
    ... load it as a text file. ... finally opens it with excel in IE window itself. ... format only so that it can be edited externally with excel easily. ... Later on i want to display the read csv file in javascript and do some ...
    (comp.lang.javascript)