Skip to Content
0
Nov 20, 2018 at 03:06 PM

Is there a way to get the sheets' names of an excel object (from a remote source)? [SAP HANA]

566 Views

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:

Attachments

sheets.png (8.2 kB)