Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re^3: Editing an existing excel

by LanX (Saint)
on Oct 26, 2021 at 12:12 UTC ( [id://11138063]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Editing an existing excel (crossposted)
in thread Editing an existing excel

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

Replies are listed 'Best First'.
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.
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11138063]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2024-04-25 14:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found