如何在c＃visual studio 2008中的datagridview中显示来自ms excel 2007的数据 [英] How to show data from ms excel 2007 in datagridview in c# visual studio 2008

问题描述

如何在c＃visual studio 2008中的datagridview中显示来自ms excel 2007的数据



我尝试了什么：



System.Data.OleDb.OleDbConnection MyConnection;

System.Data.DataSet DtSet;

System.Data.OleDb。 OleDbDataAdapter MyCommand;

MyConnection = new System.Data.OleDb.OleDbConnection（@provider = Microsoft.ACE.OLEDB.12.0; Data Source ='c：\ Book1.xlsx'; Extended Properties = Excel 12.0 Xml;）;

MyCommand = new System.Data.OleDb.OleDbDataAdapter（select * from [Book1]，MyConnection）;



MyCommand.TableMappings.Add（Table，Net-informations.com）;

DtSet = new System.Data.DataSet（）;

MyCommand.Fill（DtSet）;

dataGridView1.DataSource = DtSet.Tables [0];

MyConnection.Close（）;

解决方案

查看使用MS Excel（xls / xlsx）使用MDAC和Oledb [ ^ ]。

how to show data from ms excel 2007 in datagridview in c# visual studio 2008

What I have tried:

System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\Book1.xlsx';Extended Properties=Excel 12.0 Xml;");
MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Book1]", MyConnection);

MyCommand.TableMappings.Add("Table", "Net-informations.com");
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);
dataGridView1.DataSource = DtSet.Tables[0];
MyConnection.Close();

解决方案

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

这篇关于如何在c＃visual studio 2008中的datagridview中显示来自ms excel 2007的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！