You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
|
|
#pragma once
|
|
|
|
|
|
|
|
|
|
#include "ExcelEngine.h"
|
|
|
|
|
|
|
|
|
|
// 对Excel应用的再次封装
|
|
|
|
|
class I_PLUGIN_EXPORT ExcelUtils
|
|
|
|
|
{
|
|
|
|
|
public:
|
|
|
|
|
|
|
|
|
|
ExcelUtils();
|
|
|
|
|
~ExcelUtils();
|
|
|
|
|
|
|
|
|
|
public:
|
|
|
|
|
/// @brief Excel数据加载至VVec
|
|
|
|
|
bool loadExcel(VVecVariant& vvecData, QStringList* pVecTitles, QString& sFile, QString& sLog,
|
|
|
|
|
int nRowFrom = 1, int nColFrom = 1,
|
|
|
|
|
int nSheetIndex = 1, QString sSheetName = "");
|
|
|
|
|
|
|
|
|
|
/// @brief VVec数据存至Excel
|
|
|
|
|
bool saveExcel(VVecVariant vvecData, QStringList* pVecTitles, QString& sFile, QString& sLog,
|
|
|
|
|
int nRowFrom = 1, int nColFrom = 1,
|
|
|
|
|
int nSheetIndex = 1, QString sSheetName = "");
|
|
|
|
|
|
|
|
|
|
/// @brief 检测(或复制)Excel文件
|
|
|
|
|
bool checkExcelFile(QString sFile, QString& sLog);
|
|
|
|
|
|
|
|
|
|
private:
|
|
|
|
|
|
|
|
|
|
ExcelEngine* m_pExcelEngine;
|
|
|
|
|
};
|
|
|
|
|
|
|
|
|
|
|