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

[biswa]

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

[Velkumar · Accepted solution]

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

[ismaelvega]

Thanks for your answer.

It helped me a lot.

run 3