The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
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
Solved! Go to 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
Regards.
--Sharon
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
Regards.
--Sharon
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