Re: Editing an existing excel (crossposted)

From what I can spot is your program reading lines from a zipped file.

Each line is written completely into the first cell of consecutive rows.

So what is your problem?

It's considered impolite to not tell us that you already asked that question!

Cheers Rolf
_{(addicted to the Perl Programming Language :)

Wikisyntax for the Monastery}

Comment on Re: Editing an existing excel (crossposted)

Replies are listed 'Best First'.
Re^2: Editing an existing excel (crossposted) by thonny (Initiate) on Oct 26, 2021 at 10:51 UTC
My apologies. I asked to help on how to plot charts.	[reply]
Re^3: Editing an existing excel by LanX (Saint) on Oct 26, 2021 at 12:12 UTC
Please be clearer. I have to guess... Do you want to add new rows to an existing sheet, and expect the existing charts to be updated? Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery}	[reply]
Re^4: Editing an existing excel by thonny (Initiate) on Oct 26, 2021 at 14:32 UTC
I do not need to add new rows. So, before this I have been copy pasting the data from text file to excel file manually. I planned to come up with an automation to export values from the text file to excel file that is already there. Basically, need to automate values from the text file to the column A of the excel file. Then, based on the values, the histogram that has been created in the excel will be updated.	[reply]
Re^4: Editing an existing excel by Johanphilip (Initiate) on Oct 31, 2021 at 15:40 UTC
I also use Perl, need to learn some here.	[reply]