vc2010调用excel.docx

#include"stdafx.h"
#include"ReadWriteExcel.h"
#include"ReadWriteExcelDlg.h"
#include"DlgProxy.h"
#include"afxdialogex.h"

#ifdef_DEBUG
#definenewDEBUG_NEW
#endif

//CReadWriteExcelDlgdialog

intRow,Line;
CStringContent;

IMPLEMENT_DYNAMIC(CReadWriteExcelDlg,CDialogEx);

CReadWriteExcelDlg::CReadWriteExcelDlg(CWnd*pParent/*=NULL*/)
:CDialogEx(CReadWriteExcelDlg::IDD,pParent)
,m_line(_T(""))
,m_row(_T(""))
{
m_hIcon=AfxGetApp()->LoadIcon(IDR_MAINFRAME);
m_pAutoProxy=NULL;
}

CReadWriteExcelDlg::~CReadWriteExcelDlg()
{
//Ifthereisanautomationproxyforthisdialog,set
//itsbackpointertothisdialogtoNULL,soitknows
//thedialoghasbeendeleted.
if(m_pAutoProxy!=NULL)
m_pAutoProxy->m_pDialog=NULL;
}

voidCReadWriteExcelDlg::DoDataExchange(CDataExchange*pDX)
{
CDialogEx::DoDataExchange(pDX);
DDX_Text(pDX,IDC_EDIT1,m_line);
DDX_Text(pDX,IDC_EDIT2,m_row);
DDX_Text(pDX,IDC_EDIT3,m_content);
DDX_Control(pDX,IDC_LIST1,m_Grid);
}

BEGIN_MESSAGE_MAP(CReadWriteExcelDlg,CDialogEx)
ON_WM_CLOSE()
ON_WM_PAINT()
ON_WM_QUERYDRAGICON()
ON_BN_CLICKED(IDC_creat,&CReadWriteExcelDlg::OnBnClickedcreat)
ON_BN_CLICKED(IDC_write,&CReadWriteExcelDlg::OnBnClickedwrite)
ON_BN_CLICKED(IDC_read,&CReadWriteExcelDlg::OnBnClickedread)
END_MESSAGE_MAP()

//CReadWriteExcelDlgmessagehandlers

BOOLCReadWriteExcelDlg::OnInitDialog()
{
CDialogEx::OnInitDialog();

//Settheiconforthisdialog.Theframeworkdoesthisautomatically
//whentheapplication'smainwindowisnotadialog
SetIcon(m_hIcon,TRUE); //Setbigicon
SetIcon(m_hIcon,FALSE); //Setsmallicon

//TODO:Addextrainitializationhere

//设¦¨¨置?列¢D表À¨ª视º¨®图ª?的Ì?扩¤?展1风¤?格?
m_Grid.SetExtendedStyle(LVS_EX_FLATSB //扁Àa平?风¤?格?显?示º?滚?动¡¥条¬?
|LVS_EX_FULLROWSELECT //允¨º许¨ª整?行D选?中D
|LVS_EX_HEADERDRAGDROP //允¨º许¨ª整?列¢D拖ª?动¡¥
|LVS_EX_ONECLICKACTIVATE //单Ì£¤击¡Â选?中D项?
|LVS_EX_GRIDLINES); //画-出?网ª?格?线?
//设¦¨¨置?表À¨ª头ª¡¤
m_Grid.InsertColumn(0,_T("A"),LVCFMT_LEFT,50);
m_Grid.InsertColumn(1,_T("B"),LVCFMT_LEFT,50);
m_Grid.Inse