Author: Tomas Rutkauskas

How can I check if a work sheet (e.g. 'first') is existing in an Excel file?

Answer:

In late binding:

1   { ... }
2   WB := Excel.Workbooks[1];
3   for Idx := 1 to WB.Worksheets.Count do
4     if WB.Worksheets[Idx].Name = 'first' then
5       Showmessage('Found the worksheet');
6   { ... }