_Application *ExcelApp = new _Application;
int m_nSucess=ExcelApp->CreateDispatch("excel.application",NULL);
if(m_nSucess)
{
//创建失败.
return 0;
}
//设置为显示
ExcelApp->SetVisible(false);
//得到WorkBooks
Workbooks ExcelBook=ExcelApp->GetWorkbooks();
_Workbook workBook=ExcelBook.Add(_variant_t("E:\\Data\\地火行动收益统计报表.xls"));
workBook.AttachDispatch(ExcelApp->GetApplication());
workBook.SetAutoUpdateSaveChanges(true);Sheets ExcelSheet=workBook.GetSheets();
_Worksheet workSheet;
workSheet=ExcelSheet.GetItem(_variant_t("1日"));
workSheet.Activate();Range myallrange;//=workSheet.GetRange(COleVariant("A1"),COleVariant("A1");
myallrange=workSheet.GetCells();
myallrange.SetItem(_variant_t((short) 1),_variant_t((short) 1),_variant_t("这里写标题11"));
myallrange.SetItem(_variant_t((short) 1),_variant_t((short) 2),_variant_t("这里写标题12"));
myallrange.SetItem(_variant_t((short) 2),_variant_t((short) 1),_variant_t("这里写标题21"));
myallrange.SetItem(_variant_t((short) 2),_variant_t((short) 2),_variant_t("这里写标题22"));
myallrange.SetItem(_variant_t((short) 3),_variant_t((short) 1),_variant_t("这里写标题31"));
myallrange.SetItem(_variant_t((short) 3),_variant_t((short) 2),_variant_t("这里写标题32"));
myallrange.SetItem(_variant_t((short) 4),_variant_t((short) 1),_variant_t("这里写标题41"));
myallrange.SetItem(_variant_t((short) 4),_variant_t((short) 2),_variant_t("这里写标题42"));
int m_nSucess=ExcelApp->CreateDispatch("excel.application",NULL);
if(m_nSucess)
{
//创建失败.
return 0;
}
//设置为显示
ExcelApp->SetVisible(false);
//得到WorkBooks
Workbooks ExcelBook=ExcelApp->GetWorkbooks();
_Workbook workBook=ExcelBook.Add(_variant_t("E:\\Data\\地火行动收益统计报表.xls"));
workBook.AttachDispatch(ExcelApp->GetApplication());
workBook.SetAutoUpdateSaveChanges(true);Sheets ExcelSheet=workBook.GetSheets();
_Worksheet workSheet;
workSheet=ExcelSheet.GetItem(_variant_t("1日"));
workSheet.Activate();Range myallrange;//=workSheet.GetRange(COleVariant("A1"),COleVariant("A1");
myallrange=workSheet.GetCells();
myallrange.SetItem(_variant_t((short) 1),_variant_t((short) 1),_variant_t("这里写标题11"));
myallrange.SetItem(_variant_t((short) 1),_variant_t((short) 2),_variant_t("这里写标题12"));
myallrange.SetItem(_variant_t((short) 2),_variant_t((short) 1),_variant_t("这里写标题21"));
myallrange.SetItem(_variant_t((short) 2),_variant_t((short) 2),_variant_t("这里写标题22"));
myallrange.SetItem(_variant_t((short) 3),_variant_t((short) 1),_variant_t("这里写标题31"));
myallrange.SetItem(_variant_t((short) 3),_variant_t((short) 2),_variant_t("这里写标题32"));
myallrange.SetItem(_variant_t((short) 4),_variant_t((short) 1),_variant_t("这里写标题41"));
myallrange.SetItem(_variant_t((short) 4),_variant_t((short) 2),_variant_t("这里写标题42"));
解决方案 »
- VC 我想在图像控件里加载一幅位图,但是这幅位图只占用图像控件的某一部分区域,而不是全部填充上位图,请问如何操作?
- 没办法 得做个广告
- 基于对话框,启动最大化的问题。
- 如何把数据内容显示到文本框中?(关于dbgrid和remotedata的)
- 有人编写过WINDOWS下的驱动的吗?例如网卡之类的!高手请进!
- 不相关的数组总会造成覆盖(CFile对文件进行操作)
- 请问有没有能在Windows 2000下使用的PQMagic?
- 求vc++ 中 ipx接收数据例子
- stdlib.h(342): error C2061: 语法错误: 标识符“_CountofType”
- 父对话框传递初始化参数问题,求教
- 编译一个win32动态连接库,debug下无错误无警告,release下无错误但有三个警告
- Vc调用EXCEL后如何保存或是另存?
**wbMyBook.SetSaved(true);