CODEWITHSUNDEEP
pythonexcelxlwings
Thegamer23
Thegamer23

Reputation: 567

Xlwings: avoid to open the file

Is there any way to avoid the file to be opened while working with xlwings?

I have read there was an update going on one year ago but I do not know if the issue has been solved.

Upvotes: 3

Views: 6538

Answers (2)

Memmo
Memmo

Reputation: 268

According with Felix Zumstein, the solution lies in that documentation. Also I had this problem and I solved with the following line of code:

import xlwings
xlwings.App().visible = False

Personally, before I had other problems, even wider! And thanks to this solution I solved them.

Upvotes: 2

Felix Zumstein
Felix Zumstein

Reputation: 7070

As of version 0.10.4, xlwings is purely manipulating Excel files via a running Excel instance. That means, yes, you need to have your file open. You can set the Excel instance to visible=False, see here, but I doubt that this is what you want. To manipulate the files directly without Excel, you have to use xlrd/xlwt or xlsxwriter or openpyxl.

Upvotes: 5

Related Questions