Accessing the "name" of a sheet in a workbook

[Jack Royal-Gordon]

How can I get the name of a specific worksheet (e.g. workbook.sheet(0).name)? I am trying to distinguish different spreadsheet layouts, and the name of the sheet is relevant.

[Ahmed Bahaggag]

Hello Jack

I guess you can try this:

# this will return all work sheets for the workbook

workbook.worksheets

# you can find a work sheet by name as the following

mysheet = workbook.worksheets.find { |sheet| sheet.name == "sheet name" }

Hope that help

Regards