来自 Excel 文件的 Jquery AutoSuggestion
我只是想知道是否有人知道如何制作其中一个自动建议文本框，以便当您开始输入时，它会根据 Excel 文件进行自动建议？我到处寻找，却一无所获，我不知道从哪里开始。
创建自动建议不是我的问题，它只是从 Excel 文件中获取数据并显示它以建议与他们输入的内容相关的内容。
我将不胜感激任何帮助。谢谢
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
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
从高层次的角度来看，您需要使用 ajax 来获取文件并解析其内容。完成此操作后，您可以开始检查用户输入是否与解析的内容匹配。
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.
您希望它保留 Excel 形式吗？
如果您愿意，您可以将其导出为 xml...这会让事情变得容易得多。
如果您一心想使用一些表格格式的数据，我可以建议 mysql 甚至 sqlite 吗？
PS：粗略的谷歌搜索显示：
1. http://amiworks.co.in/talk/readingparsing -excel-spreadsheet-using-php/
2. http://www.ibm.com/developerworks/ opensource/library/os-phpexcel/index.html
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