How do I do COM Interop in Java?

Question

I am a .NET programmer working with a Java Spring Boot project to create a REST API. I need to do some COM interop with an Excel spreadsheet from within the Spring Boot application.

How do I go about doing that?

I know the code to write. I just don't know the tools. Specifically, what jar files do I need to reference? Where do I get them from?

Answer 1

I would prefer

https://poi.apache.org/

Otherwise you can use "Java Access Bridge", here is an overview

https://docs.oracle.com/javase/8/docs/technotes/guides/access/jab/introduction.html#jab-overview