I tried using openpyxl
library to read and write data in excel. But later did I know that I need to manipulate an excel binary worksheet. openpyxl
doesn't support xlsb
.
Is there any other libraries that I can use to be able to read and write data in xlsb
without changing any format of the excel?
The requirement is, as much as possible:
- Append data at the last row (Don't rewrite the whole data as it will affect the runtime of script).
- Don't convert the
xlsb
Thank you in advance.
I used
xlwings
library. Image will be kept and I can work with .xlsb.