topic-35750

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

List of sheets in a excel-file
Posted: Sun Jun 17, 2018 12:38 PM

Hi,

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

Thanks

Posts: 368

Joined: Sun May 31, 2009 06:25 PM

Re: List of sheets in a excel-file
Posted: Sun Jun 17, 2018 01:47 PM

You can try something like this:

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

do_whatever_you_want( oExcel:Worksheets( nI ):name )

Regards,

André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: List of sheets in a excel-file
Posted: Sun Jun 17, 2018 04:11 PM

Thank you André.

It's working fine

FiveTech Support Forums