16,371
社区成员




CSpreadSheet::CSpreadSheet(CString File, CString SheetOrSeparator, bool Backup) :
m_Database(NULL), m_rSheet(NULL), m_sFile(File),
m_dTotalRows(0), m_dTotalColumns(0), m_dCurrentRow(1),
m_bAppend(false), m_bBackup(Backup), m_bTransaction(false)
{
// Detect whether file is an Excel spreadsheet or a text delimited file
m_stempString = m_sFile.Right(4);
m_stempString.MakeLower();
if (m_stempString == _T(".xls")) // File is an Excel spreadsheet
{
m_bExcel = true;
m_sSheetName = SheetOrSeparator;
m_sSeparator = _T(",;.?");
}
else // File is a text delimited file
{
m_bExcel = false;
m_sSeparator = SheetOrSeparator;
}
if (m_bExcel) // If file is an Excel spreadsheet
{
m_Database = new CDatabase;
GetExcelDriver();
m_sDsn.Format(_T("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s"), m_sExcelDriver, m_sFile, m_sFile);
if (Open())
{
if (m_bBackup)
{
if ((m_bBackup) && (m_bAppend))
{
CString tempSheetName = m_sSheetName;
m_sSheetName = _T("CSpreadSheetBackup");
m_bAppend = false;
if (!Commit())
{
m_bBackup = false;
}
m_bAppend = true;
m_sSheetName = tempSheetName;
m_dCurrentRow = 1;
}
}
}
}
else // if file is a text delimited file
{
if (Open())
{
if ((m_bBackup) && (m_bAppend))
{
m_stempString = m_sFile;
m_stempSql.Format(_T("%s.bak"), m_sFile);
m_sFile = m_stempSql;
if (!Commit())
{
m_bBackup = false;
}
m_sFile = m_stempString;
}
}
}
}
#ifndef __CSPEADSHEET__
#define __CSPEADSHEET__
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
#endif
或者:
#pragma once
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
[/quote]
这个里面已经加过了[/quote]
我还不信那卸了!你贴出这个头文件让我们看看[/quote]
太长了发不了,给个邮箱,我给你发过去
#ifndef __CSPEADSHEET__
#define __CSPEADSHEET__
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
#endif
或者:
#pragma once
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
[/quote]
这个里面已经加过了[/quote]
我还不信那卸了!你贴出这个头文件让我们看看
#ifndef __CSPEADSHEET__
#define __CSPEADSHEET__
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
#endif
或者:
#pragma once
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
[/quote]
这个里面已经加过了
#ifndef __CSPEADSHEET__
#define __CSPEADSHEET__
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};
#endif
或者:
#pragma once
class CSpeadsheet
{
CSpeadsheet() {}
~CSpeadsheet() {}
//
//
};