in reply to Deleting entire column in an excel

Which of the replies you got to Deleting entire row and column did you follow and where did you encounter problems?

Also given the vague nature of your question, maybe see how other people framed similar questions: Delete Row in Excel, RFC Tutorial - Deleting Excel Rows, Columns and Sheets.

Replies are listed 'Best First'.
Re^2: Deleting entire column in an excel
by harishnv (Sexton) on Mar 11, 2018 at 10:19 UTC

    I have asked in that question but didn't get an answer. shifting the table i could do. I'm not using Win32::OLE.

[reply]

      Win32::OLE would be the best way to do this. You could use Spreadsheet::ParseExcel::SaveParser but be aware of limitations.

      You can only rewrite the features that Spreadsheet::WriteExcel supports so macros, graphs and some other features in the original Excel file will be lost. Also, formulas aren't rewritten, only the result of a formula is written.
      poj
[reply]
[reply]

In Section Seekers of Perl Wisdom