如何读取Excel文件以在Web上显示工作表。 [英] How do I read an excel file to display the worksheet on the web.

查看:99
本文介绍了如何读取Excel文件以在Web上显示工作表。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何阅读excel文件以在网络上显示工作表。


我能否以编程方式使用某些Excel自动化

操纵通过网络浏览器excel文件。


提前致谢。


我想做的是创建一个如图所示的链接下面。


-Link1

-Link2

-Link3


如果是Link1点击。必须在Web浏览器上显示excel文件的工作表#1。

然后单击Link2。 excel文件的工作表#2必须在网络浏览器上显示。


这可能吗?

解决方案

" sarunnio" < SA ****** @ gmail.com>在消息中写道

news:5b ************************** @ posting.google.c om ...

如何阅读excel文件以在网上显示工作表。

我是否可以使用一些excel自动化以编程方式操作
操作excel文件通过网络浏览器。




是的,你可以,但不推荐这种方法,因为它创造了巨大的

开销。


一个更好的解决方案,虽然不是免费的,但是可以使用第三个可以与MS-Office文件一起使用的
方实用程序之一,而不必

首先实例化Office。


我使用这个套件: http://www.aspose.com/


您可以使用OLE接口读取工作簿,它是床单。

这样,你不需要自动化EXCEL,因此你不需要

来将它安装在运行它的机器上。

我写了一个组件来做这个和一个web界面,你可以从URL加载

工作簿并查看它表格。


-

问候,

DennisJDMyrén

奥斯陆Kodebureau

" sarunnio" < SA ****** @ gmail.com>在消息中写道

news:5b ************************** @ posting.google.c om ...

如何阅读excel文件以在网上显示工作表。

我是否可以使用一些excel自动化以编程方式操作excel文件网页浏览器。

提前致谢。

我想做的是创建如下所示的链接。

- Link1
-Link2
-Link3

如果单击Link1。 excel文件的工作表#1必须显示在web浏览器上。
然后单击Link2。 excel文件的工作表#2必须在web浏览器上显示。

这可能吗?



DennisMyrén <德**** @ oslokb.no>在消息中写道

新闻:eS ************** @ TK2MSFTNGP10.phx.gbl ...

你可以使用OLE接口来读取工作簿和它的工作表。
这样,你不需要自动化EXCEL,因此你不需要在机器上安装它会运行。
我写了一个组件来做这个和一个web界面,你可以从URL加载
工作簿并查看它的表。




这很有意思...当你说那样,你不需要自动化

EXCEL,因此你不需要在机器上安装它

从哪里运行,你在谈论客户端或服务器吗?


How do I read an excel file to display the worksheet on the web.

Can I make use of some excel automation to programmatically
manipulate the excel file via the web browser.

Thanks in advance.

What I ''d like to do is to create a link like shown below.

-Link1
-Link2
-Link3

If Link1 is clicked. the worksheet #1 of excel file must be shown on web browser.
Then Link2 is clicked. the worksheet #2 of excel file must be shown on web browser.

Could that be possible??

解决方案

"sarunnio" <sa******@gmail.com> wrote in message
news:5b**************************@posting.google.c om...

How do I read an excel file to display the worksheet on the web.

Can I make use of some excel automation to programmatically
manipulate the excel file via the web browser.



Yes you can, though this approach is not recommended because of the massive
overhead it creates.

A much better solution, though not free, would be to use one of the 3rd
party utilities which can work with MS-Office files without having to
instantiate Office first.

I use this suite: http://www.aspose.com/


You could use the OLE interface to read the workbook and it''s sheets.
That way, you do not need to automate EXCEL and therefore you will not need
to have it installed on the machine from where this would run.
I wrote a component to do that and a web interface where you could load
workbook from an URL and view it''s sheets.

--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"sarunnio" <sa******@gmail.com> wrote in message
news:5b**************************@posting.google.c om...

How do I read an excel file to display the worksheet on the web.

Can I make use of some excel automation to programmatically
manipulate the excel file via the web browser.

Thanks in advance.

What I ''d like to do is to create a link like shown below.

-Link1
-Link2
-Link3

If Link1 is clicked. the worksheet #1 of excel file must be shown on web
browser.
Then Link2 is clicked. the worksheet #2 of excel file must be shown on web
browser.

Could that be possible??



"Dennis Myrén" <de****@oslokb.no> wrote in message
news:eS**************@TK2MSFTNGP10.phx.gbl...

You could use the OLE interface to read the workbook and it''s sheets.
That way, you do not need to automate EXCEL and therefore you will not
need to have it installed on the machine from where this would run.
I wrote a component to do that and a web interface where you could load
workbook from an URL and view it''s sheets.



That''s interesting... When you say "That way, you do not need to automate
EXCEL and therefore you will not need to have it installed on the machine
from where this would run", are you talking about the client or server?


这篇关于如何读取Excel文件以在Web上显示工作表。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

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