2.將Excel文件保存為HTML網(wǎng)頁(yè)
sheet.SaveAs(strFileName,ColeVariant((long)44),vtMissing,...后面參數(shù)全是vtMissing);
sheet.SaveAs(strFileName,vtMissing,vtMissing,...后面參數(shù)全是vtMissing);
3.不顯示任何警告對(duì)話框
在保存文件代碼之前加上下面語(yǔ)句
m_ExlApp.SetAlertBeforeOverwriting(FALSE);
m_ExlApp.SetDisplayAlerts(FALSE);