定义了两个editbox【IDC_EDIT2,IDC_EDIT3】用来收集姓名和事件,两个按钮【IDC_BUTTON1,IDC_BUTTON2】用来搜索和保存。
读excel:
CApplication app; //Excel程序
CWorkbooks books; //工作簿集合
CWorkbook book; //工作簿
CWorksheets sheets; //工作表集合
CWorksheet sheet; //工作表
CRange range; //使用区域
//获取IDC_EDIT1的值
CString inputInfo;
CString outputInfo;
GetDlgItem(IDC_EDIT2)->GetWindowText(inputInfo);
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
if (!app.CreateDispatch(_T("Excel.Application")))
{
MessageBox(_T("Error!Creat Excel Application Server Fail!"));
exit(1);
}
CString strPath = _T("C:\\test.xlsx");
books.AttachDispatch(app.get_Workbooks(), true);
book.AttachDispatch(books.Add(_variant_t(strPath)));//获取选择的Excel文件
sheets.AttachDispatch(book.get_Worksheets(), true);//获取文件中的所有sheet
sheet.AttachDispatch(sheets.get_Item(_variant_t("sheet1")), true);//获取sheet1区域
CString str;
bool bExit = false;
for (int irow =