Reading online excel.xlsx files in ignition

I have an excel file on the SharePoint with xlsx extension which I'm using to store some values and change it every time, I want to read these cells values in ignition

You would have to use SharePoint APIs to retrieve that file, perhaps on schedule, and process it with the Apache POI libraries. There are numerous examples on the forum for that latter part.

thanks sir, can I use these libraries even if the file is protected? or it should be available for everyone?

No idea. Try it and tell us if it worked.

Ok, but can this library be included inside ignition gateway scripts or it needs its own environment?

Are included with Ignition.

great, thanks