python - Xlsxwriter 调整标题图片大小

Question

我在 header.jpeg 中有一张图片

我想将该图像设置为 excel 文件的标题。我正在使用模块 pandas、numpy 和 xlsxwriter

代码是这样的

image_file = open('header.jpeg', 'rb')
image_data = xlsxwriter.compatibility.BytesIO(image_file.read())

worksheet.set_header('&C&G', {'image_center': 'header.jpeg','image_data_left': image_data})

它也适用于

worksheet.set_header('&C&G', {'image_center': 'header.jpeg'})

如何调整页眉中图片的大小，比方说它的高度增加 80%？

根据文档我发现我可以使用

http://xlsxwriter.readthedocs.io/page_setup.html

The available options are:

margin: (float) Header margin in inches. Defaults to 0.3 inch.image_left: (string) The path to the image. Needs &G placeholder.image_center: (string) Same as above. image_right: (string) Same asabove. image_data_left: (BytesIO) A byte stream of the image data.image_data_center: (BytesIO) Same as above. image_data_right:(BytesIO) Same as above. scale_with_doc: (boolean) Scale header withdocument. Defaults to True. align_with_margins: (boolean) Align headerto margins. Defaults to True.

谢谢

Answer 1

How can I resize the image in the header, let's say its height by 80%?

XlsxWriter 当前不支持该功能。您可以打开一个功能请求，我会考虑添加它。

或者，您可以使用其他应用程序或模块缩小图像。