大数据可视化 读取某一列数据和添加数据
#读取某一列和添加数据
import xlsxwriter
xl = xlsxwriter.Workbook(r'D:\pycharm\pythonProject\99.xlsx')
sheet = xl.add_worksheet('xieru')
sheet.write_row('A1','学号','姓名','性别','班级','年龄')
sheet.write_row("A2",(1,'张明','男','01','16'))
sheet.write_row("A3",(2,'李四','男','01','17'))
sheet.write_row("A4",(3,'王五','男','02','18'))
sheet.write_row("A5",(4,'赵四','女','02','19'))
xl.close()
import xlrd
wb = xlrd.open_workbook('99.xlsx')
ws = wb.sheet_by_name('xieru')
a = ws.row_values(1)
print(a)