作者:乔山办公网日期:
返回目录:excel表格制作
private void btnInput_Click(object sender, EventArgs e)//导入e799bee5baa6e79fa5e98193e4b893e5b19e365按钮点击事件
{
openFileDialog1.Filter = "Microsoft Office Excel 工作薄(*.xls)|*.xls";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
DataTable dt1 = GetExcel(openFileDialog1.FileName);//把Excel中的数据导入到DataTable中
}
}
public DataTable GetExcel(string Path)//Excel导入到DataTable
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = null;
DataTable dt = new DataTable();
int result = 1;
try
{
conn.Open();
DataTable dtName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
string strExcel = "Select * from [" + dtName.Rows[0]["TABLE_NAME"].ToString() + "]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
myCommand.Fill(dt);
conn.Close();
}
catch (Exception ex)
{
result = 2;
}
finally
{
conn.Close();
}
if (result == 2) return null;
else return dt;
}
已经写到DataTable中了.这个你输出应该没问题了吧.
private void GetDataFromExcelWithAppointSheetName(string Path)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
//返回Excel的架构,包括各个sheet表的名称,类型,创建时间和修改时间等
DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
//包含excel中表名的字符串数组
string[] strTableNames = new string[dtSheetName.Rows.Count];
for (int k = 0; k < dtSheetName.Rows.Count; k++)
{
strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
}
OleDbDataAdapter myCommand = null;
DataTable dt = new DataTable();
//从指定的表明查询数据,可先把所有7a686964616fe58685e5aeb9333表明列出来供用户选择
string strExcel = "select * from [" + strTableNames[0] + "]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
dt = new DataTable();
myCommand.Fill(dt);
dataGridView2.DataSource = dt; //绑定到界面
}
其中,Path是Excel文件的路径
把dataGridView2换成listview试试