Excel2003数据导入到DataGrideView总是出错!!请大家帮我看看 private void button2_Click(object sender, EventArgs e)//打开EXCEL
{
OpenFileDialog ofg = new OpenFileDialog();
ofg.Filter = "Excel文件(*.xls) | *.xls";
string filename = ofg.FileName;
//int index = filename.LastIndexOf("\\");
//filename = filename.Substring(index + 1);
if (ofg.ShowDialog() == DialogResult.OK)
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + filename;
OleDbConnection oleconn = new OleDbConnection(conn);
string query = "select * from [sheet$]";
OleDbCommand olecmd = new OleDbCommand(query, oleconn);
OleDbDataAdapter oleda = new OleDbDataAdapter(olecmd);
DataSet ds = new DataSet();
oleconn.Open();
oleda.Fill(ds);
oleconn.Close();
this.dataGridView1.DataSource = ds.Tables[0]; } }
{
OpenFileDialog ofg = new OpenFileDialog();
ofg.Filter = "Excel文件(*.xls) | *.xls";
string filename = ofg.FileName;
//int index = filename.LastIndexOf("\\");
//filename = filename.Substring(index + 1);
if (ofg.ShowDialog() == DialogResult.OK)
{
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + filename;
OleDbConnection oleconn = new OleDbConnection(conn);
string query = "select * from [sheet$]";
OleDbCommand olecmd = new OleDbCommand(query, oleconn);
OleDbDataAdapter oleda = new OleDbDataAdapter(olecmd);
DataSet ds = new DataSet();
oleconn.Open();
oleda.Fill(ds);
oleconn.Close();
this.dataGridView1.DataSource = ds.Tables[0]; } }
ds.Tables.Add(new DataTable());
oleconn.Open();
oleda.Fill(ds.Tables[0]);
oleconn.Close();
this.dataGridView1.DataSource = ds.Tables[0]; 试试看~~~
这句是不是放的不合适,这样改下:
private void button2_Click(object sender, EventArgs e)//打开EXCEL
{
OpenFileDialog ofg = new OpenFileDialog();
ofg.Filter = "Excel文件(*.xls) | *.xls";
//int index = filename.LastIndexOf("\\");
//filename = filename.Substring(index + 1);
if (ofg.ShowDialog() == DialogResult.OK)
{
string filename = ofg.FileName;
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + filename;
OleDbConnection oleconn = new OleDbConnection(conn);
string query = "select * from [sheet$]";
OleDbCommand olecmd = new OleDbCommand(query, oleconn);
OleDbDataAdapter oleda = new OleDbDataAdapter(olecmd);
DataSet ds = new DataSet();
oleconn.Open();
oleda.Fill(ds);
oleconn.Close();
this.dataGridView1.DataSource = ds.Tables[0]; } }
string filename = ofg.FileName;
string conn = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=\"Excel 8.0;HDR=no;IMEX=1\";Data Source=" + filename;
应改为:string query = "select * from [Sheet1$]";疏忽大意,疏忽大意啊~~~