exampleview.cpp

通过本文及配套示例源码你可以更加灵活的控制Excel表格文件

// ExampleView.cpp : implementation of the CExampleView class
//

#include "stdafx.h"
#include "Example.h"

#include "ExampleDoc.h"
#include "ExampleView.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CExampleView

IMPLEMENT_DYNCREATE(CExampleView, CView)

BEGIN_MESSAGE_MAP(CExampleView, CView)
	//{{AFX_MSG_MAP(CExampleView)
	ON_COMMAND(ID_CREAT_EXCEL, OnCreatExcel)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CExampleView construction/destruction

CExampleView::CExampleView()
{
	// TODO: add construction code here

}

CExampleView::~CExampleView()
{
}

BOOL CExampleView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// CExampleView drawing

void CExampleView::OnDraw(CDC* pDC)
{
	CExampleDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	// TODO: add draw code for native data here
}

/////////////////////////////////////////////////////////////////////////////
// CExampleView printing

BOOL CExampleView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CExampleView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CExampleView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CExampleView diagnostics

#ifdef _DEBUG
void CExampleView::AssertValid() const
{
	CView::AssertValid();
}

void CExampleView::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

CExampleDoc* CExampleView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CExampleDoc)));
	return (CExampleDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CExampleView message handlers

void CExampleView::OnCreatExcel() 
{
	// TODO: Add your command handler code here
	CDatabase m_database;
	CString strDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; // Excel安装驱动
	CString strExcelFile = "D:\\ExcelFile.xls";// 要建立的Excel文件
	CString strSQL;
	
	TRY
	{
		// 创建进行存取的字符串
		strSQL.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",
			strDriver,strExcelFile,strExcelFile);
		
		// 创建数据库 (既Excel表格文件)
		if( m_database.OpenEx(strSQL,CDatabase::noOdbcDialog) )
		{
			// 创建表结构(姓名、年龄)			
			strSQL = "CREATE TABLE Table1 (StuName TEXT,StuCourse TEXT,StuScore NUMBER)";
			m_database.ExecuteSQL(strSQL);
			
			// 插入数值
			strSQL = "INSERT INTO Table1 (StuName,StuCourse,StuScore) VALUES ('张三','数学',80)";
			m_database.ExecuteSQL(strSQL);
			strSQL = "INSERT INTO Table1 (StuName,StuCourse,StuScore) VALUES ('李四','数学',85)";
			m_database.ExecuteSQL(strSQL);
			strSQL = "INSERT INTO Table1 (StuName,StuCourse,StuScore) VALUES ('王五','数学',78)";
			m_database.ExecuteSQL(strSQL);
			strSQL = "INSERT INTO Table1 (StuName,StuCourse,StuScore) VALUES ('钱六','数学',69.5)";
			m_database.ExecuteSQL(strSQL);

		}
		// 关闭数据库
		m_database.Close();
	}
	CATCH_ALL(e)
	{
		TRACE1("Excel驱动没有安装: %s",strDriver);
	}
	END_CATCH_ALL;
	AfxMessageBox("创建数据库成功!!\n表中包含三个字段分别为\nStuName,StuCourse,StuScore");
	
}

CString CExampleView::GetExcelDriver()
{
	char szBuf[2001];
	WORD cbBufMax = 2000;
	WORD cbBufOut;
	char *pszBuf = szBuf;
	CString sDriver;
	// 获取已安装驱动的名称(涵数在odbcinst.h里)
	if (!SQLGetInstalledDrivers(szBuf, cbBufMax, &cbBufOut))
		return "";
	// 检索已安装的驱动是否有Excel...
	do
	{
		if (strstr(pszBuf, "Excel") != 0)
		{
			//发现 !
			sDriver = CString(pszBuf);
			break;
		}
		pszBuf = strchr(pszBuf, '\0') + 1;
	}
	while (pszBuf[1] != '\0');
	return sDriver;


}