ExcelAdapter Methoden

Konstruktoren¶

function create: TAdapterExcel;

Methoden¶

procedure Open(const Filename: String; const Open: Boolean);
function Save: boolean; overload;
function Save(const Filename: String; const Open: boolean): boolean; overload;
function AddSheet(const Name: String): TAdapterExcelSheet;
procedure DeleteSheet(const Name: String);
function SelectSheet(const Name: String): TAdapterExcelSheet;
procedure ShowExcel;
function ActiveSheet: TAdapterExcelSheet;

Eigenschaften¶

Sheet[Name: String]: TAdapterExcelSheet
Cell[RowCol: String]: TAdapterExcelCell
CloseOnFree: boolean
//Flag setzen damit Excel nicht geschlossen wird beim Freigeben der TAdapterExcel Klasse
aExcel.CloseOnFree := false;

eine Zelle¶

TAdapterExcelCell
Eigenschaften:
Value: Variant
Font: TFont
RowCol: String
Sheet: String
HorizontalAlign: TExcelHorizontalAlignment
VerticalAlign: TExcelVerticalAlignment
Border: TExcelBorders
Format: String
Formula: String
Height: Double
Width: Double
WordWrap: Boolean

ein Sheet¶

TAdapterExcelSheet
Cell[RowCol: String]: TAdapterExcelCell
SheetName: String

sonstige Datentypen:


//Rahmen
TExcelBorder = 
(
  tebTop,
  tebBottom,
  tebLeft,
  tebRight,
  tebAll
);
TExcelBorders = set of TExcelBorder;

//Horizontale Ausrichtung
TExcelHorizontalAlignment = 
(
  thaGeneral,
  thaLeft,
  thaRight,
  thaCenter,
  thaFill,
  thaMultiPlan
);

//Vertikale Ausrichtung
TExcelVerticalAlignment =
(
  tvaBottom,
  tvaCenter,
  tvaDistributed,
  tvaJustify,
  tvaTop
);