Re^2: Deleting entire column in an excel

Replies are listed 'Best First'.
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
can you check this thread Deleting entire row and column , i'm able to shift the cells but i'm not getting how to delete a particular entire column	[reply]
Re^5: Deleting entire column in an excel by poj (Abbot) on Mar 11, 2018 at 11:20 UTC
Show the code you are using to shift the cells	[reply]
Re^6: Deleting entire column in an excel by harishnv (Sexton) on Mar 11, 2018 at 11:37 UTC
Re^7: Deleting entire column in an excel by poj (Abbot) on Mar 11, 2018 at 11:43 UTC
Some notes below your chosen depth have not been shown here


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