把CListCtrl的内容导出到Excel里面,然后怎么让Excel自动保存?
我的代码是:
COleVariant VOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
_Application objApp;
Workbooks objBooks;
_Workbook objBook;
Worksheets objSheets;
_Worksheet objSheet;
Range objRange;
//创建Excel对象
objApp.CreateDispatch("Excel.Application");
objBooks = objApp.GetWorkbooks();
//打开指定的Excel文件
objBook.AttachDispatch(objBooks.Add(_variant_t("c:\\Report1.xls")));
objSheets = objBook.GetSheets();
//定义一个sheet为对象
objSheet = objSheets.GetItem((_variant_t)(short(1)));
objRange.AttachDispatch(objSheet.GetCells(),true);
//取得结果集中记录的个数,列数
int ss,nn;
double dTotal;
dTotal = 0;
CString cc;
//得到结果集中记录个数
nn = m_ListCtrl.GetItemCount();
ss = 5;
for(int i=0;i<nn;i++)
{
//设定数据所在行
for(int j = 0 ;j < ss; j++)
{
cc = m_ListCtrl.GetItemText(i,j);
if(j == 5)
dTotal = dTotal + atoi(cc);
objRange.SetItem(_variant_t((long)(i+2)),_variant_t((long)(j+1)),_variant_t(cc));
}
}
objApp.SetVisible(true);
//释放句柄
objRange.ReleaseDispatch();
objSheet.ReleaseDispatch();
objSheets.ReleaseDispatch();
objBook.ReleaseDispatch();
objBooks.ReleaseDispatch();
objApp.ReleaseDispatch();
return;
操作完EXcel后,不会自动保存,怎么办?
还有,如何追加到原来的Excel里面?