Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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)

Replies are listed 'Best First'.
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 cooling their heels in the Monastery: (12)
As of 2016-08-31 15:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (432 votes). Check out past polls.