fastexcel VS Kaitai Struct

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

- ImHex [2], which has a pattern language [3] which allows parsing, and it seems more powerful than what Kaitai offers. I stumbled upon some limitations with it but it was still useful.

[1]: https://kaitai.io/

Beautiful. Didn't know something like this exists. Reminds me of Katai[0]

[0]. https://kaitai.io/

An EDID override like this would be helpful for macOS as well, where the monitors swapping around after standby is a real annoyance [0] [1]

EDID rewrites are 99% of the time blocked by the monitor firmware: https://notes.alinpanaitiu.com/Decoding-monitor-EDID-on-macO...

By the way, one helpful tool that helped me navigate the EDID dump was Kaitai Struct [2]. It shows a side by side view with the hex view and the EDID structure, and it highlights the hex values in real time as you navigate the structure. Unfortunately [3] it doesn't support the extension blocks that the author needs.

[0] https://notes.alinpanaitiu.com/Weird-monitor-bugs

[1] https://forums.macrumors.com/threads/external-displays-swapp...

[2] https://kaitai.io/

[3] https://github.com/kaitai-io/edid.ksy

Kaitai Struct might be a good choice for that: https://kaitai.io/

For binary log format, there's the excellent Kaitai Struct frameworks, that make it very easy to generate parsers from a declarative schema

kaitai

https://kaitai.io/

Worth a look if you are writing binary parsers.