HotXLS dokumentacija

object covering a named structured-reference region with a built-in style and an embedded autofilter. Read-only. (Available since v2.33.0.)

Remarks Tables are written into the BIFF8 worksheet stream just before EOF as a FEATHEADR11 / FEAT11 / LIST12 record group, only when the file format is BIFF8 ( var

Pastabos

Tables are written into the BIFF8 worksheet stream just before EOF as a FEATHEADR11 / FEAT11 / LIST12 record group, only when the file format is BIFF8 ( layout. Workbooks without tables save exactly as before. The reader populates the same collection on load (v2.33.1+), so a round-trip preserves the table range, name, display name, style, and banded-row flags var;

AddTable

forxlExcel97Sheet.Tables.Count - List12TableStyleClientInfo ' '

var begin for Tables.Add i :=

Sheet.Tables.Count -

' '

var
  i: Integer;
begin
  for i := 0 to Sheet.Tables.Count - 1 do
    Writeln(Sheet.Tables[i].Name, ' ', Sheet.Tables[i].Range);
end;

, Sheet.Tables[i].Range);