FiveTech Software tech support forums • List of sheets in a excel-file

Page 1 of 1

List of sheets in a excel-file

Posted: Sun Jun 17, 2018 12:38 pm

by Marc Vanzegbroeck

Hi,

Is there a way to have a list of the sheet-names that are present in an excel-file?

Thanks

Re: List of sheets in a excel-file

Posted: Sun Jun 17, 2018 1:47 pm

by ADutheil

You can try something like this:

FOR nI := 1 TO oExcel:sheets():Count

do_whatever_you_want( oExcel:Worksheets( nI ):name )

NEXT

Re: List of sheets in a excel-file

Posted: Sun Jun 17, 2018 4:11 pm

by Marc Vanzegbroeck

Thank you André.

It's working fine