tmsxlsadapter.hpp

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

	virtual void __fastcall SetPrintNumberOfHorizontalPages(const Word Value);
	virtual void __fastcall SetPrintNumberOfVerticalPages(const Word Value);
	virtual void __fastcall SetPrintScale(const int Value);
	virtual void __fastcall SetPrintToFit(const bool Value);
	virtual void __fastcall SetPrintOptions(const Byte Value);
	virtual int __fastcall GetPrintCopies(void);
	virtual Tmsuflxmessages::TPrinterDriverSettings __fastcall GetPrinterDriverSettings();
	virtual int __fastcall GetPrintPaperSize(void);
	virtual int __fastcall GetPrintXResolution(void);
	virtual int __fastcall GetPrintYResolution(void);
	virtual void __fastcall SetPrintCopies(const int Value);
	virtual void __fastcall SetPrinterDriverSettings(const Tmsuflxmessages::TPrinterDriverSettings &Value);
	virtual void __fastcall SetPrintPaperSize(const int Value);
	virtual void __fastcall SetPrintXResolution(const int Value);
	virtual void __fastcall SetPrintYResolution(const int Value);
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetCellMergedBounds(int aRow, int aCol);
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetCellMergedList(int index);
	virtual bool __fastcall GetOptions1904Dates(void);
	virtual bool __fastcall GetOptionsR1C1(void);
	virtual bool __fastcall GetOptionsSaveExternalLinkValues(void);
	virtual void __fastcall SetOptions1904Dates(const bool Value);
	virtual void __fastcall SetOptionsR1C1(const bool Value);
	virtual void __fastcall SetOptionsSaveExternalLinkValues(const bool Value);
	virtual bool __fastcall GetOptionsPrecisionAsDisplayed(void);
	virtual void __fastcall SetOptionsPrecisionAsDisplayed(const bool Value);
	virtual bool __fastcall GetOutlineSummaryColsRightOfDetail(void);
	virtual bool __fastcall GetOutlineSummaryRowsBelowDetail(void);
	virtual bool __fastcall GetOutlineAutomaticStyles(void);
	virtual void __fastcall SetOutlineSummaryColsRightOfDetail(const bool Value);
	virtual void __fastcall SetOutlineSummaryRowsBelowDetail(const bool Value);
	virtual void __fastcall SetOutlineAutomaticStyles(const bool Value);
	virtual bool __fastcall GetInvalidateFormulas(void);
	virtual void __fastcall SetInvalidateFormulas(const bool Value);
	virtual bool __fastcall GetIsXltTemplate(void);
	virtual void __fastcall SetIsXltTemplate(const bool Value);
	
