tmsuexceladapter.hpp

TMS Component Pack V5.0包含了超过 280 个为 Delphi 以及 C++Builder 设计的 TMS 生产控件

	__property int PrintCopies = {read=GetPrintCopies, write=SetPrintCopies, nodefault};
	__property int PrintXResolution = {read=GetPrintXResolution, write=SetPrintXResolution, nodefault};
	__property int PrintYResolution = {read=GetPrintYResolution, write=SetPrintYResolution, nodefault};
	__property Tmsuflxmessages::TPrinterDriverSettings PrinterDriverSettings = {read=GetPrinterDriverSettings, write=SetPrinterDriverSettings};
	virtual void __fastcall DeleteMarkedRows(const WideString Mark) = 0 ;
	virtual void __fastcall MakePageBreaks(const WideString Mark) = 0 ;
	virtual void __fastcall InsertHPageBreak(const int Row) = 0 ;
	virtual void __fastcall InsertVPageBreak(const int Col) = 0 ;
	virtual void __fastcall DeleteHPageBreak(const int Row) = 0 ;
	virtual void __fastcall DeleteVPageBreak(const int Col) = 0 ;
	virtual bool __fastcall HasHPageBreak(const int Row) = 0 ;
	virtual bool __fastcall HasVPageBreak(const int Col) = 0 ;
	virtual void __fastcall RefreshPivotTables(void) = 0 ;
	virtual void __fastcall RefreshChartRanges(const WideString VarStr) = 0 ;
	virtual void __fastcall Save(const bool AutoClose, const AnsiString FileName, const Tmsuflxmessages::TOnGetFileNameEvent OnGetFileName, const Tmsuflxmessages::TOnGetOutStreamEvent OnGetOutStream = 0x0, const Classes::TStream* DataStream = (Classes::TStream*)(0x0)) = 0 ;
	virtual void __fastcall InsertAndCopyRows(const int FirstRow, const int LastRow, const int DestRow, const int aCount, const bool OnlyFormulas) = 0 ;
	virtual void __fastcall InsertAndCopyCols(const int FirstCol, const int LastCol, const int DestCol, const int aCount, const bool OnlyFormulas) = 0 ;
	virtual void __fastcall DeleteRows(const int aRow, const int aCount) = 0 ;
	virtual void __fastcall DeleteCols(const int aCol, const int aCount) = 0 ;
	virtual void __fastcall BeginSheet(void) = 0 ;
	virtual void __fastcall EndSheet(const int RowOffset) = 0 ;
	virtual bool __fastcall CanOptimizeRead(void) = 0 ;
	__property int RangeCount = {read=GetExcelNameCount, nodefault};
	__property WideString RangeName[int index] = {read=GetRangeName};
	__property int RangeR1[int index] = {read=GetRangeR1, write=SetRangeR1};
	__property int RangeR2[int index] = {read=GetRangeR2, write=SetRangeR2};
	__property int RangeC1[int index] = {read=GetRangeC1, write=SetRangeC1};
	__property int RangeC2[int index] = {read=GetRangeC2, write=SetRangeC2};
	__property int RangeSheet[int index] = {read=GetRangeSheet};
	virtual void __fastcall AddRange(Tmsuflxmessages::TXlsNamedRange &NamedRange) = 0 ;
	__property int PicturesCount[int Row] = {read=GetPicturesCount};
	__property WideString PictureName[int Row][int aPos] = {read=GetPictureName};
	virtual void __fastcall AssignPicture(const int Row, const int aPos, const Tmsuflxmessages::ByteArray Pic, const Tmsuflxmessages::TXlsImgTypes PicType) = 0 /* overload */;
	virtual void __fastcall AssignPicture(const int Row, const int aPos, const Tmsuflxmessages::ByteArray Pic, const Tmsuflxmessages::TXlsImgTypes PicType, const Tmsuflxmessages::TImageProperties &Props, const Tmsuflxmessages::TFlxAnchorType Anchor = (Tmsuflxmessages::TFlxAnchorType)(0x1)) = 0 /* overload */;
	virtual void __fastcall AssignPictureProperties(const int Row, const int aPos, const Tmsuflxmessages::TImageProperties &Props, const Tmsuflxmessages::TFlxAnchorType Anchor = (Tmsuflxmessages::TFlxAnchorType)(0x1)) = 0 ;
	virtual void __fastcall GetPicture(const int Row, const int aPos, const Classes::TStream* Pic, /* out */ Tmsuflxmessages::TXlsImgTypes &PicType, /* out */ Tmsuflxmessages::TClientAnchor &Anchor) = 0 ;
	virtual void __fastcall DeleteImage(const int Index) = 0 ;
	virtual void __fastcall ClearImage(const int Index) = 0 ;
	virtual void __fastcall AddImage(const Tmsuflxmessages::ByteArray Data, const Tmsuflxmessages::TXlsImgTypes DataType, const Tmsuflxmessages::TImageProperties &Properties, const Tmsuflxmessages::TFlxAnchorType Anchor) = 0 ;
	__property int CommentsCount[int Row] = {read=GetCommentsCount};
	__property WideString CommentText[int Row][int aPos] = {read=GetCommentText};
	__property int CommentColumn[int Row][int aPos] = {read=GetCommentColumn};
	virtual void __fastcall AssignComment(const int Row, const int aPos, const WideString Comment) = 0 ;
	virtual void __fastcall SetCellComment(int Row, int Col, const WideString Value, const Tmsuflxmessages::TImageProperties &Properties) = 0 ;
	virtual WideString __fastcall GetCellComment(int Row, int Col) = 0 ;
	virtual int __fastcall CellCount(const int aRow) = 0 ;
	virtual Variant __fastcall GetCellData(const int aRow, const int aColOffset) = 0 ;
	virtual Tmsuflxmessages::TXlsCellValue __fastcall GetCellDataX(const int aRow, const int aColOffset) = 0 ;
	virtual void __fastcall GetCellDataX2(const int aRow, const int aColOffset, /* out */ Tmsuflxmessages::TXlsCellValue &v, /* out */ Tmsuflxmessages::TRTFRunList &RTFRuns) = 0 ;
	virtual void __fastcall AssignCellData(const int aRow, const int aColOffset, const Variant &Value) = 0 ;
	virtual void __fastcall AssignCellDataX(const int aRow, const int aColOffset, const Tmsuflxmessages::TXlsCellValue &Value) = 0 ;
	virtual void __fastcall AssignCellDataX2(const int aRow, const int aColOffset, const Tmsuflxmessages::TXlsCellValue &Value, const Tmsuflxmessages::TRTFRunList RTFRuns) = 0 ;
	virtual void __fastcall GetCellValueX2(int aRow, int aCol, /* out */ Tmsuflxmessages::TXlsCellValue &v, /* out */ Tmsuflxmessages::TRTFRunList &RTFRuns) = 0 ;
	virtual void __fastcall AssignCellValueX2(int aRow, int aCol, const Tmsuflxmessages::TXlsCellValue &Value, const Tmsuflxmessages::TRTFRunList RTFRuns) = 0 ;
	virtual void __fastcall SetCellString(const int aRow, const int aCol, const WideString Text, const WideString DateFormat = L"", const WideString TimeFormat = L"") = 0 /* overload */;
	virtual void __fastcall SetCellString(const int aRow, const int aCol, const WideString Text, const Tmsuflxformats::TFlxFormat &Fm, const WideString DateFormat = L"", const WideString TimeFormat = L"") = 0 /* overload */;
	virtual int __fastcall MaxRow(void) = 0 ;
	virtual int __fastcall MaxCol(void) = 0 ;
	virtual bool __fastcall IsEmptyRow(const int aRow) = 0 ;
	__property Variant CellValue[int aRow][int aCol] = {read=GetCellValue, write=SetCellValue};
	__property Tmsuflxmessages::TXlsCellValue CellValueX[int aRow][int aCol] = {read=GetCellValueX, write=SetCellValueX};
	__property int CellFormat[int aRow][int aCol] = {read=GetCellFormat, write=SetCellFormat};
	__property WideString CellFormula[int aRow][int aCol] = {read=GetCellFormula, write=SetCellFormula};
	virtual void __fastcall SetCellFormulaX(int aRow, int aCol, const WideString Formula, const Variant &Value) = 0 ;
	virtual int __fastcall ColByIndex(const int Row, const int ColIndex) = 0 ;
	virtual int __fastcall ColIndexCount(const int Row) = 0 ;
	virtual int __fastcall ColIndex(const int Row, const int Col) = 0 ;
	__property int ColumnWidth[int aCol] = {read=GetColumnWidth, write=SetColumnWidth};
	__property int ColumnWidthHiddenIsZero[int aCol] = {read=GetColumnWidthHiddenIsZero};
	__property int RowHeight[int aRow] = {read=GetRowHeight, write=SetRowHeight};
	__property int RowHeightHiddenIsZero[int aRow] = {read=GetRowHeight};
	__property bool ColumnHidden[int aCol] = {read=GetColumnHidden, write=SetColumnHidden};
	__property bool RowHidden[int aRow] = {read=GetRowHidden, write=SetRowHidden};
	__property int DefaultColWidth = {read=GetDefaultColWidth, nodefault};
	__property int DefaultRowHeight = {read=GetDefaultRowHeight, nodefault};
	__property int ColumnFormat[int aColumn] = {read=GetColumnFormat, write=SetColumnFormat};
	__property int RowFormat[int aRow] = {read=GetRowFormat, write=SetRowFormat};
	virtual void __fastcall SetBounds(const int aRangePos) = 0 ;
	virtual int __fastcall GetFirstColumn(void) = 0 ;
	virtual void __fastcall PrepareBlockData(const int R1, const int C1, const int R2, const int C2) = 0 ;
	virtual void __fastcall AssignBlockData(const int Row, const int Col, const Variant &v) = 0 ;
	virtual void __fastcall PasteBlockData(void) = 0 ;
	virtual bool __fastcall IsWorksheet(const int index) = 0 ;
	__property bool AutoRowHeight[int Row] = {read=GetAutoRowHeight, write=SetAutoRowHeight};
	__property unsigned ColorPalette[Tmsuflxmessages::TColorPaletteRange Index] = {read=GetColorPalette, write=SetColorPalette};
	virtual Tmsuflxmessages::BooleanArray __fastcall GetUsedPaletteColors(void) = 0 ;
	__property Tmsuflxformats::TFlxFont FontList[int index] = {read=GetFontList, write=SetFontList};
	virtual int __fastcall FontListCount(void) = 0 ;
	__property Tmsuflxformats::TFlxFormat FormatList[int index] = {read=GetFormatList, write=SetFormatList};
	virtual int __fastcall FormatListCount(void) = 0 ;
	virtual int __fastcall AddFormat(const Tmsuflxformats::TFlxFormat &Fmt) = 0 ;
	virtual int __fastcall AddFont(const Tmsuflxformats::TFlxFont &Fmt) = 0 ;
	__property Tmsuflxmessages::TXlsCellRange CellMergedBounds[int aRow][int aCol] = {read=GetCellMergedBounds};
	virtual void __fastcall MergeCells(const int FirstRow, const int FirstCol, const int LastRow, const int LastCol) = 0 ;
	virtual void __fastcall UnMergeCells(const int FirstRow, const int FirstCol, const int LastRow, const int LastCol) = 0 ;
	virtual int __fastcall CellMergedListCount(void) = 0 ;
	__property Tmsuflxmessages::TXlsCellRange CellMergedList[int index] = {read=GetCellMergedList};
	virtual void __fastcall CopyToClipboard(void) = 0 /* overload */;
	virtual void __fastcall CopyToClipboard(const Tmsuflxmessages::TXlsCellRange &Range) = 0 /* overload */;
	virtual void __fastcall PasteFromClipboard(const int Row, const int Col) = 0 ;
	virtual void __fastcall ParseComments(void) = 0 ;
	virtual int __fastcall HyperLinkCount(void) = 0 ;
	virtual Tmsuflxmessages::THyperLink __fastcall GetHyperLink(const int HyperLinkIndex) = 0 ;
	virtual void __fastcall SetHyperLink(const int HyperLinkIndex, const Tmsuflxmessages::THyperLink &value) = 0 ;
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetHyperLinkCellRange(const int HyperLinkIndex) = 0 ;
	virtual void __fastcall SetHyperLinkCellRange(const int HyperLinkIndex, const Tmsuflxmessages::TXlsCellRange &CellRange) = 0 ;
	virtual void __fastcall AddHyperLink(const Tmsuflxmessages::TXlsCellRange &CellRange, const Tmsuflxmessages::THyperLink &value) = 0 ;
	virtual void __fastcall DeleteHyperLink(const int HyperLinkIndex) = 0 ;
	virtual int __fastcall GetRowOutlineLevel(const int aRow) = 0 ;
	virtual void __fastcall SetRowOutlineLevel(const int FirstRow, const int LastRow, const int Value) = 0 ;
	virtual int __fastcall GetColOutlineLevel(const int aCol) = 0 ;
	virtual void __fastcall SetColOutlineLevel(const int FirstCol, const int LastCol, const int Level) = 0 ;
	__property bool OutlineSummaryRowsBelowDetail = {read=GetOutlineSummaryRowsBelowDetail, write=SetOutlineSummaryRowsBelowDetail, nodefault};
	__property bool OutlineSummaryColsRightOfDetail = {read=GetOutlineSummaryColsRightOfDetail, write=SetOutlineSummaryColsRightOfDetail, nodefault};
	__property bool OutlineAutomaticStyles = {read=GetOutlineAutomaticStyles, write=SetOutlineAutomaticStyles, nodefault};
	__property bool Options1904Dates = {read=GetOptions1904Dates, write=SetOptions1904Dates, nodefault};
	__property bool OptionsR1C1 = {read=GetOptionsR1C1, write=SetOptionsR1C1, nodefault};
	__property bool OptionsSaveExternalLinkValues = {read=GetOptionsSaveExternalLinkValues, write=SetOptionsSaveExternalLinkValues, nodefault};
	__property bool OptionsPrecisionAsDisplayed = {read=GetOptionsPrecisionAsDisplayed, write=SetOptionsPrecisionAsDisplayed, nodefault};
	virtual void __fastcall FreezePanes(const int Row, const int Col) = 0 ;
	virtual void __fastcall GetFrozenPanes(/* out */ int &Row, /* out */ int &Col) = 0 ;
	virtual void __fastcall SplitWindow(const int xOffset, const int yOffset) = 0 ;
	virtual void __fastcall GetSplitWindow(/* out */ int &xOffset, /* out */ int &yOffset) = 0 ;
	__property bool InvalidateFormulas = {read=GetInvalidateFormulas, write=SetInvalidateFormulas, nodefault};
	__property bool IsXltTemplate = {read=GetIsXltTemplate, write=SetIsXltTemplate, nodefault};
	virtual void __fastcall AutofitRow(const int row1, const int row2, const bool AutofitNotAutofittingRows, const bool keepHeightAutomatic, const Extended adjustment) = 0 ;
	virtual void __fastcall AutofitCol(const int Col1, const int Col2, const bool IgnoreStrings, const Extended Adjustment) = 0 ;
	virtual void __fastcall AutofitRowsOnWorkbook(const bool AutofitNotAutofittingRows, const bool KeepSizesAutomatic, const Extended Adjustment) = 0 ;
	virtual void __fastcall SetAutoFilter(const int row, const int col1, const int col2) = 0 /* overload */;
	virtual void __fastcall RemoveAutoFilter(void) = 0 ;
	virtual bool __fastcall HasAutoFilter(void) = 0 /* overload */;
	virtual bool __fastcall HasAutoFilter(const int row, const int col) = 0 /* overload */;
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetAutoFilterRange(void) = 0 ;
public:
	#pragma option push -w-inl
	/* TObject.Create */ inline __fastcall TExcelFile(void) : System::TObject() { }
	#pragma option pop
	#pragma option push -w-inl
	/* TObject.Destroy */ inline __fastcall virtual ~TExcelFile(void) { }
	#pragma option pop
	
};


class DELPHICLASS TExcelAdapter;
class PASCALIMPLEMENTATION TExcelAdapter : public Classes::TComponent 
{
	typedef Classes::TComponent inherited;
	
private:
	AnsiString FBasePathToOpen;
	
public:
	virtual TExcelFile* __fastcall GetWorkbook(void) = 0 ;
	
__published:
	__property AnsiString BasePathToOpen = {read=FBasePathToOpen, write=FBasePathToOpen};
public:
	#pragma option push -w-inl
	/* TComponent.Create */ inline __fastcall virtual TExcelAdapter(Classes::TComponent* AOwner) : Classes::TComponent(AOwner) { }
	#pragma option pop
	#pragma option push -w-inl
	/* TComponent.Destroy */ inline __fastcall virtual ~TExcelAdapter(void) { }
	#pragma option pop
	
};


//-- var, const, procedure ---------------------------------------------------

}	/* namespace Tmsuexceladapter */
using namespace Tmsuexceladapter;
#pragma pack(pop)
#pragma option pop

#pragma delphiheader end.
//-- end unit ----------------------------------------------------------------
#endif	// Tmsuexceladapter