K
K
Kostya122019-06-10 20:03:54
Python
Kostya12, 2019-06-10 20:03:54

How to open a file with openpyxl?

In general, you need to work with .xlsm file through Python. Googling realized that I need openpyxl.
But the problem is the simplest, I try to open the file, but it opens terribly slowly (10 minutes). At the same time, if you open it in readonly mode, then everything works fine and quickly. Maybe it's because the file is .xlsm and not .xls? If so, then tell me which is better to use. I would be grateful for help
wb = openpyxl.load_workbook(file, keep_vba=True)

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question