Deleting entire column in an excel

harishnv has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Deleting entire column in an excel by Corion (Patriarch) on Mar 11, 2018 at 10:10 UTC
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.	[reply]
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]
Re^3: Deleting entire column in an excel by poj (Abbot) on Mar 11, 2018 at 10:29 UTC
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]
Re^4: Deleting entire column in an excel by harishnv (Sexton) on Mar 11, 2018 at 10:45 UTC
Re^5: Deleting entire column in an excel by poj (Abbot) on Mar 11, 2018 at 11:20 UTC
Some notes below your chosen depth have not been shown here


Clear questions and runnable code get the best and fastest answer
	PerlMonks