之前用mfc对excel操作时,想把新建的sheet加在某sheet后面,经过了很多尝试才成功。把解决方法记录一下:
CWorksheet ws=m_Sheets.get_Item(COleVariant((short)4));
_variant_t p1(ws.m_lpDispatch);
m_Sheets.Add(m_covOptional, p1, COleVariant((short)1), COleVariant((short)SheetType));
之前用mfc对excel操作时,想把新建的sheet加在某sheet后面,经过了很多尝试才成功。把解决方法记录一下:
CWorksheet ws=m_Sheets.get_Item(COleVariant((short)4));
_variant_t p1(ws.m_lpDispatch);
m_Sheets.Add(m_covOptional, p1, COleVariant((short)1), COleVariant((short)SheetType));