#include "excel.h"
……
……
{
COleVariant vtOptional((long)DISP_E_PARAMNOTFOUND,
VT_ERROR),vtTrue((short)TRUE),vtFalse((short)FALSE);
_Application *ExcelApp = new _Application;
ExcelApp->CreateDispatch("excel.application");
GetTwoNum(strFilein);
filein.Open(strFilein,CFile::modeRead);
SetDlgItemText(IDC_NUM2,m_num2);
ExcelApp->SetVisible(TRUE);
Workbooks ExcelBook=ExcelApp->GetWorkbooks();
Sheets ExcelSheet=ExcelBook.Add(vtOptional);
_Workbook workBook;
_Worksheet workSheet;
Range range;
workBook.AttachDispatch(ExcelApp->GetApplication());
ExcelSheet=workBook.GetSheets();
workSheet=ExcelSheet.GetItem(COleVariant((short)1));
workSheet.Activate();
……
……
CString filepath="c://Hello.xls";
CComVariant filename=(_T(filepath));
workBook.SaveCopyAs(filename);
}
……
……
编译没有错误,运行到workBook.SaveCopyAs(filename);这句时,出现“找不到成员”,怎么解决啊?
还有想问下,用saveas那么多参数不知道怎么用啊?