How do I append excel sheets into a single excel file by grepping on file creation time
Posted on 2010-09-01
I need to write a perl script for the following --
I have some .xls files in the directory "/v/region/na/appl/qatools/util/data/reports/automation_framework/Results"
the .xls files have the structure like below
header1 header2 header3
value1 value2 value3
having a single row in each of them
I need to concatenate the .xls files into a final_res.xls file in a single sheet by first grepping on files beginning with "Int_Res" in the dir "/v/region/na/appl/qatools/util/data/reports/automation_framework/Results", then putting the file which was created first in the final_res.xls along with header, then appending the next created file but stripping off the header row which is row 0 and so on.
Is it possible? Pls help..