Source File Connector Issue with Excel Files with Multiple Sheets

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The latest version of the Source File connector has an issue with Excel files containing multiple sheets, causing schema discovery to fail when one sheet has a header row and another does not. Requesting the ability to specify the sheet from which to read data.


Question

And one more thing. The latest version of the Source File connector does not work correctly with Excel files that have two or more sheets. If one sheet has a header row and another sheet does not, schema discovery fails. It would be super useful to be able to specify from which sheet you want to read data.


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["source-file-connector", "excel-files", "multiple-sheets", "schema-discovery", "specify-sheet"]
2

On this part, I believe I saw a recent GitHub issue/ticket on this one . . . might be worth finding it and making sure this case is one of the ones getting addressed since I think it’s pretty common. I think I remember people asking for range-limiting, which if correctly implemented I would assume would also allow you to specify sheet-based ranges.