testexceldlg.h

这是一个通过控件操作Ｅxcel表作的操作

// testExcelDlg.h : header file
//

#if !defined(AFX_TESTEXCELDLG_H__C100BC00_0709_464D_AB84_6841108F39AC__INCLUDED_)
#define AFX_TESTEXCELDLG_H__C100BC00_0709_464D_AB84_6841108F39AC__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "excel.h"
/////////////////////////////////////////////////////////////////////////////
// CTestExcelDlg dialog

class CTestExcelDlg : public CDialog
{
// Construction
public:
	CTestExcelDlg(CWnd* pParent = NULL);	// standard constructor
	_Application ExcelApp; 
	Workbooks wbsMyBooks; 
	_Workbook wbMyBook; 
	Worksheets wssMysheets; 
	_Worksheet wsMysheet; 
	Range rgMyRge; 


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

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

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CTestExcelDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
public:
	bool Test();
	bool AddHead();
	void StartExcel();


	//	_Worksheet  wsMySheet;
	//	Rang rgMyRge;
};

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

#endif // !defined(AFX_TESTEXCELDLG_H__C100BC00_0709_464D_AB84_6841108F39AC__INCLUDED_)