Skip to main content
11-Garnet
Oct 14, 2019 2:20 PM UTC
Solved

How to write an Excel Parser extension that reads data from excel file into Thingworx.

Hi All,

 

I need to import an excel file into thingworx. Can anyone please help me in writing a code in eclipse to read an excel file just like the CSVParser extension does for csv. I have already installed all the required extensions and plugins in Eclipse.

 

Thanks and Regards,

Biswa

VelkumarAnswer
19-Tanzanite
Oct 15, 2019 6:24 AM UTC

Hi @biswa ,

 

You can follow below link to read/write excel file in JAVA

https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/

 

For Thingworx extension, you need to import POI JAR file into your project.

 

Regards,

VR

2 replies

Velkumar19-TanzaniteAnswer
19-Tanzanite
Oct 15, 2019 6:24 AM UTC

Hi @biswa ,

 

You can follow below link to read/write excel file in JAVA

https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/

 

For Thingworx extension, you need to import POI JAR file into your project.

 

Regards,

VR

Translate
1-Visitor
Oct 30, 2019 8:37 AM UTC

Thanks for your answer.

It helped me a lot.

run 3

Translate