擅长:python、mysql、java
<p>使用<code>xlsxwriter</code>模块来完成它,因为它很简单,<a href="http://xlsxwriter.readthedocs.io/worksheet.html" rel="nofollow noreferrer">have a look at the documentation</a></p>
<pre><code># Link to a cell on the current worksheet.
worksheet.write_url('A1', 'internal:Sheet2!A1')
# Link to a cell on another worksheet.
worksheet.write_url('A2', 'internal:Sheet2!A1:B2')
# Worksheet names with spaces should be single quoted like in Excel.
worksheet.write_url('A3', "internal:'Sales Data'!A1")
# Link to another Excel workbook.
worksheet.write_url('A4', r'external:c:\temp\foo.xlsx')
# Link to a worksheet cell in another workbook.
worksheet.write_url('A5', r'external:c:\foo.xlsx#Sheet2!A1')
# Link to a worksheet in another workbook with a relative link.
worksheet.write_url('A7', r'external:..\foo.xlsx#Sheet2!A1')
# Link to a worksheet in another workbook with a network link.
worksheet.write_url('A8', r'external:\\NET\share\foo.xlsx')
</code></pre>