fastexcel VS Javet

I'm using fastexcel to create the excel file, and I'm flushing it to the OutputStream after every row is written. Right now, I am using a FileOutputStream to write to disk. When the excel file is done being generated, I read it back in using InputStreamResource and stream the response. My thought process is that a ByteArrayOutputStream keeps everything in memory even if I'm flushing the excel file after every row, so I used the FileOutputStream. Does my logic track here? Or am I unnecessarily slowing things down with expensive filesystem IO?

fastexcel the fastest xlsx generation library

I would use some library like for example this one. So you collect all the data you want to store in a list or map, and iterate over it, then add them to the excel like shown in the documentation of the library (should always be the same way more or less for any library)

I've only had memory problems with apache poi. I only use https://github.com/dhatim/fastexcel now

Javet is one of a kind. No other library like it out there today. Not widely known yet as its kinda new.

If you want to embed a V8 instance in Java, check out Javet, it uses less memory and will work in native graalvm images. Also allows you to embed a NodeJS instance where you can use NodeJS specific libraries.

They should add a "scripting" section. There's cool new projects being started in this area like Javet which allows you to embed Node.js and a standalone V8 too. Nashorn and Rhino could be added to that list too despite not being so new.