Aspose Cell Python

Aspose.Cells Product Family
1

hi Team,

We are not seeing any method to close/dispose the workbook when we are working with excel operation.

Could you please advise ?

Regards,
Somjoy

2

@sr2989

Can you please specify which version of Aspose.Cells for Python you are using and provide more details about the operations you are performing on the workbook?

3

@sr2989,

Aspose.Cells does not necessarily need to release a process’s resources, as the component is already optimized to do this automatically. When an object (such as a Workbook or other related elements) is no longer useful in the process, it is collected and release the memory occupied by the object (although you may set the workbook to null/nothing). Additionally, if you are using a stream, you can close it to manually release the object’s resources when the object is no longer used.

4

We are using this version : aspose-cells-python==24.11.0

5

@sr2989
We will look into adding Workbook.Dispose() method to improve performance of releasing resource though .Net core will Auto GC.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSPYTHONNET-250

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

@sr2989
Generally speaking, for .NET, the Dispose method of a Workbook is automatically called when using the using statement. Similarly, in Python, the with statement can be used in conjunction, which will automatically call the Dispose method.

with aspose.cells.Workbook() as wb:
    wb.save("test.xlsx")

Hope helps a bit.

7

@sr2989
We have added the close() function, which serves the same purpose as the Dispose() function in .NET.
Please download the latest version 25.3.

workbook = Workbook()
... ...
workbook.close()