3,245
社区成员
发帖
与我相关
我的任务
分享
try
{
m_pAppExcel->DisplayAlerts[0] = VARIANT_FALSE;
MSExcel::_WorksheetPtr pSheet = m_pAppExcel->ActiveSheet ;
pSheet->Delete ();
// 加载模版
strFileName = _T("D:\\Test.xml");
_bstr_t bstrFile(strFileName);
_variant_t vtXTL = bstrFile;
MSExcel::_WorkbookPtr pBook = m_pAppExcel->ActiveWorkbook;
MSExcel::SheetsPtr pSheets = pBook->GetWorksheets() ;
pSheet = pSheets->GetItem((short)1);
VARIANT varSheet;
varSheet.vt = VT_DISPATCH;
varSheet.pdispVal = pSheet;
_variant_t vtNull;
// 在最前面插入一个空Sheet表,调用成功
// pSheets->Add (varSheet ,vtMissing ,_variant_t((short)1),XlSheetType::xlWorksheet);
// 在当前位置插入一个空Sheet表,调用成功
// pSheets->Add (vtMissing ,vtMissing ,_variant_t((short)1),XlSheetType::xlWorksheet);
// 插入模版文件,插入失败
pSheets->Add (vtMissing ,vtMissing ,vtMissing,vtXTL);
m_pAppExcel->DisplayAlerts[0] = VARIANT_TRUE;
return TRUE;
}
catch(_com_error &e)
{
CString strErr = CADO::GetCOMError (e);
::MessageBox(NULL, strErr, _T("LoadXTLtoSheet - _com_error"), MB_SETFOREGROUND | MB_OK);
/*
_bstr_t bstrDescribe(e.Description());
CString strTmp = bstrDescribe;
CString strTip;
strTip = _T("严重错误。CXlOper::LoadXTLtoSheet() 错误:") + strTmp;
//*/
}
catch(...)
{
CString strTip;
strTip = _T("严重错误。CXlOper::LoadXTLtoSheet() 错误:未知错误") ;
}
return FALSE;
}
Sub LoadXLT(a As Variant)
MsgBox "Hi" & a
' Exit Sub
On Error Resume Next
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.DisplayAlerts = False
Sheets("SP").Visible = xlSheetVisible
Sheets("SP").Delete
' Sheets.Add Type:="d:\Test模版.XML"
Sheets.Add Type:="d:\Test模版.xltm"
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub