VS2013 MFC做的文档中英文分拣（支持xml excel text格式）屏蔽字宏 游戏便捷小程序

1、需要分拣的文档在excel表格中 对文档进行中英文分类到两个text文档中。

2、建立MFC工程设置文档工作界面（MFC文件功能设置）

3、添加按钮和文本框（MFC添加按钮和文本框步骤不在这里细说百度可得到）

4、编写相应的执行程序

// DirtyWordView.cpp : CDirtyWordView 类的实现//#include "stdafx.h"// SHARED_HANDLERS 可以在实现预览、缩略图和搜索筛选器句柄的// ATL 项目中进行定义，并允许与该项目共享文档代码。#ifndef SHARED_HANDLERS#include "DirtyWord.h"#endif#ifdef _DEBUG#define new DEBUG_NEW#endif// CDirtyWordViewIMPLEMENT_DYNCREATE(CDirtyWordView, CFormView)BEGIN_MESSAGE_MAP(CDirtyWordView, CFormView)ON_WM_CONTEXTMENU()ON_WM_RBUTTONUP()ON_BN_CLICKED(IDC_OPEN_BUTTON, &CDirtyWordView::OnBnClickedOpenButton)ON_BN_CLICKED(IDC_SAVEcf_BUTTON, &CDirtyWordView::OnBnClickedSavecfButton)ON_BN_CLICKED(IDC_SAVEef_BUTTON, &CDirtyWordView::OnBnClickedSaveefButton)ON_BN_CLICKED(IDC_Implement_BUTTON4, &CDirtyWordView::OnBnClickedImplementButton4)ON_BN_CLICKED(IDC_DISPLAYcf_BUTTON, &CDirtyWordView::OnBnClickedDisplaycfButton)ON_BN_CLICKED(IDC_DISPLAYef_BUTTON, &CDirtyWordView::OnBnClickedDisplayefButton)END_MESSAGE_MAP()// CDirtyWordView 构造/析构CDirtyWordView::CDirtyWordView(): CFormView(CDirtyWordView::IDD){// TODO:  在此处添加构造代码}CDirtyWordView::~CDirtyWordView(){}void CDirtyWordView::DoDataExchange(CDataExchange* pDX){CFormView::DoDataExchange(pDX);}BOOL CDirtyWordView::PreCreateWindow(CREATESTRUCT& cs){// TODO:  在此处通过修改//  CREATESTRUCT cs 来修改窗口类或样式return CFormView::PreCreateWindow(cs);}void CDirtyWordView::OnInitialUpdate(){CFormView::OnInitialUpdate();GetParentFrame()->RecalcLayout();ResizeParentToFit();}void CDirtyWordView::OnRButtonUp(UINT /* nFlags */, CPoint point){ClientToScreen(&point);OnContextMenu(this, point);}void CDirtyWordView::OnContextMenu(CWnd* /* pWnd */, CPoint point){#ifndef SHARED_HANDLERStheApp.GetContextMenuManager()->ShowPopupMenu(IDR_POPUP_EDIT, point.x, point.y, this, TRUE);#endif}// CDirtyWordView 诊断#ifdef _DEBUGvoid CDirtyWordView::AssertValid() const{CFormView::AssertValid();}void CDirtyWordView::Dump(CDumpContext& dc) const{CFormView::Dump(dc);}CDirtyWordDoc* CDirtyWordView::GetDocument() const // 非调试版本是内联的{ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CDirtyWordDoc)));return (CDirtyWordDoc*)m_pDocument;}#endif //_DEBUG// CDirtyWordView 消息处理程序void CDirtyWordView::OnBnClickedOpenButton(){// TODO:  在此添加控件通知处理程序代码// 设置过滤器   TCHAR szFilter[] = _T("文本文件(*.xls)|*.xls|所有文件(*.*)|*.*||");// 构造打开文件对话框   CFileDialog fileDlg(TRUE, _T("xls"), NULL, 0, szFilter, this);CString strFilePathOpen;// 显示打开文件对话框   if (IDOK == fileDlg.DoModal()){// 如果点击了文件对话框上的“打开”按钮，则将选择的文件路径显示到编辑框里   strFilePathOpen = fileDlg.GetPathName();SetDlgItemText(IDC_OPEN_EDIT, strFilePathOpen);//导入  拷贝COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);if (!app.CreateDispatch(_T("Excel.Application"))){this->MessageBox(_T("无法创建Excel应用！"));return;}books = app.get_Workbooks();//打开Excel，其中pathname为Excel表的路径名  lpDisp = books.Open(strFilePathOpen, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional);book.AttachDispatch(lpDisp);sheets = book.get_Worksheets();sheet = sheets.get_Item(COleVariant((short)1));}}void CDirtyWordView::OnBnClickedSavecfButton(){// TODO:  在此添加控件通知处理程序代码TCHAR szFilter[] = _T("文本文件(*.txt)|*.txt|Word文件(*.doc)|*.doc|所有文件(*.*)|*.*||");// 构造保存文件对话框 CFileDialog fileDlg(FALSE, _T("doc"), _T(""), OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, szFilter, this);/*CString strFilePath;*/CStdioFile file;// 显示保存文件对话框 if (IDOK == fileDlg.DoModal()){// 如果点击了文件对话框上的“保存”按钮，则将选择的文件路径显示到编辑框里 strFilePathcf = fileDlg.GetPathName();file.Open(strFilePathcf, CFile::modeCreate | CFile::modeWrite | CFile::typeText);SetDlgItemText(IDC_SAVEcf_EDIT, strFilePathcf);}}void CDirtyWordView::OnBnClickedSaveefButton(){// TODO:  在此添加控件通知处理程序代码TCHAR szFilter[] = _T("文本文件(*.txt)|*.txt|Word文件(*.doc)|*.doc|所有文件(*.*)|*.*||");// 构造保存文件对话框 CFileDialog fileDlg(FALSE, _T("doc"), _T(""), OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, szFilter, this);/*CString strFilePath;*/CStdioFile file;// 显示保存文件对话框 if (IDOK == fileDlg.DoModal()){// 如果点击了文件对话框上的“保存”按钮，则将选择的文件路径显示到编辑框里 strFilePathef = fileDlg.GetPathName();file.Open(strFilePathef, CFile::modeCreate | CFile::modeWrite | CFile::typeText);SetDlgItemText(IDC_SAVEef_EDIT, strFilePathef);}}void CDirtyWordView::OnBnClickedImplementButton4(){// TODO:  在此添加控件通知处理程序代码//建立TXT文件 cf和efCStdioFile  File;File.Open(strFilePathcf, CFile::modeCreate | CFile::modeReadWrite);//如果文件事先不存在的话，就需要CFile::modeCreate，否则就不需要。CStdioFile  File1;File1.Open(strFilePathef, CFile::modeCreate | CFile::modeReadWrite);//获得坐标为（A，2）的单元格 using namespace std;vector<CString> VecString;CString str;CString strTemp;for (int n = 2;; n++){str.Format(_T("A%d"), n);range = sheet.get_Range(COleVariant(str), COleVariant(str));COleVariant rValue;rValue = COleVariant(range.get_Value2());strTemp = rValue;/*VecString.push_back(CString(rValue.bstrVal));*/if (strTemp.IsEmpty()){break;}else{VecString.push_back(strTemp);for (int i = 0; i < VecString.size(); ++i)       //把数据从容器中取出{string strVecString(VecString[i].GetBuffer());//CString转stringwstring wstrVecString = (LPWSTR)_bstr_t(VecString[i]);//Cstring转wstringif (strVecString.size() != wstrVecString.size()){//CString tTempStr;//tTempStr.Format(_T("%s%d"), _T("A"), i + 2);for (int num = 0; num < strVecString.size(); ++num){char ch3 = VecString[i][num];char ch4 = VecString[i][num + 1];if ((int)VecString[i][num] < 0 && (int)VecString[i][num + 1] < 0){CString strFirst = VecString[i].Mid(num, 2);CString tTempStr;tTempStr.Format(_T("%s%d"), _T("B"), i + 2);CString ch5 = "|";File.WriteString("1 ");File.WriteString(VecString[i]);File.WriteString(ch5);File.WriteString(strFirst);File.WriteString("\n");break;}}}else  //非汉字的输出到D列{CString tTempStr;tTempStr.Format(_T("%s%d"), _T("D"), i + 2);File1.WriteString(strTemp);File1.WriteString("\n");}}//释放Vectorvector<CString>().swap(VecString);}}MessageBox("已经加载完毕");}void CDirtyWordView::OnBnClickedDisplaycfButton(){// TODO:  在此添加控件通知处理程序代码ShellExecute(NULL, _T("open"), _T(strFilePathcf), NULL, NULL, SW_SHOW);}void CDirtyWordView::OnBnClickedDisplayefButton(){// TODO:  在此添加控件通知处理程序代码ShellExecute(NULL, _T("open"), _T(strFilePathef), NULL, NULL, SW_SHOW);}void CDirtyWordView::CString_Find(CString CString_Word){using namespace std;vector<CString> VecString;VecString.push_back(CString_Word);for (int i = 0; i < VecString.size(); ++i)                   //把数据从容器中取出{string strVecString(VecString[i].GetBuffer());     //CString转stringwstring wstrVecString = (LPWSTR)_bstr_t(VecString[i]);   //Cstring转wstringif (strVecString.size() != wstrVecString.size())         //字符串作对比不相等含有中文{for (int num = 0; num < strVecString.size(); ++num)  //逐个遍历Vector里面的元素{char ch3 = VecString[i][num];char ch4 = VecString[i][num + 1];if ((int)VecString[i][num] > 0 /*&& (int)VecString[i][num + 1] < 0*/) //当相邻的两个元素都小于0则为中文{vector<char> VecString_English;VecString_English.push_back(VecString[i][num]);}}}}//释放Vectorvector<CString>().swap(VecString);}

5、运行程序选取文档并选取输出文档的路径

6、执行