Load Sheetnames Excel Sharepoint

[Danijel]

Hello together,

I use the Office365 Sharepoint Connector to load excel files. This works also so far. However, I have the problem that the tab names sometimes change or new tab sheets are added.

Is there a way to access the metadata of the excel file to get all the tab names?

Thanks and greetings

[marcus_sommer]

Regarding to this post: How to get sheetnames of Excelfile in SharePoint? - Qlik Community - 1906087 it seems not to be possible with the classical sql odbc approach - whereby ... maybe the colleague may not have tried everything because in general it should be meaningless where the file resides but various security stuff in regard to ports and authentication may make these things complex ...

An alternatively may be to use PowerAutomate to get these information - this might be a starting point: Solved: How to get excel worksheet names in a list variabl... - Power Platform Community (microsoft.....

Another method might be to synchronize the SharePoint with Onedrive and mapping it to a local storage and then grabbing the files from there.

- Marcus