Hello community,
I am trying to create virtual tables from the sheets of an excel file in remote source imported with the Data Provisioning Agent. I know you can do this by right clicking and clicking New Virtual Table but I am trying to automate this with an xsjs app.
But to automate it I need to get each name of the different sheets to create the tables with the right names. I looked for the solution in the system views but even in REMOTE_SOURCE_OBJECTS there is nothing.
Surely there must be a way to get the names somewhere since they appear in HANA?
Here is an image of my sheets:
