cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

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

Sheetal_sable
12-Amethyst

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

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

4 REPLIES 4

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

slangley
23-Emerald II
(To:slangley)

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

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. 

 

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

Top Tags