#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2001
    Location
    Ohio University
    Posts
    3
    Rep Power
    0

    Question


    I've been given the task of doing a search against an Excel spreadsheet based on single or combined search fields entered via a web page(form). I suggested having the info put into a database such as Oracle or SQL but it was a no go. What I need is something that will search an Excel spreadsheet returning all pertinent rows (properly formatted) based on matching column (possibly multiple) data. How should I tackle this?? I'm new to database stuff in general, but I've been studying up on SQL and know enough in Perl to get by, but have done NOTHING with Excel spreadsheets at all. It was recommended that the file be converted to a text file, but that's also a no go -- powers that be want the spreadsheet accessed directly.

    help!
    ---Meileiki
  2. #2
  3. Ole` Timer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    N.W. Iowa
    Posts
    472
    Rep Power
    14
    You may want to check out the module Excel Spreadsheet-ParseExcel located at CPAN

    They also have other modules for Excel, just do a search on Excel modules. This assuming your working with Perl.

    Cheers,

    Mickalo

    Thunder Rain Internet Publishing

    Custom Programming & Database development
    Providing Personal/Business
    Internet Solutions that work!

IMN logo majestic logo threadwatch logo seochat tools logo