Csv file use excel to open and modify

I create csv script to read a csv file.

But when I modified csv file by excel, the csv file can’t read exactly
by csv script.

(I use excel to open csv because it can study and modify easily)

How to fix the problem if I should open the csv file by excel ??

Thanks,

make sure that the excel does not modify the content of your csv file.
Csv
file could be changed from comma to something else.

You can verify the content of csv file with text editor.

Thanks

channa ly wrote in post #1021830:

make sure that the excel does not modify the content of your csv file.
Csv
file could be changed from comma to something else.

You can verify the content of csv file with text editor.

Thanks

I should modify the content,
and use excel to open can more easily to modify.

So, I just can verify the content with text editor ??

Thanks

I am using open office excel to open and modify the content of csv as
well.

But i make sure that the csv separator is reversed. Because excel
support more than one option of separator. Make sure that when you save
your csv file the comma separator is still using.

I used to open my csv file with comma separated value. after modifying i
save it without paying much attention on the open office instruction,
then Open office modify my comma separator to semi-column separator then
it make my ruby fail to read the csv content.

What i can say is: after saving the csv file, if somehow you can not
read with your ruby program then u should take a took at the file with
raw-text editor to double check is the comma separated is used.

let s me know if you get the idea.

thanks