[GH-ISSUE #106] Too many open files when adding lots of images #87

New issue

Closed

opened 2026-05-05 11:38:10 -06:00 by gitea-mirror · 2 comments

gitea-mirror commented

2026-05-05 11:38:10 -06:00

Owner

Originally created by @spulchtopek on GitHub (Jun 6, 2017).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/106

Originally assigned to: @jmcnamara on GitHub.

I am trying to generate a spreadsheet that has one or more columns of icons in addition to columns of text and numbers. I tried using the worksheet_insert_image() function to insert the icons (PNG images) into the column cells for the appropriate row.

It works fine as long as the number of total images is small. As soon as the number of images exceeds ~250, they are no longer added to the spreadsheet. I think is due to the number of open files limit in iOS.

It looks like the library keeps all of the image files open instead of just opening them when needed.

Originally created by @spulchtopek on GitHub (Jun 6, 2017). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/106 Originally assigned to: @jmcnamara on GitHub. I am trying to generate a spreadsheet that has one or more columns of icons in addition to columns of text and numbers. I tried using the `worksheet_insert_image()` function to insert the icons (PNG images) into the column cells for the appropriate row. It works fine as long as the number of total images is small. As soon as the number of images exceeds ~250, they are no longer added to the spreadsheet. I think is due to the number of open files limit in iOS. It looks like the library keeps all of the image files open instead of just opening them when needed.

gitea-mirror

2026-05-05 11:38:10 -06:00

closed this issue
added the
feature request

bug

short term
labels

gitea-mirror commented

2026-05-05 11:38:15 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jun 7, 2017):

Thanks for the report.

That is a bug. It should be a relatively easy fix.

@jmcnamara commented on GitHub (Jun 7, 2017): Thanks for the report. That is a bug. It should be a relatively easy fix.

gitea-mirror commented

2026-05-05 11:38:17 -06:00

Author

Owner

@jmcnamara commented on GitHub (Jun 27, 2017):

Fixed in version 0.7.0 on master and in Cocoapods.

@jmcnamara commented on GitHub (Jun 27, 2017): Fixed in version 0.7.0 on master and in Cocoapods.