GKODBCExcelController Class Reference

Public Member Functions
	GKODBCExcelController (const QString &dataBaseName)
	~GKODBCExcelController ()
bool	open (const QString &excelFilePath)
void	close ()
QList< QStringList >	readExcelSubTable (const QString &sheetName, const QString &startCell, const QString &endCell) const

Constructor & Destructor Documentation

GKODBCExcelController()

GKODBCExcelController::GKODBCExcelController

(

const QString &

dataBaseName

)

~GKODBCExcelController()

GKODBCExcelController::~GKODBCExcelController

(

)

Member Function Documentation

close()

void GKODBCExcelController::close

(

)

Close the ODBC DataBase.

open()

bool GKODBCExcelController::open

(

const QString &

excelFilePath

)

Open the ODBC DataBase.

readExcelSubTable()

QList< QStringList > GKODBCExcelController::readExcelSubTable	(	const QString &	sheetName,
		const QString &	startCell,
		const QString &	endCell
	)		const

Read an Excel Subtable. Example: getExcelSubTable( "Sheet1", "A1", "B5" ) Return: res[excelRowIndex][excelColumnIndex], the index (0, 0) is the top left cell of the subtable.