擅长:python、mysql、java
<p>从代码来看,xlwt似乎只支持24位位图图像。</p>
<p>Python模块可以插入PNG图像(或JPEG或位图)。下面是一个例子:</p>
<pre><code>from xlsxwriter.workbook import Workbook
# Create an new Excel file and add a worksheet.
workbook = Workbook('images.xlsx')
worksheet = workbook.add_worksheet()
# Widen the first column to make the text clearer.
worksheet.set_column('A:A', 30)
# Insert an image.
worksheet.write('A2', 'Insert an image in a cell:')
worksheet.insert_image('B2', 'python.png')
workbook.close()
</code></pre>
<p>输出:</p>
<p><img src="https://i.stack.imgur.com/zavfS.png" alt="XlsxWriter Image example"/></p>
<p>有关详细信息,请参见<a href="https://xlsxwriter.readthedocs.org/en/latest/worksheet.html#insert_image" rel="noreferrer">relevant section of the docs</a>。</p>