赋值到excel表,从excel表取值

//赋值

range=sheet.get_Range(COleVariant(str2),COleVariant(str2));
                switch(ColumNum){//把值写到excel表中
             case 1:
                    str.Format(_T("%hu"),step.nSeqID);
              break;
             case 2:
                    str.Format(_T("%c"),step.ucType);
                    break;

range.put_Value2(COleVariant(str));

 

//取值

 COleVariant rValue;//获取excel单元格的值
 range=sheet.get_Range(COleVariant(str2),COleVariant(str2));
 rValue = COleVariant(range.get_Value2());
 step.nSeqID = V_R8(&rValue);