Re: unicode CSV files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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: Excel loading CSV problem
    ... We were surprised by the change in functionality after the upgrade. ... Excel has treated 1-31 and 1-23 as dates for as long as I can remember through ... TIW opens for me in 2003 when I open a *.csv file renamed to *.txt ... You might try changing the extension on the CSV files to *.TXT ...
    (microsoft.public.excel)
  • Re: Check File Open Macro
    ... Dim oXL As Object 'This is needed to open a new instance of Excel. ... 'THIS LINE OF CODE OPENS THE NEW INSTANCE OF EXCEL. ... Internet, To Do Lists, Travel Tickets & Hotel Reservations and THE LIST ...
    (microsoft.public.excel.programming)
  • Re: Excel - Not calculating formulas
    ... Once calculation is set to automatic or manual (this mode is set by the first ... workbook you open in that session), then that calculation mode will stay this ... excel is still set in automatic mode. ... It takes the Option from the first file it opens. ...
    (microsoft.public.excel.misc)
  • Spreadsheet shortcuts not working
    ... We have shortcuts to spreadsheets setup but when we click on them excel comes ... up but the spreadsheet does not load and there are no error messages. ... But when the speadsheet opens it gives errors that it can not find ... Workstation O24 can not open excel spreadsheets using shortcuts. ...
    (microsoft.public.excel.setup)
  • Re: Code looping through files
    ... List box and I do have Microsoft Forms 2.0 Object Library installed ... Excel or from VBA? ... the References list box? ... in a folder, opens each, does things, closes the file and opens ...
    (microsoft.public.excel.programming)