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
[reply]
      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.

[reply]

In Section Seekers of Perl Wisdom