Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Deleting entire column in an excel

by Corion (Patriarch)
on Mar 11, 2018 at 10:10 UTC ( [id://1210647]=note: print w/replies, xml ) Need Help??


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.

      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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1210647]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (4)
As of 2024-03-29 05:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found