如何在vb.net中连接到Excel数据 [英] how to connect to excel data in vb.net

问题描述

如何在vb.net中连接到Excel数据.
我需要一个示例代码.

在此先感谢您.

how to connect to excel data in vb.net.
i need a sample code.

Thanks in Advance.

推荐答案

感谢您的提问.请遵循以下代码.

Thanks for your question. Follow bellow code.

Dim cn as ADODB.Connection
Set cn = New ADODB.Connection
With cn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source=C:\MyFolder\MyWorkbook.xls;" & _
"Extended Properties=Excel 8.0;"
    .Open
End With

参考: http://support.microsoft.com/kb/257819 [

Ref:http://support.microsoft.com/kb/257819[^]


Thanks,
Mamun

这篇关于如何在vb.net中连接到Excel数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！