Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Trying to learn and use Perl! More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Welcome Aboard The Crazy Train (Score:1)

by Limbic Region (3985)

First, let me recommend you direct Perl related questions to PerlMonks http://perlmonks.org/ [perlmonks.org] as that is the primary focus of that community

To give some pointers to the actual question at hand, a little more information is needed. Are you reading actual Excel files or do you have the option of reading a "save as" CSV?

If the former - consider Win32::OLE or Spreadsheet::ParseExcel

If the latter - consider Text::xSV (several more options are available, just search for CSV)

Next question - what do you mean by
- Re:Welcome Aboard The Crazy Train (Score:1)
  
  by eyidearie (6032) on 2005.07.07 13:22 (#41713) Journal
  
  Hi L~R, I'm checking out PerlMonks.org.. About d Excel, It's the former so I downloaded the Spreadsheet::ParseExcel module n I'll see how that works By 'close match" I meant, for example, if it compares Ann Palemoon and Anne Palemoon, it should return a match. I'll check the modules you mention out. Thanks a lot, I really appreciate it. Eyi.
  
  Reply to This
  
  Parent
  - Re:Welcome Aboard The Crazy Train (Score:1)
    
    by runrig (3385)
    
    Spreadsheet::ParseExcel::Simple [cpan.org] might be easier to work with.

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.