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
);