python操作xls表格csv表格

**excle**
#读数据
import xlrd;
wb=xlrd.open_workbook('1.xlsx');
sheet1 = wb.sheet_by_index(0);
print(sheet1.cell(0,0).value)

#写数据
import xlwt;
wb = xlwt.Workbook(encoding='utf-8');
sheet=wb.add_sheet('test');
sheet.write(0,0,'test');
wb.save('1.xls');

更多：https://www.cnblogs.com/chengxuyuanaa/p/12060400.html

**csv**
#读数据
import csv
file=open('IndicatorsExportSpace Science.csv')
reader=csv.reader(file)
for i in reader:
    print(i)