API for matching sheet names to sheet paths

[MaxDesiatov]

Hi @duodo2412, the value of the cell B14 in this case is not "", it's essentially nil, because the cell itself is absent in the .xlsx file in this case. If you'd like to verify that, you can specify the exact cell:

let cell = worksheet.cells(atColumns: [ColumnReference("B")!], rows: [4])

My undertstanding is that this will return an empty array [] in your case. Does that resolve your issue?

Tks for the your answer .
Can i ask you another question.

I have a lot of sheets in xlsx file.
My code:
let sheets: [String] = try file.parseWorksheetPaths() and print result

• After that i change the order of sheet in file and execute my code again. Result is the same before i change the order of sheet .
  How can i know exactly the sheet i want to get ( may be i can query with name of sheet ) . Can you help me?
  Tks

Originally posted by @duodo2412 in #21 (comment)