Hey All,
I was just wondering if anybody knows how to make one of those autosuggestion textboxes so that when you begin typing, it will autosuggest based off of an excel file? I've searched everywhere and couldn't find anything, and I don't know where to begin.
Creating the autosuggestion is not my issue, it's just getting the data from the excel file and displaying it to suggest something relevant to what they're typing.
I'd appreciate any help at all. Thank you
From a high level perspective, you'll need to use ajax to grab a file and parse its contents. Once you've done that, you can begin checking the user input for matches to the parsed content.
Do you want it to stay as Excel?
You could export it to xml if you like.. that'd make things a lot easier. If you're bent on using some tabular formatted data, might I suggest mysql, or even sqlite?
PS: A cursory google search reveals:
1. http://amiworks.co.in/talk/readingparsing-excel-spreadsheet-using-php/
2. http://www.ibm.com/developerworks/opensource/library/os-phpexcel/index.html