cdatainputdlg.h

可以读入txt文本中的项 然后写入EXCEL 大大缓解了添加数据的繁琐。

// CDataInputDlg.h : header file
//

#if !defined(AFX_CDATAINPUTDLG_H__CA196A79_EAD5_4B7E_ABDD_6171F7F9EAC9__INCLUDED_)
#define AFX_CDATAINPUTDLG_H__CA196A79_EAD5_4B7E_ABDD_6171F7F9EAC9__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

/////////////////////////////////////////////////////////////////////////////
// CCDataInputDlg dialog

class CCDataInputDlg : public CDialog
{
// Construction
public:
	void CShowExcel();
	CStdioFile m_DataFile;
	CDatabase database;
	CString sSql;
	int m_Index;
	CString m_Contents[10];
	CString m_ContentsIndex[10];

	void CReadFile();
	CString COpenFile(CString m_Filter);
	void CreateToExcel(CString m_Content);
	void WriteToExcel(CString m_Content);
	CCDataInputDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CCDataInputDlg)
	enum { IDD = IDD_CDATAINPUT_DIALOG };
		// NOTE: the ClassWizard will add data members here
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CCDataInputDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CCDataInputDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnStore();
	afx_msg void OnShow();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_CDATAINPUTDLG_H__CA196A79_EAD5_4B7E_ABDD_6171F7F9EAC9__INCLUDED_)