how can we read data from the excel sheet?

Solved1.21K viewsDIS excel protocol help
0
0 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 19th January 2024

2 Answers

-1
5.70K 0 Comments

Hi

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:

  1. Forwarding dummy data to the GQI | DataMiner Docs
  2. Building a GQI data source that fetches satellites | DataMiner Docs

Hope this information helps you forward.

Baptiste Pattyn [SLC] [DevOps Advocate] Answered question 27th October 2023
You are viewing 1 out of 2 answers, click here to view all answers.