Export Infotable data to XLSX sheet - Customization

[NK_10424958]

Steps to customize a service which export infotable data to xlsx format

[NK_10424958 · Accepted solution]

Just for informational purposes — for customization in later versions (9.4 and above):

To export InfoTable data to .xlsx format.

Required JARs:

1. log4j-api-2.17.2.jar

2. log4j-core-2.17.2.jar

3. poi-5.2.3.jar

4. poi-ooxml-5.2.3.jar

5. poi-ooxml-full-5.2.3.jar

6. xmlbeans-5.1.1.jar

Build Recommendation:

• I suggest using Apache Ant instead of Gradle for building the project.

Additional Notes:

• Ensure there are no errors or warnings in your Java files before building.

• Use correct SDK while creating project..
  
  
  
  
  
  

[NK_10424958]

The following guides were helpful for me in achieving successful customization: (List your guides or links here if needed.)
https://repo1.maven.org/maven2/org/apache/
https://community.ptc.com/t5/IoT-Tips/Create-An-Extension-Part-1/ta-p/827938

[AndrewK]

@NK_10424958 Thank you for sharing!

[AdamK_93]

Thank you for the details and information on how to do excel export.

However I'd suggest the opposite, so using Gradle instead of Ant. Any new development should be built with Gradle project, moreover, the TWX Extension for eclipse have some bugs with Ant build configs.

This is just suggestion, so both can work if correctly configured.