Documentazione HotXLS

Tables proprietà

Restituisce the BIFF8 Tables (Excel ListObjects) collection attached to this worksheet. Each entry is a TXLSTable object covering a named structured-reference region with a built-in style e an embedded autofilter. Read-only. (Available since v2.33.0.)

Sintassi

proprietà Tables: TXLSTables;

Osservazioni

Le tabelle vengono scritte nello stream del foglio di lavoro BIFF8 subito prima dell'EOF come gruppo di record FEATHEADR11 / FEAT11 / LIST12, solo quando il formato del file è BIFF8 (xlExcel97). The FEAT11 payload carries table AutoFilter metadata, e LIST12 carries the table style using the MS-XLS List12TableStyleClientInfo 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, e banded-row flags

Usa AddTable as the most common entry point rather than calling Tables.Add directly. Tables ids (1..N per sheet) are assigned at save time if not pre-set

Esempio

This example iterates the tables on the active sheet

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

Vedere also