如何在按钮上单击事件阅读Excel文件 [英] How Do I Read A Excel File On Button Click Event
本文介绍了如何在按钮上单击事件阅读Excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮助我如何在单击按钮时打开excel表。对于连接字符串,为什么我们提供这样的解释我关于连接字符串Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ fileName +;扩展属性= \Excel 8.0; HDR = YES; \
kindly help how do i open a excel sheet on clicking a button.and for connection string why we are providing like this explain me about the connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 8.0;HDR=YES;\"
推荐答案
如果您正在寻找从excel文件导入数据并将其显示到datagridview /保存到数据库然后你可以尝试
if u r looking for importing data from excel file and show it to datagridview /save to database then u may try
DialogResult dr= openFileDialog.ShowDialog();
if (dr == DialogResult.OK && openFileDialog.CheckFileExists )
{
string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", openFileDialog.FileName);
string query = String.Format("select * from [{0}
,Sheet1);
OleDbDataAdapter dataAdapter = new OleD bDataAdapter(query,connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
dgvStudents.DataSource = dataSet.Tables [0];
}
", "Sheet1"); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); dgvStudents.DataSource = dataSet.Tables[0]; }
这篇关于如何在按钮上单击事件阅读Excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文