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

[Sheetal_sable]

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

[slangley · Accepted solution]

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]

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

[PEHOWE]

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. 

[slangley]

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