Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^5: Deleting entire row and column

by Happy-the-monk (Canon)
on Mar 09, 2018 at 09:24 UTC ( [id://1210552]=note: print w/replies, xml ) Need Help??


in reply to Re^4: Deleting entire row and column
in thread Deleting entire row and column

$worksheet->write($row1, $col1, "$val");

Basically, you will need a new worksheet (as said above) to write into for any worksheet you want to rewrite.

So the code for writing will be: $new_worksheet->write($row -1, $col -1, "$val");

Cheers, Sören

Créateur des bugs mobiles - let loose once, run everywhere.
(hooked on the Perl Programming language)

Replies are listed 'Best First'.
Re^6: Deleting entire row and column
by harishnv (Sexton) on Mar 10, 2018 at 14:34 UTC

    how to also copy the format of the original and sheet name? I tired writing this but didn't change the name of the sheet inside the foreach $worksheet $worksheet1 = $workbook->addworksheet($worksheet);

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (4)
As of 2024-04-19 14:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found