[GH-ISSUE #85] Fit image to cell #72

New issue

Closed

opened 2026-05-05 11:36:27 -06:00 by gitea-mirror · 1 comment

gitea-mirror commented

2026-05-05 11:36:27 -06:00

Owner

Originally created by @iamabhiee on GitHub (Jan 4, 2017).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/85

Originally assigned to: @jmcnamara on GitHub.

Library seems really good, I am trying to fit image to cell but I couldn't find a way, whats best way to do the same?

Originally created by @iamabhiee on GitHub (Jan 4, 2017). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/85 Originally assigned to: @jmcnamara on GitHub. Library seems really good, I am trying to fit image to cell but I couldn't find a way, whats best way to do the same?

gitea-mirror

2026-05-05 11:36:28 -06:00

closed this issue
added the
question
label

gitea-mirror commented

2026-05-05 11:36:35 -06:00

Author

Owner

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

Hi Abhishek,

The best, and only, way is to scale the image with the worksheet_insert_image_opt() function to fit into a standard Excel cell size of 20x64 pixels:

lxw_image_options options = {.x_offset = 30,  .y_offset = 10,
                             .x_scale  = 0.5, .y_scale  = 0.5};
worksheet_insert_image_opt(worksheet, 2, 1, "logo.png", &options);

See the docs for worksheet_insert_image_opt(): http://libxlsxwriter.github.io/worksheet_8h.html#a0b05e75e2c2a5c3452374714cdb2b79b

John

@jmcnamara commented on GitHub (Jan 4, 2017): Hi Abhishek, The best, and only, way is to scale the image with the `worksheet_insert_image_opt()` function to fit into a standard Excel cell size of 20x64 pixels: ```C lxw_image_options options = {.x_offset = 30, .y_offset = 10, .x_scale = 0.5, .y_scale = 0.5}; worksheet_insert_image_opt(worksheet, 2, 1, "logo.png", &options); ``` See the docs for `worksheet_insert_image_opt()`: http://libxlsxwriter.github.io/worksheet_8h.html#a0b05e75e2c2a5c3452374714cdb2b79b John

gitea-mirror referenced this issue

2026-05-05 12:15:13 -06:00

[PR #72] [MERGED] Fix debug assertation. #410

gitea-mirror referenced this issue

2026-05-05 12:15:14 -06:00

[PR #78] [CLOSED] errors fixed, added new features #412