Skip to main content
A
AP_958723617-Peridot
17-Peridot
August 2, 2021
Solved

excel file generation

  • August 2, 2021
  • 1 reply
  • 2021 views

How to generate(or download) excel file instead of csv file. Any extension available.? Any possibility is there to import the csv file in excel and showing that excel file to the user in mashup or in repository?? 

Best answer by slangley

Hi @AP_9587236.

 

There is no OOTB solution for generating an Excel file.  You would have to write your own or you can talk to our Sales team about hiring one of our consultants to write it for you.

 

Excel does support importing csv files.  Are you expecting to be able to manipulate the spreadsheet before displaying in a mashup?  If not, you already have the data in ThingWorx so you could throw that into an infotable and display it in your Mashup via the Advanced Grid widget.  There is also a ReadCSVFile service that would allow you to import a CSV file created in Excel that can then be displayed in your mashup via the grid.

 

Regards.

 

--Sharon

 

 

1 reply

S
slangleyCommunity ManagerAnswer
Community Manager
August 12, 2021

Hi @AP_9587236.

 

There is no OOTB solution for generating an Excel file.  You would have to write your own or you can talk to our Sales team about hiring one of our consultants to write it for you.

 

Excel does support importing csv files.  Are you expecting to be able to manipulate the spreadsheet before displaying in a mashup?  If not, you already have the data in ThingWorx so you could throw that into an infotable and display it in your Mashup via the Advanced Grid widget.  There is also a ReadCSVFile service that would allow you to import a CSV file created in Excel that can then be displayed in your mashup via the grid.

 

Regards.

 

--Sharon

 

 

    S
    slangleyCommunity Manager
    Community Manager
    August 19, 2021

    Hi @HC_9989186

     

    If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

     

    Regards.

     

    --Sharon

     

    Terms & ConditionsCookie settingsAccessibility statement