steelspy
asked on
How do I delete columns from an Excel document on a UNIX platform.
We're using the PERL module Spreadsheet::WriteExcel to create spreadsheets on our UNIX system. We have a workbook we generate that has many sheets. We would like to publish two version of it. The second version having many of the columns removed. Is there a way to remove columns from an Excel workbook using PERL or another tool? We don't want empty columns left in the 2nd version.
Thank you
Thank you
Do the columns have to be deleted from the existing file? Or could you create two files where you are now creating one.
Using the write_* commands, you could just not write the columns of the second file you don't want there.
Using the write_* commands, you could just not write the columns of the second file you don't want there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.ibm.com/developerworks/linux/library/l-pexcel/