Reading content from an excel file stored in Onedrive

[Telesur]

Hello. Using the jdbc connector I've tried to connect Sisense to Onedrive. Meaning I added Onedrive as a datasource in Sisense. But this results in only reading the meta data(column names, file names) of how Onedrive stores its files. I am interested in connecting onedrive in a way to Sisense, so that I can choose an Excel file for example and read the contents of that file in. Does anyone know how I can do this?

[acidic_ph]

That is of interest of mine as well - Currently, I am manually updating the files which is not ideal!

[HamzaJ]

I am not familiar with Onedrive, however might this not be what you are looking for:

CData JDBC Driver for Microsoft Excel Online: https://cdn.cdata.com/help/FXJ/jdbc/

[Telesur]

Yess, I've tried this but this involves in me uploading the excel file to Sisense. Which isn't really what I'm looking for. But thanks.