find all excel files in specified directory recursively, extract the blank columns

perl.learner has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks I am beginner in perl. I want to find all the .xls files recursively in a directory, find the blank columns in the file , print the information and delete the column. Once this is done I want to standardize all the .xls files( like fix the fonts, size, column height and so on) . can you please help me in implemtation. Thanks

Comment on find all excel files in specified directory recursively, extract the blank columns

Replies are listed 'Best First'.
Re: find all excel files in specified directory recursively, extract the blank columns by jettero (Monsignor) on Dec 22, 2008 at 11:35 UTC
Finding the files isn't too bad: Use File::Find and then use Spreadsheet::ParseExcel in your wanted function. You can modify the files with Spreadsheet::WriteExcel. Deleting a column won't be any trouble (I think); but the standardizing things probably will be. -Paul	[reply]
Re: find all excel files in specified directory recursively, extract the blank columns by apl (Monsignor) on Dec 22, 2008 at 13:53 UTC
What have you written so far? That is, what have you tried that didn't work? We could help you resolve any issues you might have encountered. Have you looked at CPAN for the modules that would help make implementing this program easier?	[reply]