#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0

    Excel file to script


    I have an Excel file where you enter and 9 digit number and it will return a closest value from a list of numbers. now this file works ok, but i need it in javascript form so i can use it on a website.

    sample of numbers are

    120300150
    120300300
    120300450
    120150300
    120450300
    120900150
    120900300
    120900450
    120750300
    121050300
    121500150

    i would like a input area where the user will type and it would look at the array and return the closest value. i dont know how to upload the excel file, but if someone tells me then i can.. each of these values has 2 other bits of iformation attached to it; looking like this;-

    120300150 North 201
    120300300 Central 201
    120300450 South 201
    120150300 West 201
    120450300 East 201


    and what my ideal would be for it to say on the output "the nearest value is 120300150 which is 201 north"


    please help
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2004
    Posts
    2,969
    Rep Power
    374
    to upload an excel file, you could convert it to a csv and then do file_get_content($filename).

    show us what you have done so far
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    can i upload it to this site for evaluations

    docs.google.com/file/d/0By20sUKmd8DQanEzWHFwR1E4ams/edit?usp=sharing
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2004
    Posts
    2,969
    Rep Power
    374
    post to pastebin or fiddler? etc (use google)
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    Originally Posted by paulh1983
    post to pastebin or fiddler? etc (use google)
    just shared on google drive... hope it works
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    did it work, could you see my file?
  12. #7
  13. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    Can anybody help please?
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    9
    Rep Power
    0
    Paste it somewhere else. You need to be invited to see the files.
  16. #9
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    6
    Rep Power
    0
    Originally Posted by coding1
    Paste it somewhere else. You need to be invited to see the files.
    http://

    filebin.ca/gMkMQK2Eriu/Tower_Calculator97versionexcel.xls

IMN logo majestic logo threadwatch logo seochat tools logo