ExcelAdapter Methoden

Modified on 03/02/2009 15:23 by CPALEB Categorized as Plattform
==Konstruktoren==
* function create: TAdapterExcel;

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

==Eigenschaften==
    Sheet&#0091;Name: String&#0093;: TAdapterExcelSheet  {BR}
    Cell&#0091;RowCol: String&#0093;: TAdapterExcelCell       {BR}
    CloseOnFree: boolean {BR}
    //Flag setzen damit Excel nicht geschlossen wird beim Freigeben der TAdapterExcel Klasse {BR}
     aExcel.CloseOnFree := false; {BR}

==eine Zelle==
TAdapterExcelCell {BR}
Eigenschaften: {BR}
    Value: Variant {BR}
    Font: TFont {BR}
    RowCol: String {BR}
    Sheet: String {BR}
    HorizontalAlign: TExcelHorizontalAlignment {BR}
    VerticalAlign: TExcelVerticalAlignment {BR}
    Border: TExcelBorders {BR}
    Format: String {BR}
    Formula: String  {BR}
    Height: Double {BR}
    Width: Double {BR}
    WordWrap: Boolean {BR}

==ein Sheet==
TAdapterExcelSheet {BR}
    Cell&#0091;RowCol: String&#0093;: TAdapterExcelCell {BR}
    SheetName: String {BR}

sonstige Datentypen: {BR}

<code pascal>
//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
);
</code>
CP Wiki

Navigation¶

ExcelAdapter Methoden
