Skip to main content
H
hpanchamoorthy1-Visitor
1-Visitor
September 20, 2016
Question

How to load data into a grid from file repository which contains an excel file?

  • September 20, 2016
  • 1 reply
  • 9363 views

Hi there...

I'm trying to get the excel file content from file repository and load it into gird.

I have tried a couple of services such as csv parsing and load text. While using csv parsing service, i'm getting the content but not able to load it into the grid.(I checked it in debug option)

I'm a beginner to this platform. It will be very helpful if i get some suggestions.

1 reply

C
CarlesColl1-Visitor
1-Visitor
September 20, 2016

Actually there isn't any service to read XLS files, to read it out-of-the-box with TW, the file should be a CSV file or a simple TXT file.

    C
    CarlesColl1-Visitor
    1-Visitor
    September 21, 2016

    Hi,

    If you had build a service to read the CSV file, you just need that this result returns the Infotable which it's readed from the CSV. If you are reading the CSV file with CSV parser extension ( https://marketplace.thingworx.com/Items/csv-parser ) , you just need to:

    var result = Resources["CSVParserFunctions"].ReadCSVFile(params);

    And set Infotable as Service result type.

    Then you can build a mashup that consumes this service and bind the service result to the grid.

    V
    vikasdwankhede1-Visitor
    1-Visitor
    May 10, 2018

    Any one Can help on this?

     

    regards

    Vikas

    Terms & ConditionsCookie settingsAccessibility statement