c# excel 选择打开表

来源：百度知道 编辑：UC知道 时间：2024/06/06 06:52:32
代码如下
private void btnOk_Click(object sender, EventArgs e)
{
Excel.Application app = new Excel.ApplicationClass();
try
{
app.Visible = false;
Excel.Workbook wBook = app.Workbooks.Open(@"C:\dogslife.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
//Worksheet wSheet = wBook.ActiveSheet as Worksheet;
wSheet.Cells[1, 1] = "测试";
app.DisplayAlerts = false;
app.AlertBeforeOverwriting = false;
wBook.Save();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{<

将这行//Worksheet wSheet = wBook.ActiveSheet as Worksheet;
换成
Worksheet wSheet = (Worksheet)wBook.Sheets[i]//i为你想要的sheet，如1就是sheet1，2就是sheet2...

要是想用SQL的话，要连接数据库

//数据连接字符
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\";" + "data source=dogslife.xls" ;
//SQL语句写在这
String strSQL = "SELECT * FROM [Sheet1$]";
//数据连接
OleDbConnection excelConnection = new OleDbConnection(connectionString);
excelConnection.Open();
OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);
DataTable dTable = new DataTable();
dataAdapter.Fill(dTable);
/* 数据绑定 */

dTable.Dispose();
dataAdapter.Dispose();
dbCommand.Dispose();
excelConnection.Close();
excelC