I wanted to read the data from the particular excel sheet using the protocol. And display that excel sheet data as a table in dataminer. It will be great help to me if someone guide me here.
The file is stored in local/SharePoint we need to dump that data to dataminer.
the following question/answer provides some pointers on how to do read an Excel sheet:
You could also achieve this with an ad hoc data source. This effectively enables you to pull data in to DataMiner from anywhere (API, folder, excel sheet...).
You can find documentation on how to create an ad hoc data source over here: Configuring an ad hoc data source in a query | DataMiner Docs.
If you want to try it out with an example we also have some tutorials that you can try:
- Forwarding dummy data to the GQI | DataMiner Docs
- Building a GQI data source that fetches satellites | DataMiner Docs
Hope this information helps you forward.