excelrwdlg.h

用vc操作excel表格的例子－修改表格中的公式

// ExcelRWDlg.h : header file
//

#if !defined(AFX_EXCELRWDLG_H__61E78EA7_7B66_45AF_B7AD_9EF31F9F04CD__INCLUDED_)
#define AFX_EXCELRWDLG_H__61E78EA7_7B66_45AF_B7AD_9EF31F9F04CD__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "excel9.h"

/////////////////////////////////////////////////////////////////////////////
// CExcelRWDlg dialog

class CExcelRWDlg : public CDialog
{
// Construction
public:
	_Application m_appExcel;
	Workbooks m_books;
	_Workbook m_book;
	CString m_strFileName;

	CExcelRWDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CExcelRWDlg)
	enum { IDD = IDD_EXCELRW_DIALOG };
	CString	m_strDest;
	CString	m_strSource;
	int		m_iSheetNum;
	int		m_iEndRow;
	int		m_iStartRow;
	CString	m_strEndCol;
	CString	m_strStartCol;
	//}}AFX_DATA

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CExcelRWDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnOpenfile();
	afx_msg void OnModify();
	afx_msg void OnDestroy();
	afx_msg void OnAbout();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

#endif // !defined(AFX_EXCELRWDLG_H__61E78EA7_7B66_45AF_B7AD_9EF31F9F04CD__INCLUDED_)