A modern programming language that makes developers happier.

kotlinlang

Currently I’m trying to automate een excel task for my work in python but want to convert it to kotlin. I am using XLwings lib because this was the only lib that supports the xlsb format. Is there a way to automate it directly in kotlin or run the python script?

the automations exist of opening a template, inserting data in 1 sheet, running a macro on another sheet and saving it with a custom name.

If there is another channel I can/should ask this in please let me know

Afaik <https://www.easyxls.com> can read and write XLSB but is a commercial product

apache POI seems to have limited support for xlsb:
<https://poi.apache.org/apidocs/4.0/org/apache/poi/xssf/binary/package-summary.html>

apache poi only has read only support and also not supported