1 2 3 4 5 6 7 8 9 10 |
import numpy as np xls = pd.ExcelFile('aa.xlsx') df = xls.parse('Sheet1') df2 = xls.parse('Sheet2') xls.sheet_names # see all sheet names xls.parse(sheet_name) # read a specific sheet to DataFrame df.to_csv('cc.csv',encoding=('utf-8')) #写入csv中 |

