可否使用ACCESS快捷拆分成多个EXCEL文件?
python
import pandas as pd
df = pd.read_csv('ur csv file path')
size = 10000#modify it to the size u want
num = int(df.shape[0]/size)
for i in range(0, num)
df.iloc[size*i:size*(i+1), :].to_excel('data'+str(i)+'.xls')
df.iloc[size*num:, :].to_excel('data'+str(num)+'.xls')