擅长:python、mysql、java
<p>出于我在评论中提到的原因,这里有一个可能的解决方法:</p>
<pre><code>from xlrd import open_workbook
import xlsxwriter
wb = open_workbook('BBDD_POLAROID_TOTAL.xlsx')
excel_num = 0
print('ARCHIVO: ' + str(excel_num))
workbook = xlsxwriter.Workbook('BBDD' + str(excel_num) + '.xlsx')
worksheet = workbook.add_worksheet()
for s in wb.sheets():
number_of_rows = s.nrows
for row in range(0, number_of_rows):
if row % 300 == 0:
if row == 0:
print(str(row) + s.cell(row, 0).value)
worksheet.write(row%300, 0, s.cell(row, 0).value)
else:
print('close: ' + str(excel_num))
workbook.close()
excel_num += 1
print('ARCHIVO: ' + str(excel_num))
workbook = xlsxwriter.Workbook('BBDD' + str(excel_num) + '.xlsx')
worksheet = workbook.add_worksheet()
print('all good: ' + str(excel_num))
print(str(row) + ' ' + s.cell(row, 0).value)
worksheet.write(row%300, 0, s.cell(row, 0).value)
workbook.close()
</code></pre>