Skip to main content
1-Visitor
December 20, 2019
Solved

How to put data(Present on mashup) into Excel sheet by using Apache POI ?

  • December 20, 2019
  • 2 replies
  • 1666 views

hi,


1. How to put data into Excel sheet by using Apache POI ? is this possible?
2. can it be done by writing some service in JavaScript or using some custom widget, to export the mashup report to excel directly?

 

 

Thanks,

Sheetal

Best answer by slangley

Hi @Sheetal_sable.

 

You could write your own extension but would need to do adequate testing to confirm the POI libraries don't conflict with the ones that come with ThingWorx.  Here are some links to help with writing your own extension:

 

Best Practices for Developing Applications

Create an Extension

 

Regards.

 

--Sharon

2 replies

slangleyCommunity ManagerAnswer
Support
December 20, 2019

Hi @Sheetal_sable.

 

You could write your own extension but would need to do adequate testing to confirm the POI libraries don't conflict with the ones that come with ThingWorx.  Here are some links to help with writing your own extension:

 

Best Practices for Developing Applications

Create an Extension

 

Regards.

 

--Sharon

Support
December 30, 2019

Hi @Sheetal_sable.

 

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

17-Peridot
December 31, 2019

Hello @Sheetal_sable ,

 

If you create your own ThingWorx Extension, including the Apache POI Java libraries should be possible.

The extension you create would be similar to what the CSV extension provides.  The extension provides a Widget to receive input and use as the start event for processing. The processing would involve extracting each cells information and making the corresponding calls to the Apache POI library. 

 

Support
January 2, 2020

Hi @Sheetal_sable.

 

If one of the previous responses answered your question, please mark the appropriate one as the Accepted Solution for the benefit of others with the same question.

 

Regards.

 

--Sharon