擅长:python、mysql、java
<p>xlsxwriter链接:</p>
<p><a href="https://xlsxwriter.readthedocs.org/en/latest/contents.html" rel="noreferrer">https://xlsxwriter.readthedocs.org/en/latest/contents.html</a></p>
<p>借助此功能,您可以使用<strong>.xlsx</strong>和<strong>.xls</strong>生成excel文件</p>
<p>例如,excel文件生成的名称是<strong>trial.xls</strong></p>
<p><strong>如果要生成该excel文件的pdf,请执行以下操作:</strong></p>
<pre><code>from win32com import client
xlApp = client.Dispatch("Excel.Application")
books = xlApp.Workbooks.Open('C:\\excel\\trial.xls')
ws = books.Worksheets[0]
ws.Visible = 1
ws.ExportAsFixedFormat(0, 'C:\\excel\\trial.pdf')
</code></pre>