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
xlwingslibrary. Image will be kept and I can work with .xlsb.