[GH-ISSUE #2] Feature request: Add option to close worksheets without closing workbook #2

Closed
opened 2026-05-05 11:22:52 -06:00 by gitea-mirror · 6 comments
Owner

Originally created by @LaurinStrelow on GitHub (Feb 24, 2015).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/2

Originally assigned to: @jmcnamara on GitHub.

Hi,

it would be great to have the possibility to close worksheets. This avoids to reach the file limit with arbitrary large workbooks.

Thanks!

Originally created by @LaurinStrelow on GitHub (Feb 24, 2015). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/2 Originally assigned to: @jmcnamara on GitHub. Hi, it would be great to have the possibility to close worksheets. This avoids to reach the file limit with arbitrary large workbooks. Thanks!
gitea-mirror 2026-05-05 11:22:52 -06:00
Author
Owner

@LaurinStrelow commented on GitHub (Jun 18, 2015):

Hi,

is there something new on this? I get complaints from users, who run into this issue (Anything else is working great!). Are you planning to fix this soon? If not i can try to find a solution.

<!-- gh-comment-id:113219591 --> @LaurinStrelow commented on GitHub (Jun 18, 2015): Hi, is there something new on this? I get complaints from users, who run into this issue (Anything else is working great!). Are you planning to fix this soon? If not i can try to find a solution.
Author
Owner

@jmcnamara commented on GitHub (Jun 20, 2015):

Hi Laurin,

If there isn't an update to this issue then there hasn't been anything new.

To be honest this is a low priority issue for me. I find it hard to see why people need to produce workbooks with 1000+ worksheets (or whatever their ulimit is) or that they can't increase the ulimit if they do.

So if you can find a solution, such as increasing the system ulimit, then please do.

John

<!-- gh-comment-id:113737836 --> @jmcnamara commented on GitHub (Jun 20, 2015): Hi Laurin, If there isn't an update to this issue then there hasn't been anything new. To be honest this is a low priority issue for me. I find it hard to see why people need to produce workbooks with 1000+ worksheets (or whatever their ulimit is) or that they can't increase the ulimit if they do. So if you can find a solution, such as increasing the system ulimit, then please do. John
Author
Owner

@wangjinbao123 commented on GitHub (Jul 19, 2015):

hi,can you help me to use it in ios ? ios only relationship libz1.2.5,how can I to solution

<!-- gh-comment-id:122618574 --> @wangjinbao123 commented on GitHub (Jul 19, 2015): hi,can you help me to use it in ios ? ios only relationship libz1.2.5,how can I to solution
Author
Owner

@jmcnamara commented on GitHub (Jul 20, 2015):

@wangjinbao123 You shouldn't ask a new question on an older issue. If you have a new question please open a new issue.

See the following in relation to your question Building libxlsxwriter for iOS.

<!-- gh-comment-id:123039366 --> @jmcnamara commented on GitHub (Jul 20, 2015): @wangjinbao123 You shouldn't ask a new question on an older issue. If you have a new question please open a new issue. See the following in relation to your question [Building libxlsxwriter for iOS](http://kvurd.com/blog/building-libxlsxwriter-for-ios/).
Author
Owner

@LaurinStrelow commented on GitHub (Jul 29, 2015):

Hi there,

@jmcnamara I fully understand you. The worksheet is generated automatically from an input set and therefore the limit can be reached easier. In the meantime i have developed a fix for this problem, wich is working good so far. However getting the temp directory relies on the objc runtime and therefore this is no general solution. If you are interested i can open a pull request (This can take a month since i am busy atm).

@wangjinbao123 You better open a new issue where we can discuss the problem and possible solutions.

<!-- gh-comment-id:125859540 --> @LaurinStrelow commented on GitHub (Jul 29, 2015): Hi there, @jmcnamara I fully understand you. The worksheet is generated automatically from an input set and therefore the limit can be reached easier. In the meantime i have developed a fix for this problem, wich is working good so far. However getting the temp directory relies on the objc runtime and therefore this is no general solution. If you are interested i can open a pull request (This can take a month since i am busy atm). @wangjinbao123 You better open a new issue where we can discuss the problem and possible solutions.
Author
Owner

@jmcnamara commented on GitHub (Jan 4, 2023):

Closing as can't/won't fix. It can be worked around on some systems by using the USE_MEM_FILE compilation option.

<!-- gh-comment-id:1370708223 --> @jmcnamara commented on GitHub (Jan 4, 2023): Closing as can't/won't fix. It can be worked around on some systems by using the `USE_MEM_FILE` compilation option.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#2
No description provided.