擅长:python、mysql、java
<p>用熊猫的另一种方法</p>
<pre><code>import pandas as pd
excel = pd.read_excel('file1.xlsx', header=None)
writer = pd.ExcelWriter('file2.xlsx')
excel.loc[:99, :25].to_excel(writer, 'sheet1', index=False, header=False)
</code></pre>
<p>添加只包含数据的openpyxl解决方案</p>
<pre><code>wb = openpyxl.load_workbook('file1.xlsx', data_only=True)
wb1 = openpyxl.load_workbook('file2.xlsx')
sheet = wb['R']
sheet1 = wb1['Rt']
for row in sheet['A1':'Z100']:
for cell in row:
sheet1[cell.coordinate].value = cell.value
wb1.save('file2.xlsx')
</code></pre>
<p><strong>编辑</strong></p>
<p>cell.coordinate返回类似“A1”的值,然后sheet1[“A1”]。value是单元格A1的值</p>