Re: Writing into an existing excelsheet

I may be out of line suggesting this here but maybe Perl is not the best tool for this job. If you just want to share information between excel spreadsheets you can use references and formulas to do that. I might be misunderstanding your request though. Perhaps you could add some detail.

Are you always reading from the same spreadsheets or does that change often?
What are the source spreadsheets location relative to the one you are using to aggregate the data to?
Are the source documents readily accessible to people who will be using the final spreadsheet?

These questions should help determine whether or not Perl is the right tool for the job.

Comment on Re: Writing into an existing excelsheet

Replies are listed 'Best First'.
Re^2: Writing into an existing excelsheet by Satish@Stag (Novice) on Sep 19, 2007 at 14:04 UTC
I have some 50 excel files which contains say 10 columns in each xls. From these 50 xls files, I want to generate a single xls report which contains say only 5 columns data from each 50 excel files. i.e., some data (say Col A, B, C, D, E, F...) from 50 excel sheets to be extracted to single report (say Col A, D, E only) with single worksheet only...	[reply]