擅长:python、mysql、java
<p>如果文件真的很大,那么应该分块读取,以避免内存错误。在</p>
<p><strong>片段:</strong></p>
<pre><code>import pandas as pd
excel = pd.ExcelFile("File1.xlsx")
for sheet in excel.sheet_names:
reader = excel.parse(sheet, chunksize=1000):
for chunk in reader:
#parse chunk here
</code></pre>