HotXLS-dokumentation
Startside Indhold Oversigt

Open metode

Opens an existing Workbook

Syntaks

function Open(FileName: WideString):Integer;
function Open(Stream: TStream):Integer;
function Open(FileName: WideString; Password: WideString):Integer;
function Open(Stream: TStream; Password: WideString):Integer;
FileName WideString. En streng, der angiver navnet på den fil, der skal åbnes. Du kan angive en fuld sti; gør du det ikke, åbner Workbook filen i den aktuelle mappe
Stream TStream. A stream object that can be used to read the Workbook
Password WideString. En streng, der indeholder den adgangskode, der kræves for at åbne en beskyttet projektmappe

Eksempel

This example opens excel file book1.xls from the current folder 

Workbook.Open('book.xls');
Eksemplet åbner den adgangskodebeskyttede Excel-projektmappe book2.xls med adgangskoden 'password' 

Workbook.Open('book2.xls', 'password');
This example changes the name of the first Worksheet in book1.xls 

Var book: IXLSWorkbook;
begin
  book := TXLSWorkbook.Create();
  book.Open('book1.xls');
  book.Sheets[1].Name := 'New name';
  book.SaveAs('book1.xls');
end;
This example loads Workbook from a BLOB field 

var
  MS: TMemoryStream;
begin
  MS := TMemoryStream.Create;
  try
    SQLDataSet1Documents.SaveToStream(MS);
    FWorkbook.Open(MS);
  finally
    MS.Free;
  end;
end;