excel.h

在BCB环境下

//---------------------------------------------------------------------------

#ifndef ExcelH
#define ExcelH
//---------------------------------------------------------------------------
//注意工程中头文件的包含顺序，须在OFFICE控件相关的头文件之前。

#include "ResultParams.h"
#include "UFrmDSTest.h"
//------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include "Excel_2K_SRVR.h"
#include <OleServer.hpp>
//---------------------------------------------------------------------------
#include <assert.h>
#include <vector.h>
//---------------------------------------------------------------------------

#include "ResultParams.h"
//---------------------------------------------------------------------------

class TExcelReport : public TForm
{
__published:	// IDE-managed Components
    TExcelApplication *ExcelApplication1;
    TExcelWorkbook *ExcelWorkbook1;
    TExcelWorksheet *ExcelWorksheet1;
    void __fastcall FormClose(TObject *Sender, TCloseAction &Action);
private:	// User declarations

	//--------------------------------------------------------------
	UINT Row, Col;
	String sValue;
	String sSavePath;
	bool bSMS, bData, bDataIT, bFitful;
	UINT SheetIndex;
	//------------------------------------------------------------
        bool OpenExcel(const String ExcelName);
        bool SaveExcel(String FileName, bool bNotes);
        void SetCell(UINT  row, UINT col, String value, UINT backcolor, bool bmerge, bool bInit);
	 void InitRowCol();
	 void TransferDBToChar(double time, char *c_time);
	 bool NoResult();

	 void HideSheet(String SheetName, String ActiveSheet, UINT USheetIndex);
        //-------------------------------------
        void OutputSMSResult();
	  void OutputDataResult();
	  void OutputDataITResult();
	  void OutputPicture(UINT type);
	  void OutputFitfulResult();
        //-----------------------------------------
public:		// User declarations
    __fastcall TExcelReport(TComponent* Owner);

	//------------------------------------------------------------------
	vector<TSendResult>   m_vSMSTestResult; 
	//---------------------------------------------------------------------
	vector<TDSTestPlanItems> m_vTDSTestResult;
	vector<PicData> m_vPictureData;
	//------------------------------------------------------------------

	FtpTestSet m_FtpITResult; //数据业务的交互测试结果
   	DataITStrc m_DataITResult;//新的数据交互测试结果

      //----------------------------------------------------------
	
	vector<TDSTestPlanItems> m_vFitfulResult;
	vector<PicData> m_vFitfulPicData;
	PPPvsAdvFTPTestParam m_FitfulTestResult; //断点续传测试结果
	//------------------------------------------------------------------
	void OutputReport();
	void FillValueAndColor(UINT uRow, UINT uCol, String sValue, UINT cColor, bool bMerge);
    //------------------------------------------------------------------
};
//---------------------------------------------------------------------------
extern PACKAGE TExcelReport *ExcelReport;
//---------------------------------------------------------------------------
#endif