开发者

Jquery AutoSuggestion from Excel File

开发者 https://www.devze.com 2023-01-15 22:20 出处:网络
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 cou

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 display开发者_高级运维ing 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

0

精彩评论

暂无评论...
验证码 换一张
取 消