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

[dragonchild]

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.

[sabersd]

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

[dragonchild]

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.