该程序可以批量的将选中.txt文件中的数据添加到同名的Excel文件中
源代码在线查看: excel批处理dlg.h
// Excel批处理Dlg.h : header file
//
#if !defined(AFX_EXCELDLG_H__C9B3CCB9_E374_4885_86B0_542E27823E2D__INCLUDED_)
#define AFX_EXCELDLG_H__C9B3CCB9_E374_4885_86B0_542E27823E2D__INCLUDED_
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
/////////////////////////////////////////////////////////////////////////////
// CExcelDlg dialog
class CExcelDlg : public CDialog
{
// Construction
public:
CExcelDlg(CWnd* pParent = NULL); // standard constructor
CString filename[200]; //定义一次最多可处理200个文件
CString listPath[200]; //定义列表框一次最多可显示200的文件
CString templetfile; //Excel模板文件
CString filepath;
int N;
char autotemplet[200];
// Dialog Data
//{{AFX_DATA(CExcelDlg)
enum { IDD = IDD_EXCEL_DIALOG };
CEdit m_edit3;
CListBox m_ListBox;
CString m_edit1;
CString m_edit2;
//}}AFX_DATA
// ClassWizard generated virtual function overrides
//{{AFX_VIRTUAL(CExcelDlg)
protected:
virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support
//}}AFX_VIRTUAL
// Implementation
protected:
HICON m_hIcon;
// Generated message map functions
//{{AFX_MSG(CExcelDlg)
virtual BOOL OnInitDialog();
afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
afx_msg void OnPaint();
afx_msg HCURSOR OnQueryDragIcon();
afx_msg void OnButton1();
afx_msg void OnButton2();
virtual void OnOK();
afx_msg HBRUSH OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor);
//}}AFX_MSG
CBrush m_brush;
afx_msg HBRUSH CtlColor(CDC*,UINT );
DECLARE_MESSAGE_MAP()
};
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.
#endif // !defined(AFX_EXCELDLG_H__C9B3CCB9_E374_4885_86B0_542E27823E2D__INCLUDED_)