Getting Data From a specific Worksheet

[Ethan-Chew]

I am so sorry to ask so many questions...

May I know how I can get the data from a specific worksheet, rather than letting the code run through all worksheets? Thanks

[MaxDesiatov]

Hi @Ethan-Chew, no worries, it's totally fine 🙂 Did you check the example code in README.md? parseWorksheetPathsAndNames returns an array of worksheet names and paths. If you know the worksheet name you're interested in upfront, you could filter it out and parse only that one. Does that answer your question?

[Ethan-Chew]

Yep, it answers my question.
However, what do I use?

file.parseWorksheet()? What do I put in the parentheses though..

[MaxDesiatov]

parseWorksheet(at:) expects a worksheet path as its argument. If you know the worksheet name, you could filter the path out and then parse it like this:

let filepath = "./file.xlsx"
guard let file = XLSXFile(filepath: filepath) else {
    fatalError("XLSX file at \(filepath) is corrupted or does not exist")
}

let wsName = "Sheet 1"

for wbk in try file.parseWorkbooks() {
    guard let path = try file.parseWorksheetPathsAndNames(workbook: wbk)
        .filter({ $0.name == wsName }).map({ $0.path })
    else { continue }

    let worksheet = try file.parseWorksheet(at: path)
    for row in worksheet.data?.rows ?? [] {
        for c in row.cells {
            print(c)
        }
    }
}

Would this snippet work in your case?

[Ethan-Chew]

In my case,

guard let path = try file.parseWorksheetPathsAndNames(workbook: wbk) Shows error "Initializer for conditional binding must have Optional type, not '[String]' "

and

let worksheet = try file.parseWorksheet(at: path) Shows error "Cannot convert value of type '[String]' to expected argument type 'String'"

as path is a array and not a string

[MaxDesiatov]

Apologies, here's a snippet that should work, I should have used first instead of filter and a keyword argument where for the corresponding closure:

let filepath = "./file.xlsx"
guard let file = XLSXFile(filepath: filepath) else {
    fatalError("XLSX file at \(filepath) is corrupted or does not exist")
}

let wsName = "Sheet 1"

for wbk in try file.parseWorkbooks() {
    guard let path = try file.parseWorksheetPathsAndNames(workbook: wbk)
        .first(where: { $0.name == wsName }).map({ $0.path })
    else { continue }

    let worksheet = try file.parseWorksheet(at: path)
    for row in worksheet.data?.rows ?? [] {
        for c in row.cells {
            print(c)
        }
    }
}

[Ethan-Chew]

Thank you so much for your help!