16,465
社区成员
发帖
与我相关
我的任务
分享
CChart Chart;
VARIANT variant;
CExcelManager ExcelManager;
CChartObject ChartObject;
CChartObjects ChartObjects;
COleVariant covTrue((short)TRUE), covFalse((short)FALSE), covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
ExcelManager.create_dispatch();
ExcelManager.open_books(_T("D:\\1.xlsx"));
ExcelManager.get_worksheet(1);
ChartObjects.AttachDispatch(ExcelManager.m_sheet.ChartObjects(covOptional));
long count = ChartObjects.get_Count();
variant.vt = VT_I4;
variant.lVal = 2;
ChartObject.AttachDispatch(ChartObjects.Item(variant));
VARIANT varOpt;
varOpt.vt = VT_ERROR;
varOpt.scode = DISP_E_PARAMNOTFOUND;
VARIANT v;
VariantInit(&v);
v.vt = VT_BSTR;
v.bstrVal = SysAllocString(L"JPG");
Chart.AttachDispatch(ChartObject.get_Chart());
Chart.Export(_T("D:\\image\\Debug\\2.JPG"), v, varOpt);