Axolot Data

Posted: **Tue Nov 01, 2016 11:34 am**

Hi,
How do you add a worksheet and give it a name, and how do you know how many worksheets there are in the workbook?
best
Jon

Posted: **Tue Nov 15, 2016 4:28 pm**

To add a new sheet

  // XLS is an XLSReadWriteII5 component
  XLS.Add;
  // Name it
  XLS[XLS.Count - 1].Name := 'NewName';

To get the sheet count

var
  NumSheets: Integer;
begin
  NumSheets := XLS.Count;
end;

Adding worksheets