Re: export data from multiple files in a folder to an excel file

in reply to export data from multiple files in a folder to an excel file

What is the error you are getting? The second code is working for me. Except that you don't need Spreadsheet::ParseExcel. Because, you are not Parsing any excel files.
Also change this : <#!/usr/bin/perl -w> to this: #!/usr/bin/perl -w. In your first code.

Comment on Re: export data from multiple files in a folder to an excel file Select or Download Code

Replies are listed 'Best First'.
Re^2: export data from multiple files in a folder to an excel file by veeru612 (Initiate) on Nov 29, 2012 at 19:03 UTC
Hello Sir, Please forget the first code, but in the 2nd code it says it cannot parse the formula and nothing gets written in the excel file, :(	[reply]
Re^3: export data from multiple files in a folder to an excel file by Anonymous Monk on Nov 29, 2012 at 19:30 UTC
Which `Formula`? I can't see any in your second code. Except, there is a part of the code you are not showing.	[reply]
Re^4: export data from multiple files in a folder to an excel file by veeru612 (Initiate) on Nov 30, 2012 at 12:58 UTC
sorry Mr Anonymous Monk for not getting back, I just couldn't do it with perl and so did the same with macros in excel. thanks for reading and commenting,, I appreciate your time :)	[reply]

In Section Seekers of Perl Wisdom