Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Use the right tool (was Re: Excel to Perl)

by dragonchild (Archbishop)
on Mar 20, 2002 at 18:42 UTC ( #153075=note: print w/ replies, xml ) Need Help??


in reply to Excel to Perl

Don't use Perl for this. Use VBA. It's very easy to do this conversion to tab-delim files.

Now, if you were going to fold the reading of the files into the Perl program, so that it could read either tab-delim or .xls files, then use Spreadsheet::ParseExcel.

------
We are the carpenters and bricklayers of the Information Age.

Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.


Comment on Use the right tool (was Re: Excel to Perl)
Re: Use the right tool (was Re: Excel to Perl)
by sabersd (Initiate) on Mar 20, 2002 at 19:14 UTC
    I'm not knowledgable on vba, where could I find out more info on this? Would I be able to do this in the excel visual basic editor? Thanks
      Yes, it's done in Excel's VB Editor. Read the helpfiles (i.e., hit F1). That's all I did.

      ------
      We are the carpenters and bricklayers of the Information Age.

      Don't go borrowing trouble. For programmers, this means Worry only about what you need to implement.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (10)
As of 2014-08-01 23:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (52 votes), past polls