从Excel导入数据时出错 [英] Error when I import data from excel

问题描述

您好，所有专家，

我想将所有数据从我的Excel导入vb.net中的datagridview.
如果我不打开excel文件，则会出现错误外部表格式不正确".但是如果我打开它，它不会显示错误.

Hi all experts,

I want to import all data from my excel to datagridview in vb.net.
if i don''t open excel file, it will error " External Table is not in the expected format." but if i open it, it doesn''t display error.

Dim MyConnection As OleDb.OleDbConnection,DA As OleDb.OleDbDataAdapter MyConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Me.TextBox1.Text & ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'") 

DA = New System.Data.OleDb.OleDbDataAdapter("select * from [Detail$]", MyConnection) 
DA.TableMappings.Add("Table", "Tbl1") 
DtSet = New System.Data.DataSet 
DA.Fill(DtSet) 
Me.DataGridView1.DataSource = DtSet.Tables(0) 

有谁知道我如何在两种情况下都从Excel导入数据(打开Excel文件而不打开Excel文件)?

注意:
我的MS Office是:2007

谢谢

TONY

Does anybody know how can i import data from excel in both cases( Open Excel file and not open excel file)?

Note:
My MS Office is : 2007

Thanks

TONY

推荐答案

"，MyConnection) DA.TableMappings.Add(" ，" Tbl1") DtSet = 新建 System.Data.DataSet DA.Fill(DtSet) 我 .DataGridView1.DataSource = DtSet.Tables( 0 )

", MyConnection) DA.TableMappings.Add("Table", "Tbl1") DtSet = New System.Data.DataSet DA.Fill(DtSet) Me.DataGridView1.DataSource = DtSet.Tables(0)

有谁知道我如何在两种情况下都从Excel导入数据(打开Excel文件而不打开Excel文件)?

注意:
我的MS Office是:2007

谢谢

TONY

Does anybody know how can i import data from excel in both cases( Open Excel file and not open excel file)?

Note:
My MS Office is : 2007

Thanks

TONY

在Excel 2007中使用Microsoft.ACE.OLEDB.12.0 http://www.connectionstrings .com/excel-2007 [ ^ ]

Use Microsoft.ACE.OLEDB.12.0 for Excel 2007 http://www.connectionstrings.com/excel-2007[^]

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