Is there a way to close a workbook using xlrd

Question

I am using the function open_workbook() to open an excel file. But I cannot find any function to close the file later in the xlrd module. Is there a way to close the xls file using xlrd? Or is not required at all?

It's been a couple years since I used xlrd, but I think it takes care of closing the file for you. — GreenMatt, Mar 23 '11 at 10:36

score 22 · Accepted Answer · answered Mar 23 '11 at 10:37

22

Digging into the mailing list archive, it seems that the file object is closed directly by the constructor, so you don't need to close it explicitly.

answered Mar 23 '11 at 10:37

Andrea Spadaccini

12,378
5
40
54

6

Note if you use on_demand=True the file is _not_ closed, even if the workbook is collected. This is documented in the xlrd comments. You should be careful to call release_resources() before letting the workbook go away. – Paul Du Bois Nov 23 '11 at 03:50

score 6 · Answer 2 · answered Mar 23 '11 at 10:44

6

The open_workbook calls the release_resources ( which closes the mmaped file ) before returning.

answered Mar 23 '11 at 10:44

Tripy

96
2

Is there a way to close a workbook using xlrd

2 Answers2

Linked