使用JQuery读取Excel数据 [英] Read Excel data with JQuery
问题描述
我想知道如何从多工作表MS Excel 2003文件中读取数据,而不使用jquery。我已经阅读了几个PHP / JQuery,ActiveX等的解决方案,但是我想使用仅限JQuery的来实现。任何想法如何可以工作?
I would like to know how to read data from a multi-worksheet MS Excel 2003 file using nothing, but jquery. I have read several solutions for PHP/JQuery, ActiveX, etc..., but I would like to do it with JQuery ONLY. Any idea of how this could work?
我发现 http://plugins.jquery.com/project/csv2table ,这样做的工作几乎完美,除了事实上,我必须将每个工作表分成CSV文件。我想放弃这一步,直接从Excel文件中读取。感谢您的帮助!
I have found http://plugins.jquery.com/project/csv2table and this does the job almost perfectly, except for the fact that I have to break each sheet out into a CSV file. I would like to drop that step and read it directly from the Excel file. Thank you in advance for your help!
BTW - 我在FireFox 4工作,不需要跨浏览器支持。
推荐答案
Office Web Components提供了一个通过javascript(或vb)来excel文档的API。他们的文件记录不良,但对于内部网类型的应用程序,他们可以完成工作。我在IE6中使用了它们的数据透视表功能,并且不知道它是否可以与Firefox一起使用。
Office Web Components provide an api to excel documents via javascript (or vb). They are poorly documented but for intranet type applications they can get the job done. I have used them for the pivot table functionality in IE6 and do not know if it will work with Firefox.
http://en.wikipedia.org/ wiki / Office_Web_Components
这篇关于使用JQuery读取Excel数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!