public:
	__fastcall TXLSFile(const TXLSAdapter* aAdapter)/* overload */;
	__fastcall TXLSFile(const TXLSAdapter* aAdapter, const bool aAllowOverwritingFiles)/* overload */;
	__fastcall virtual ~TXLSFile(void);
	virtual void __fastcall Connect(void);
	virtual void __fastcall Disconnect(void);
	Tmsuexcelrecords::TWorkbook* __fastcall GetTWorkbook(void);
	virtual void __fastcall NewFile(const int SheetCount = 0x3);
	virtual void __fastcall OpenFile(const AnsiString FileName);
	virtual void __fastcall OpenFileAndSearch(const AnsiString FileName);
	void __fastcall OpenFileAndOrSearch(const AnsiString FileName, const bool Search);
	virtual void __fastcall LoadFromStream(const Classes::TStream* aStream);
	virtual void __fastcall CloseFile(void);
	virtual void __fastcall InsertAndCopySheets(const int CopyFrom, const int InsertBefore, const int SheetCount);
	virtual void __fastcall ClearSheet(void);
	virtual void __fastcall DeleteSheet(int aSheetCount);
	virtual int __fastcall SheetCount(void);
	virtual void __fastcall SelectSheet(const int SheetNo);
	virtual void __fastcall DeleteMarkedRows(const WideString Mark);
	virtual void __fastcall RefreshChartRanges(const WideString VarStr);
	virtual void __fastcall MakePageBreaks(const WideString Mark);
	virtual void __fastcall InsertHPageBreak(const int Row);
	virtual void __fastcall InsertVPageBreak(const int Col);
	virtual void __fastcall DeleteHPageBreak(const int Row);
	virtual void __fastcall DeleteVPageBreak(const int Col);
	virtual bool __fastcall HasHPageBreak(const int Row);
	virtual bool __fastcall HasVPageBreak(const int Col);
	virtual void __fastcall RefreshPivotTables(void);
	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));
	virtual void __fastcall InsertAndCopyRows(const int FirstRow, const int LastRow, const int DestRow, const int aCount, const bool OnlyFormulas);
	virtual void __fastcall InsertAndCopyCols(const int FirstCol, const int LastCol, const int DestCol, const int aCount, const bool OnlyFormulas);
	virtual void __fastcall DeleteRows(const int aRow, const int aCount);
	virtual void __fastcall DeleteCols(const int aCol, const int aCount);
	virtual void __fastcall BeginSheet(void);
	virtual void __fastcall EndSheet(const int RowOffset);
	virtual bool __fastcall CanOptimizeRead(void);
	virtual int __fastcall GetExcelNameCount(void);
	virtual WideString __fastcall GetRangeName(int index);
	virtual int __fastcall GetRangeR1(int index);
	virtual int __fastcall GetRangeR2(int index);
	virtual int __fastcall GetRangeC1(int index);
	virtual int __fastcall GetRangeC2(int index);
	virtual void __fastcall SetRangeR1(int index, int value);
	virtual void __fastcall SetRangeR2(int index, int value);
	virtual void __fastcall SetRangeC1(int index, int value);
	virtual void __fastcall SetRangeC2(int index, int value);
	virtual int __fastcall GetRangeSheet(int index);
	virtual void __fastcall AddRange(Tmsuflxmessages::TXlsNamedRange &NamedRange);
	virtual void __fastcall AssignPicture(const int Row, const int aPos, const Tmsuflxmessages::ByteArray Pic, const Tmsuflxmessages::TXlsImgTypes PicType)/* 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))/* overload */;
	virtual void __fastcall AssignPictureProperties(const int Row, const int aPos, const Tmsuflxmessages::TImageProperties &Props, const Tmsuflxmessages::TFlxAnchorType Anchor = (Tmsuflxmessages::TFlxAnchorType)(0x1));
	virtual void __fastcall GetPicture(const int Row, const int aPos, const Classes::TStream* Pic, /* out */ Tmsuflxmessages::TXlsImgTypes &PicType, /* out */ Tmsuflxmessages::TClientAnchor &Anchor);
	virtual void __fastcall DeleteImage(const int Index);
	virtual void __fastcall ClearImage(const int Index);
	virtual void __fastcall AddImage(const Tmsuflxmessages::ByteArray Data, const Tmsuflxmessages::TXlsImgTypes DataType, const Tmsuflxmessages::TImageProperties &Properties, const Tmsuflxmessages::TFlxAnchorType Anchor);
	virtual void __fastcall AssignComment(const int Row, const int aPos, const WideString Comment);
	virtual WideString __fastcall GetCellComment(int Row, int Col);
	virtual void __fastcall SetCellComment(int Row, int Col, const WideString Value, const Tmsuflxmessages::TImageProperties &Properties);
	virtual int __fastcall CellMergedListCount(void);
	virtual void __fastcall MergeCells(const int FirstRow, const int FirstCol, const int LastRow, const int LastCol);
	virtual void __fastcall UnMergeCells(const int FirstRow, const int FirstCol, const int LastRow, const int LastCol);
	virtual int __fastcall CellCount(const int aRow);
	virtual Variant __fastcall GetCellData(const int aRow, const int aColOffset);
	virtual Tmsuflxmessages::TXlsCellValue __fastcall GetCellDataX(const int aRow, const int aColOffset);
	virtual void __fastcall GetCellDataX2(const int aRow, const int aColOffset, /* out */ Tmsuflxmessages::TXlsCellValue &v, /* out */ Tmsuflxmessages::TRTFRunList &RTFRuns);
	virtual void __fastcall AssignCellData(const int aRow, const int aColOffset, const Variant &Value);
	virtual void __fastcall AssignCellDataX(const int aRow, const int aColOffset, const Tmsuflxmessages::TXlsCellValue &Value);
	virtual void __fastcall AssignCellDataX2(const int aRow, const int aColOffset, const Tmsuflxmessages::TXlsCellValue &Value, const Tmsuflxmessages::TRTFRunList RTFRuns);
	virtual void __fastcall GetCellValueX2(int aRow, int aCol, /* out */ Tmsuflxmessages::TXlsCellValue &v, /* out */ Tmsuflxmessages::TRTFRunList &RTFRuns);
	virtual void __fastcall AssignCellValueX2(int aRow, int aCol, const Tmsuflxmessages::TXlsCellValue &Value, const Tmsuflxmessages::TRTFRunList RTFRuns);
	virtual void __fastcall SetCellFormulaX(int aRow, int aCol, const WideString Formula, const Variant &Value);
	virtual void __fastcall SetCellString(const int aRow, const int aCol, const WideString Text, const WideString DateFormat = L"", const WideString TimeFormat = L"")/* 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"")/* overload */;
	virtual int __fastcall MaxRow(void);
	virtual int __fastcall MaxCol(void);
	virtual bool __fastcall IsEmptyRow(const int aRow);
	virtual int __fastcall ColByIndex(const int Row, const int ColIndex);
	virtual int __fastcall ColIndexCount(const int Row);
	virtual int __fastcall ColIndex(const int Row, const int Col);
	virtual void __fastcall SetBounds(const int aRangePos);
	virtual int __fastcall GetFirstColumn(void);
	virtual void __fastcall PrepareBlockData(const int R1, const int C1, const int R2, const int C2);
	virtual void __fastcall AssignBlockData(const int Row, const int Col, const Variant &v);
	virtual void __fastcall PasteBlockData(void);
	virtual bool __fastcall IsWorksheet(const int index);
	virtual int __fastcall FontListCount(void);
	virtual int __fastcall FormatListCount(void);
	virtual int __fastcall AddFont(const Tmsuflxformats::TFlxFont &Fmt);
	virtual int __fastcall AddFormat(const Tmsuflxformats::TFlxFormat &Fmt);
	void __fastcall CopyToClipboardFormat(const Tmsuflxmessages::TXlsCellRange &Range, /* out */ AnsiString &textString, const Classes::TStream* xlsStream);
	virtual void __fastcall CopyToClipboard(void)/* overload */;
	virtual void __fastcall CopyToClipboard(const Tmsuflxmessages::TXlsCellRange &Range)/* overload */;
	virtual void __fastcall PasteFromClipboard(const int Row, const int Col);
	void __fastcall PasteFromXlsClipboardFormat(const int Row, const int Col, const Classes::TStream* Stream);
	void __fastcall PasteFromTextClipboardFormat(const int Row, const int Col, const AnsiString Data);
	virtual void __fastcall ParseComments(void);
	virtual int __fastcall HyperLinkCount(void);
	virtual Tmsuflxmessages::THyperLink __fastcall GetHyperLink(const int HyperLinkIndex);
	virtual void __fastcall SetHyperLink(const int HyperLinkIndex, const Tmsuflxmessages::THyperLink &value);
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetHyperLinkCellRange(const int HyperLinkIndex);
	virtual void __fastcall SetHyperLinkCellRange(const int HyperLinkIndex, const Tmsuflxmessages::TXlsCellRange &CellRange);
	virtual void __fastcall AddHyperLink(const Tmsuflxmessages::TXlsCellRange &CellRange, const Tmsuflxmessages::THyperLink &value);
	virtual void __fastcall DeleteHyperLink(const int HyperLinkIndex);
	virtual int __fastcall GetRowOutlineLevel(const int aRow);
	virtual void __fastcall SetRowOutlineLevel(const int FirstRow, const int LastRow, const int Level);
	virtual int __fastcall GetColOutlineLevel(const int aCol);
	virtual void __fastcall SetColOutlineLevel(const int FirstCol, const int LastCol, const int Level);
	virtual Tmsuflxmessages::BooleanArray __fastcall GetUsedPaletteColors();
	virtual void __fastcall FreezePanes(const int Row, const int Col);
	virtual void __fastcall GetFrozenPanes(/* out */ int &Row, /* out */ int &Col);
	virtual void __fastcall SplitWindow(const int xOffset, const int yOffset);
	virtual void __fastcall GetSplitWindow(/* out */ int &xOffset, /* out */ int &yOffset);
	virtual void __fastcall AutofitRow(const int row1, const int row2, const bool AutofitNotAutofittingRows, const bool keepHeightAutomatic, const Extended adjustment);
	virtual void __fastcall AutofitCol(const int Col1, const int Col2, const bool IgnoreStrings, const Extended Adjustment);
	virtual void __fastcall AutofitRowsOnWorkbook(const bool AutofitNotAutofittingRows, const bool KeepSizesAutomatic, const Extended Adjustment);
	virtual void __fastcall SetAutoFilter(const int row, const int col1, const int col2)/* overload */;
	virtual void __fastcall RemoveAutoFilter(void);
	virtual bool __fastcall HasAutoFilter(void)/* overload */;
	virtual bool __fastcall HasAutoFilter(const int row, const int col)/* overload */;
	virtual Tmsuflxmessages::TXlsCellRange __fastcall GetAutoFilterRange();
};


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

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

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