Csv file use excel to open and modify

ruby-talk
1

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,

···

--
Posted via http://www.ruby-forum.com/.

2

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

···

On Wed, Sep 14, 2011 at 9:38 AM, CC Chen <dickyhide@gmail.com> wrote:

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,

--
Posted via http://www.ruby-forum.com/\.

3

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

···

--
Posted via http://www.ruby-forum.com/.

4

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

···

--
Posted via http://www.ruby-forum.com/\.