Web Analytics Made Easy -
StatCounter how to delete entire column in an excel file? - CodingForum

Announcement

Collapse
No announcement yet.

how to delete entire column in an excel file?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to delete entire column in an excel file?

    Hi all,

    I want to delete an entire column of an excel file. I tried both OLE and spreadsheet.
    I could not find a way.
    Is there any way to delete particular column of excel file?

    I m using "Spreadsheet::ParseExcel::SaveParser" to open an existing excel file


    Thanks

  • #2
    ok..Got it
    Code:
    my $worksheet  = $workbook->sheets(0);
    
    
    $worksheet->write($row+1, $col+9, "hi");
    $workbook->close();
    this will overrite the current data..

    But i dont know why it did not work yesterday

    Comment

    Working...
    X