擅长:python、mysql、java
<p>您可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/io.html#io-excel-writer" rel="nofollow noreferrer">^{<cd1>}</a>执行此操作:</p>
<pre><code>import pandas as pd
data = (
('Shankar', '100', '100', '200'),
('Kumar', '50', '80', '130'),
('Shiva', '20', '20', '40'),
('Sekar', '20', '20', '40')
)
# Create a dataframe with the data of interest
df = pd.DataFrame(data=list(data), columns=['Name', 'Col1', 'Col2', 'Col3'])
# Export the dataframe to a XLSX file, in Worksheet `sheet1`,
# without the index nor the column names of the dataframe
df.to_excel('data.xlsx', sheet_name='sheet1', index=False, header=False)
</code></pre>
<p>这会将以下内容输出到<strong>数据.xlsx</strong>:</p>
<p><a href="https://i.stack.imgur.com/CMNJP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CMNJP.png" alt="enter image description here"/></a></p>