Skip to main content
B
biswa11-Garnet
11-Garnet
October 14, 2019
Solved

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

  • October 14, 2019
  • 1 reply
  • 2183 views

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

Best answer by Velkumar

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

1 reply

V
19-Tanzanite
Velkumar19-TanzaniteAnswer
19-Tanzanite
October 15, 2019

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

I
ismaelvega1-Visitor
1-Visitor
October 30, 2019

Thanks for your answer.

It helped me a lot.

run 3

Terms & ConditionsAccessibility statement