Re^5: 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)

Comment on Re^5: Deleting entire row and column Select or Download Code

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);	[reply]