导入MS Excel文件 [英] Import MS Excel File

问题描述

大家好，

我需要单击按钮从PC导入Excel文件.什么功能可以帮助我做到这一点?

有人可以帮助我吗?

谢谢

Hi all,

I need to import an Excel file from my PC in a button click. What is the function that helps me to do that?

Any one can help me?

Thanks

推荐答案

尝试一下，
http://www.aspheute.com/english/20000802.asp [ http://www.java2s.com/Tutorial/JavaScript/0200__Form/FileUpload.htm [ ^ ]

Try this,
http://www.aspheute.com/english/20000802.asp[^]
and
http://www.java2s.com/Tutorial/JavaScript/0200__Form/FileUpload.htm[^]

谢谢您的问题.您可以按照下面的代码进行操作.

Thank you for your question. You can follow the code bellow.

Excel.Workbook wb = 
    ThisApplication.Workbooks.OpenText("C:\\Test.txt", 
    Type.Missing, 3, Excel.XlTextParsingType.xlDelimited, 
    Excel.XlTextQualifier.xlTextQualifierDoubleQuote, 
    Type.Missing, Type.Missing, Type.Missing, True, 
    Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing);

有用的链接: http://msdn.microsoft.com/en-us/library/aa168292(office.11​​).aspx [ ^ ]
http://support.microsoft.com/kb/301982 [

Helpful Link:http://msdn.microsoft.com/en-us/library/aa168292(office.11).aspx[^]
http://support.microsoft.com/kb/301982[^]

Thanks,
Mamun

网络上有成千上万个示例..，

一个简单的Google搜索解决了您的问题..，

浏览以下链接

There are thousand of examples are available in the Net ..,

A simple Google Search Sloves your Problem..,

Go through the below link

Here[^]

这篇关于导入MS Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！