使用EXCEL SHEET和ASP.NET [英] using EXCEL SHEET with ASP.NET
问题描述
我需要在ASP.NET应用程序中使用Excel工作表，以便用户可以输入（复制，粘贴）大数字
此Excel工作表中的行数。此外，无论是什么
，用户ENETRS需要转到SQL数据库，可能只需点击
按钮。
这可能吗？ &安培;这样做的最佳方法是什么？ &安培;如果有任何
链接那么确实告诉我那些因为我不知道怎么去
这样做。
谢谢
-
pmud
pmud写道：
我需要在ASP.NET应用程序中使用Excel工作表，以便用户可以在此Excel工作表中输入（复制，粘贴）大量行。此外，无论用户ENETRS需要转到SQL数据库，可能只需点击一下
按钮。
嘿pmud，
看看这个（看包装）
http://msdn.microsoft.com/library/de...hiteRabbit.asp
您可能需要Visual Studio的Office工具 - 不知道是否可以下载它。
-
软件就像性别：当它是免费的时候更好 - [Linus Torvalds]
Fabio Marini - A +，RHCT，MCDBA，MCAD.NET
回复：news [at] mamakin1976 [dot] plus [dot] com
Hi Fabio，
我已经拥有Visual Studio.Net企业版。这些办公工具
随之而来。但我不认为这些已经安装了服务器已经
安装了MS Excel。这些工具有什么不同吗？
" Fabio"写道：
pmud写道：
我需要在ASP.NET应用程序中使用Excel工作表，以便用户可以在此Excel工作表中输入（复制，粘贴）大量行。此外，无论用户ENETRS需要转到SQL数据库，可能只需点击一下
按钮。
嘿pmud，
有看看这个（看包装）
http://msdn.microsoft.com/library/de...hiteRabbit.asp
您可能需要Office Tools for Visual工作室 - 不知道你是否可以下载它。
-
软件就像性：当它免费时它会更好 - [Linus Torvalds]
Fabio Marini - A +，RHCT，MCDBA，MCAD.NET
回复：news [at] mamakin1976 [dot] plus [dot] com
最好的办法是用ASP.NET创建一个Web服务，并让用户在桌面上使用Excel访问它。
如何使用来自Office VBA宏的ASP.NET使用XML Web服务
Wo rd或Excel
"本文演示如何使用ASP.NET中的ASP.NET Web服务
a Word中的Visual Basic for Applications（VBA）宏或Excel。
http://support.microsoft.com/default...b;en-us;307033
http://msdn.microsoft.com/library/de...l/ odc_xlws.asp
http ：//www.codeproject.com/vb/net/Webservices.asp
Ken
Microsoft MVP [ASP.NET]
" pmud" <下午** @ discussions.microsoft.com>在消息中写道
新闻：E9 ********************************** @ microsof t.com ...
我需要在ASP.NET应用程序中使用Excel工作表，以便用户可以进入（复制，粘贴） ）此Excel工作表中的大量行。此外，
无论用户ENETRS需要转到SQL数据库，可能只需单击
按钮即可。
这可能吗？ &安培;这样做的最佳方法是什么？ &安培;如果
任何
链接确实告诉我那些我也不知道如何去做
谢谢
- -
pmud
Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a
button.
Is this possible? & what is the BEST APPROACH for doing this? & also if any
links are there do tell those to me too coz I have no idea how to go about
doing it.
Thanks
--
pmud
pmud wrote:Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a
button.
Hey pmud,
Have a look at this (watch for wrapping)
http://msdn.microsoft.com/library/de...hiteRabbit.asp
You may need Office Tools for Visual Studio - don''t know if you can download it.
--
Software is like sex: it''s better when it''s free -- [Linus Torvalds]
Fabio Marini - A+, RHCT, MCDBA, MCAD.NET
To reply: news [at] mamakin1976 [dot] plus [dot] com
Hi Fabio,
I already have the Visual Studio.Net Enterprise Edition. Thses office tools
come with it. But i dont think these were installed coz the server already
had MS Excel installed on it. Are thses tools something different?
"Fabio" wrote:
pmud wrote:Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever
the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a
button.
Hey pmud,
Have a look at this (watch for wrapping)
http://msdn.microsoft.com/library/de...hiteRabbit.asp
You may need Office Tools for Visual Studio - don''t know if you can download it.
--
Software is like sex: it''s better when it''s free -- [Linus Torvalds]
Fabio Marini - A+, RHCT, MCDBA, MCAD.NET
To reply: news [at] mamakin1976 [dot] plus [dot] com
Your best bet would be to create a Web service with ASP.NET and have users
access it using Excel on their desktop.
How To Use an XML Web Service by Using ASP.NET from an Office VBA Macro in
Word or Excel
"This article demonstrates how to use an XML Web service using ASP.NET from
a Visual Basic for Applications (VBA) macro in Word or Excel. "
http://support.microsoft.com/default...b;en-us;307033
http://msdn.microsoft.com/library/de...l/odc_xlws.asp
http://www.codeproject.com/vb/net/Webservices.asp
Ken
Microsoft MVP [ASP.NET]
"pmud" <pm**@discussions.microsoft.com> wrote in message
news:E9**********************************@microsof t.com...Hi,
I need to use an Excel Sheet in ASP.NET application so that the users can
enter (copy, paste ) large number of rows in this Excel Sheet. Also,
Whatever
the USER ENETRS needs to go to the SQL DATABASE, probably by the click of
a
button.
Is this possible? & what is the BEST APPROACH for doing this? & also if
any
links are there do tell those to me too coz I have no idea how to go about
doing it.
Thanks
--
pmud
这篇关于使用EXCEL SHEET和ASP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
