本文介绍了导入MS Excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,

我需要单击按钮从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

推荐答案


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 [ ^ ]

谢谢,
Mamun




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

Thanks,
Mamun



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

08-14 23:17