使用JQuery读取Excel数据 [英] Read Excel data with JQuery

查看:119
本文介绍了使用JQuery读取Excel数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想知道如何从多工作表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

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=beb5d477-2100-4586-a13c-50e56f101720&DisplayLang=en

这篇关于使用JQuery读取Excel数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