xlsadapter.hpp

来自「TMSPack基本上涵盖了Delphi所有的基础控件」· HPP 代码 · 共 327 行 · 第 1/2 页

	virtual Word __fastcall GetPrintNumberOfHorizontalPages(void);
	virtual Word __fastcall GetPrintNumberOfVerticalPages(void);
	virtual int __fastcall GetPrintScale(void);
	virtual Byte __fastcall GetPrintOptions(void);
	virtual bool __fastcall GetPrintToFit(void);
	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 Uflxmessages::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 Uflxmessages::TPrinterDriverSettings &Value);
	virtual void __fastcall SetPrintPaperSize(const int Value);
	virtual void __fastcall SetPrintXResolution(const int Value);
	virtual void __fastcall SetPrintYResolution(const int Value);
	virtual Uflxmessages::TXlsCellRange __fastcall GetCellMergedBounds(int aRow, int aCol);
	virtual Uflxmessages::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);
	
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);
	Uexcelrecords::TWorkbook* __fastcall GetTWorkbook(void);
	virtual void __fastcall NewFile(const int SheetCount = 0x3);
	virtual void __fastcall OpenFile(const AnsiString FileName);
	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 AnsiString 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 Uflxmessages::TOnGetFileNameEvent OnGetFileName, const Uflxmessages::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(Uflxmessages::TXlsNamedRange &NamedRange);
	virtual void __fastcall AssignPicture(const int Row, const int aPos, const AnsiString Pic, const Uflxmessages::TXlsImgTypes PicType)/* overload */;
	virtual void __fastcall AssignPicture(const int Row, const int aPos, const AnsiString Pic, const Uflxmessages::TXlsImgTypes PicType, const Uflxmessages::TImageProperties &Props, const Uflxmessages::TFlxAnchorType Anchor = (Uflxmessages::TFlxAnchorType)(0x1))/* overload */;
	virtual void __fastcall AssignPictureProperties(const int Row, const int aPos, const Uflxmessages::TImageProperties &Props, const Uflxmessages::TFlxAnchorType Anchor = (Uflxmessages::TFlxAnchorType)(0x1));
	virtual void __fastcall GetPicture(const int Row, const int aPos, const Classes::TStream* Pic, Uflxmessages::TXlsImgTypes &PicType, Uflxmessages::TClientAnchor &Anchor);
	virtual void __fastcall DeleteImage(const int Index);
	virtual void __fastcall ClearImage(const int Index);
	virtual void __fastcall AddImage(const AnsiString Data, const Uflxmessages::TXlsImgTypes DataType, const Uflxmessages::TImageProperties &Properties, const Uflxmessages::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 Uflxmessages::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 Uflxmessages::TXlsCellValue __fastcall GetCellDataX(const int aRow, const int aColOffset);
	virtual void __fastcall GetCellDataX2(const int aRow, const int aColOffset, /* out */ Uflxmessages::TXlsCellValue &v, /* out */ Uflxmessages::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 Uflxmessages::TXlsCellValue &Value);
	virtual void __fastcall AssignCellDataX2(const int aRow, const int aColOffset, const Uflxmessages::TXlsCellValue &Value, const Uflxmessages::TRTFRunList RTFRuns);
	virtual void __fastcall GetCellValueX2(int aRow, int aCol, /* out */ Uflxmessages::TXlsCellValue &v, /* out */ Uflxmessages::TRTFRunList &RTFRuns);
	virtual void __fastcall AssignCellValueX2(int aRow, int aCol, const Uflxmessages::TXlsCellValue &Value, const Uflxmessages::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 Uflxformats::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 Uflxformats::TFlxFont &Fmt);
	virtual int __fastcall AddFormat(const Uflxformats::TFlxFormat &Fmt);
	virtual void __fastcall CopyToClipboard(void)/* overload */;
	virtual void __fastcall CopyToClipboard(const Uflxmessages::TXlsCellRange &Range)/* overload */;
	virtual void __fastcall PasteFromClipboard(const int Row, const int Col);
	virtual void __fastcall ParseComments(void);
	virtual int __fastcall HyperLinkCount(void);
	virtual Uflxmessages::THyperLink __fastcall GetHyperLink(const int HyperLinkIndex);
	virtual void __fastcall SetHyperLink(const int HyperLinkIndex, const Uflxmessages::THyperLink &value);
	virtual Uflxmessages::TXlsCellRange __fastcall GetHyperLinkCellRange(const int HyperLinkIndex);
	virtual void __fastcall SetHyperLinkCellRange(const int HyperLinkIndex, const Uflxmessages::TXlsCellRange &CellRange);
	virtual void __fastcall AddHyperLink(const Uflxmessages::TXlsCellRange &CellRange, const Uflxmessages::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 Uflxmessages::BooleanArray __fastcall GetUsedPaletteColors();
	virtual void __fastcall FreezePanes(const int Row, const int Col);
	virtual void __fastcall GetFrozenPanes(int &Row, int &Col);
	virtual void __fastcall SplitWindow(const int xOffset, const int yOffset);
	virtual void __fastcall GetSplitWindow(int &xOffset, 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);
};


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

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

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