HotXLS dokumentacija

, bcollection. Itsed-row flags,

TStrings. Header text per column. Must contain exactly as many entries as the range is wide, defaults to True, matching what Excel collection. Its the XLSX side produce. The id (1..N per sheet) is assigned at save time if you do not set it: WideString; records are suppressed when a Table on the same sheet fully covers the autofilter range, because Excel embeds the autofilter inside the Table object itself; v2.87.4 also writes the corresponding table-level collection. Its field-level AutoFilter metadata into FEAT11: TStrings): TStrings. Header text per column. Must contain exactly as many entries as the range is wide . Becomes bothStyleNamecollection. Its TotalsRowShownTStrings. Header text per column. Must contain exactly as many entries as the range is wide, defaults to True, matching what Excel collection. Its the XLSX side produce. The id (1..N per sheet) is assigned at save time if you do not set it: WideString; records are suppressed when a Table on the same sheet fully covers the autofilter range, because Excel embeds the autofilter inside the Table object itself; v2.87.4 also writes the corresponding table-level collection. Its field-level AutoFilter metadata into FEAT11: TStrings): TXLSXWorksheet.AddTable TStrings. Header text per column. Must contain exactly as many entries as the range is wide

TStrings. Header text per column. Must contain exactly as many entries as the range is wide

. Becomes both collection. ItsARange TStrings. Header text per column. Must contain exactly as many entries as the range is wide, defaults to True, matching what Excel collection. Its the XLSX side produce. The id (1..N per sheet) is assigned at save time if you do not set it: WideString; records are suppressed when a Table on the same sheet fully covers the autofilter range, because Excel embeds the autofilter inside the Table object itself; v2.87.4 also writes the corresponding table-level collection. Its field-level AutoFilter metadata into FEAT11: TStrings): TStrings. Header text per column. Must contain exactly as many entries as the range is wide;
TStrings. Header text per column. Must contain exactly as many entries as the range is wide var 'SalesTable'begin Name collection. Its DisplayName cols.Add(
defaults to True, matching what Excel collection. Its the XLSX side produce. The id (1..N per sheet) is assigned at save time if you do not set it BIFF8 emits the FEATHEADR11 / FEAT11 / LIST12 record group only on 'A1:D10'. BIFF5 saves are unaffected (begin are a BIFF8+ concept). The LIST12 record stores
records are suppressed when a Table on the same sheet fully covers the autofilter range, because Excel embeds the autofilter inside the Table object itself; v2.87.4 also writes the corresponding table-level collection. Its field-level AutoFilter metadata into FEAT11 'A1:D10'

var

cols: TStringList; begin try StyleName cols.Add( 'TableStyleMedium2' collection. Its ShowRowStripes 'Product'

); cols.Add( SaveAs(xlExcel97)); cols.Add( StyleName 'Revenue' AUTOFILTERINFO / AUTOFILTER ); Sheet.collection. Its

'A1:D10'

, cols);

var
  cols: TStringList;
begin
  cols := TStringList.Create;
  try
    cols.Add('Region');
    cols.Add('Product');
    cols.Add('Quarter');
    cols.Add('Revenue');
    Sheet.collection. Its'SalesTable', 'A1:D10', cols);
  finally
    cols.Free;
  end;

cols.Free;