in reply to Re^9: Append new line in excel sheets
in thread Append new line in excel sheets

Hi @Roboticus,

I want to append the data to a excel file having .xls extension, can TEXT::CSV do that?

And you are right I don't need any formatting in that.

Replies are listed 'Best First'.
Re^11: Append new line in excel sheets
by roboticus (Chancellor) on Aug 02, 2014 at 14:49 UTC

    perl_new_b:

    You can create a new file .csv file (named with a .xls extension) and put all the data in it. Text::CSV will do that. But it won't append data to an existing .xls file.

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

[reply]
Re^11: Append new line in excel sheets
by perl_new_b (Novice) on Jul 24, 2014 at 05:28 UTC

    Hi @roboticus,

    I want to clear my point in case I missed to mention. I'm reading a .xls file and convertion into .csv using ParseExcel cell handler. But cell handler is missing the last row of excel file. So first I need to append a new row at end then will convert it into CSV.

    Thought I can try what you have suggested me :).

[reply]

      perl_new_b:

      The cell handler shouldn't be missing any data. Can you show an example?

      ...roboticus

      When your only tool is a hammer, all problems look like your thumb.

[reply]

        Hi roboticus,

        cell handler misses data for few files, I'm really sorry I can not share the actual data but I can share the dummy for that.

        I will inbox the file.

[reply]

In Section Seekers of Perl Wisdom