m_objExcel = new Excel.Application();
m_objBook=m_objExcel.Workbooks.Open(ps_filename,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
objSheets=m_objBook.Sheets;
objSheet_s=(Excel._Worksheet)objSheets.get_Item("aa");
int li_rows=objSheet_s.UsedRange.Rows.Count;
int li_cols=objSheet_s.UsedRange.Columns.Count;
DataSet ds=new DataSet();
DataTable dt=ds.Tables.Add("aa");
string ls2=objSheet_s.Cells[1,2].ToString();
变量ls2的值是"System.__ComObject",li_rows和li_cols值都是正确的,应该如何读取表格里的内容
m_objBook=m_objExcel.Workbooks.Open(ps_filename,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing, Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
objSheets=m_objBook.Sheets;
objSheet_s=(Excel._Worksheet)objSheets.get_Item("aa");
int li_rows=objSheet_s.UsedRange.Rows.Count;
int li_cols=objSheet_s.UsedRange.Columns.Count;
DataSet ds=new DataSet();
DataTable dt=ds.Tables.Add("aa");
string ls2=objSheet_s.Cells[1,2].ToString();
变量ls2的值是"System.__ComObject",li_rows和li_cols值都是正确的,应该如何读取表格里的内容
{
……
}
while((objSheet_s.Cells[1,2] as Excel.Range).Value2.ToString()!="");
当excel的一行二列没有值时,我想让程序退出;但是总是在判断控制时出错!!