先看代码private void btnOk_Click(object sender, EventArgs e)//ok
{
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
{
app.Quit();
app = null;
} }
Sheet1 Sheet2 Sheet3注释掉的那一行是我要操作但不成功的,那样做的话只能是操作第一张表,也就是Sheet1。我要像sql一样对这个文件中的表中的行进行增、改。我怎么才能指定我要操作的表呢?就用这种方法,别的方法不说。
{
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
{
app.Quit();
app = null;
} }
Sheet1 Sheet2 Sheet3注释掉的那一行是我要操作但不成功的,那样做的话只能是操作第一张表,也就是Sheet1。我要像sql一样对这个文件中的表中的行进行增、改。我怎么才能指定我要操作的表呢?就用这种方法,别的方法不说。
Worksheet wSheet = (Worksheet)wBook.Sheets[i];
要结贴了,谁来回答一下。白给第一个顶的,虽然就20分