private void button1_Click(object sender, EventArgs e)
{
try
{
string path;
path = @"d:\succeccful.xls";
Excel.Application xlapp;
Excel.Workbook xlbook;
Excel.Worksheet xlsheet;
xlapp = new Excel.ApplicationClass();
xlbook = xlapp.Workbooks._Open(path,Missing.Value,Missing.Value,Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlapp.DisplayAlerts = false;
xlapp.Cells[2, 2] = "123";
xlapp.Quit();
xlapp = null;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
{
try
{
string path;
path = @"d:\succeccful.xls";
Excel.Application xlapp;
Excel.Workbook xlbook;
Excel.Worksheet xlsheet;
xlapp = new Excel.ApplicationClass();
xlbook = xlapp.Workbooks._Open(path,Missing.Value,Missing.Value,Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
xlapp.DisplayAlerts = false;
xlapp.Cells[2, 2] = "123";
MessageBox.Show((xlapp.Cells[2, 2]).ToString ());
//上面这句话的结果显示system._comobject,这个需要进行强制转换一下,比如下面这句话
MessageBox.Show(((Excel.Range)xlapp.Cells[2, 2]).Value2.ToString());
xlapp.Quit();
xlapp = null;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
************************************************************
这些是从网上找到的http://dotnet.wgets.com/thread/400640
需要强制转换一下
((Excel.Range)xlapp.Cells[2,2]).Text//(只读)
((Excel.Range)xlapp.Cells[2,2]).Value//(读写)
((Excel.Range)xlapp.Cells[2,2]).Value2//(读写)
************************************************************