excel.h

&#61557 职责描述：

// Excel.h: interface for the CExcel class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_EXCEL_H__9C5A53E3_1EA3_41F6_BF1F_C7525D43FD77__INCLUDED_)
#define AFX_EXCEL_H__9C5A53E3_1EA3_41F6_BF1F_C7525D43FD77__INCLUDED_

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

#include <afxdb.h>
#include <odbcinst.h>

class CExcel  
{
public:
	CExcel();
	CExcel( CString strFile , CString strSheetOrSpread , BOOL bBackup = TRUE);
	virtual ~CExcel();

public:
	//保留
	BOOL ReadRow( CStringArray &strarray , int nRow );

	CString ReadRow( int nRow  );
	CString Read( CString &str , int nRow , int nCuloumn );
	CString Read( int nRow , int nCuloumn );

	void Commit();
	BOOL Open();						//打开数据库

	CString GetExcelDriver();			//获得驱动

	short GetTotalCuloumns();			//获得列数
	short GetTotalLows();				//获得行数

private:

	short			m_TotalColumns;		//	总列数
	short			m_TotalLows;		//  总行数

	CStringArray	m_aRows;
	CStringArray	m_aFildName;

	BOOL			m_bExcel;
	BOOL			m_bAppend;

//	CString			m_tempString ;
	CString			m_sFile;
	CString			m_sDsn;			//DSN 服务器名
	CString			m_sSheetName;	//sheet
	CString			m_sSql;			//执行SQL语句
	CString			m_sSpread;

	CString			m_sExcelDriver;	//驱动

	CDatabase		*m_pDatabase;	//数据库
	CRecordset		*m_pSet;	
};

#endif // !defined(AFX_EXCEL_H__9C5A53E3_1EA3_41F6_BF1F_C7525D43FD77__INCLUDED_)