TsWorksheetDataset

type TsWorksheetDataset = class(TDataset)

protected

  function AllocRecordBuffer; override;

  procedure ClearCalcFields(); override;

  procedure DoBeforeOpen; override;

  class function FieldDefsClass; override;

  procedure FreeRecordBuffer(); override;

  procedure GetBookmarkData(); override;

  function GetBookmarkFlag(); override;

  function GetRecNo; override;

  function GetRecord(); override;

  function GetRecordCount; override;

  function GetRecordSize; override;

  procedure InternalAddRecord(); override;

  procedure InternalClose; override;

  procedure InternalDelete; override;

  procedure InternalFirst; override;

  procedure InternalGotoBookmark(); override;

  procedure InternalInitFieldDefs; override;

  procedure InternalInitRecord(); override;

  procedure InternalLast; override;

  procedure InternalOpen; override;

  procedure InternalPost; override;

  procedure InternalSetToRecord(); override;

  function IsCursorOpen; override;

  procedure SetBookmarkData(); override;

  procedure SetBookmarkFlag(); override;

  procedure SetFiltered(); override;

  procedure SetFilterText(); override;

  procedure SetRecNo(); override;

  procedure AllocBlobPointers();

  procedure CalcFieldOffsets;

  function ColIndexFromField();

  procedure DetectFieldDefs;

  function FilterRecord();

  procedure FreeBlobPointers();

  procedure FreeWorkbook;

  function GetTotalFieldSize;

  procedure LoadWorksheetToBuffer();

  function LocateRecord();

  procedure ParseFilter();

  procedure SetupAutoInc;

  procedure Sort;

  procedure WriteBufferToWorksheet();

public

  constructor Create(); override;

  destructor Destroy; override;

  function AddFieldDef(); overload;

  function BookmarkValid(); override;

  procedure Clear();

  function CompareBookmarks(); override;

  procedure CopyFromDataset();

  function CreateBlobStream(); override;

  procedure CreateTable;

  procedure Flush;

  function GetFieldData(); override;

  function Locate(); override;

  function Lookup(); override;

  procedure SetFieldData(); override;

  procedure SortOnField();

  procedure SortOnFields();

  property AutoFieldDefStringSize: Integer; [rw]

  property Modified: Boolean; [r]

published

  property AutoFieldDefs: Boolean; [rw]

  property AutoFileFormat: Boolean; [rw]

  property FileFormat: TsSpreadsheetFormat; [rw]

  property FileName: TFileName; [rw]

  property SheetName: string; [rw]

  property Active;

  property AutoCalcFields;

  property FieldDefs;

  property Filter;

  property Filtered;

  property FilterOptions;

  property AfterCancel;

  property AfterClose;

  property AfterDelete;

  property AfterEdit;

  property AfterInsert;

  property AfterOpen;

  property AfterPost;

  property AfterRefresh;

  property AfterScroll;

  property BeforeCancel;

  property BeforeClose;

  property BeforeDelete;

  property BeforeEdit;

  property BeforeInsert;

  property BeforeOpen;

  property BeforePost;

  property BeforeRefresh;

  property BeforeScroll;

  property OnCalcFields;

  property OnDeleteError;

  property OnEditError;

  property OnFilterRecord;

  property OnNewRecord;

  property OnPostError;

end;

TsWorksheetDataset

TObject