Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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

by Anonymous Monk
on Nov 29, 2012 at 18:43 UTC ( #1006324=note: print w/ replies, xml ) Need Help??


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
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, :(

      Which Formula? I can't see any in your second code. Except, there is a part of the code you are not showing.

        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 :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1006324]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (14)
As of 2014-07-22 13:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (113 votes), past polls