CSV And Excel

  • Thread starter Thread starter MRI
  • Start date Start date
M

MRI

Hello All,

We are developing an application where we are creating a csv file.
It is opening as required in all our machines with the comma separate
values coming correctly in adjacent columns. But at the client's site
the csv opens up with all comma separated values coming in a singl
cell. We sent them a test.csv with just 2 comma separated values an
even that is opening with both of them coming in one column and th
comma coming as a data in the cell. We are able to set "Text to column
delimiter option manually to "comma" and its coming out fine. But w
cannot let the user to do that all the time.

Any ideas why its working fine here? Is it something to do the Exce
setting at the client site? They are using Excel 2002 (10.2614.2625)
Windows. The OS is WinXP.

Please Help,

Thanks In Advance,

MR
 
The character used as a "comma" when reading and writing CSV files is
determined by
Control Panel > Regional Settings > List separator character
 
Hi


Stephen Bye said:
The character used as a "comma" when reading and writing CSV files is
determined by
Control Panel > Regional Settings > List separator character
Click to expand...


Yep

They have to change the separator to comma (I think they have semicolon
there), or they have to open the csv-file with some text editor and replace
all commas with semicolons, save it, and then try again with Excel.
 
Of course it would be much more "client-friendly" if you created the csv
file with the separator character that they are using in the first place,
instead of telling the client that they will need to adjust their computer's
regional settings each time before and after loading the file.
 
Thanks Guys for the help.
We have changed the settings and thinking of using the same separator
as in the client's machine.
 
Back
Top