Results 1 to 2 of 2

Thread: Displaying selectable excel data?

  1. #1

    Displaying selectable excel data?

    I have an Excel table that needs to be displayed in drop down boxes..., basically, you select your column, and your row, and the result is the crossing point (select Column C and select Row 167, and it will output the results of cell C167). What is the best way to go about this? I'm thinking of moving the table to an Access database, and then populate the drop down boxes with a select query, which will output the results after both boxes have had a selection made?

  2. #2
    1,839
    posts
    Registered User
    Quote Originally Posted by Joker69 View Post
    I have an Excel table that needs to be displayed in drop down boxes..., basically, you select your column, and your row, and the result is the crossing point (select Column C and select Row 167, and it will output the results of cell C167). What is the best way to go about this? I'm thinking of moving the table to an Access database, and then populate the drop down boxes with a select query, which will output the results after both boxes have had a selection made?
    excell can output to csv
    php has a function calles something like fget_csv() that will automagically parse each csv line and just shove it into a 2d array....

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012