想显示excel中的某一个数据,却显示system._comobject
这是我的程序,从主程序中贴出来有关的一段
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";
                         MessageBox.Show((xlapp.Cells[2, 2]).ToString ());
                         xlbook.SaveAs(path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlExclusive, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                         xlapp.Quit();
                         xlapp = null;
                  }
             catch (Exception ex) { MessageBox.Show(ex.Message); }
         }
执行后显示的是system._comobject
可是我前面不是定义为123吗??求解???
------解决方案--------------------我也想知道,帮你项先,期待答案!!!!
------解决方案--------------------
需要强制转换一下,如
C# code
((Excel.Range)xlapp.Cells[2, 2]).Text    //(只读)
((Excel.Range)xlapp.Cells[2, 2]).Value   //(读写)
((Excel.Range)xlapp.Cells[2, 2]).Value2  //(读写)