python中excel 中的读写，追加操作。仅供参考。没有时间整理

import xlrd
import xlsxwriter

# work_book = xlrd.open_workbook("12010219801201332X王桂玉.xlsx")
# sheet_names = work_book.sheet_names()
# print(sheet_names)
# # sheet_content = work_book.sheet_names(sheet_names[0])
# sheet_content = work_book.sheet_by_name(sheet_names[0])
# print(sheet_content)
# nrows = sheet_content.nrows
# ncols = sheet_content.ncols
# print(nrows)
# print(ncols)
# for i in range(0,3):
#     # for j in range(0,ncols):
#     # print(sheet_content.row(i))
#
#     # print(sheet_content.row(i)[0],end=' ')
#     # print(sheet_content.row(i)[1],end=' ')
#     # print(sheet_content.row(i)[2],end=' ')
#     # print(sheet_content.row(i)[3],end=' ')
#     # print(sheet_content.row(i)[4],end=' ')
#     # print(sheet_content.row(i)[5],end=' ')
#     # print(sheet_content.row(i)[6],end=' ')
#     # print(sheet_content.row(i)[7],end=' ')
#     # print(sheet_content.row(i)[8],end=' ')
#     # print(sheet_content.row(i)[9],end=' ')
#     # print(sheet_content.row(i)[10],end=' ')
#
#     print(sheet_content.row_values(i))
#     print(sheet_content.row(i))
#     # print()


'''
['缴费单位', '缴费年月', '费款所属年月', '缴费基数', '单位划入统筹', '单位划入个人账户', '个人缴纳统筹', '个人缴纳金额', '缴费合计', '划入个人账户', '备注']
[text:'缴费单位', text:'缴费年月', text:'费款所属年月', text:'缴费基数', text:'单位划入统筹', text:'单位划入个人账户', text:'个人缴纳统筹', text:'个人缴纳金额', text:'缴费合计', text:'划入个人账户', text:'备注']
['渤海石油(临时1)', '200306', '200303', '2244', '381.48', '67.32', '0', '179.52', '628.32', '246.84', '']
[text:'渤海石油(临时1)', text:'200306', text:'200303', text:'2244', text:'381.48', text:'67.32', text:'0', text:'179.52', text:'628.32', text:'246.84', empty:'']
['渤海石油(临时1)', '200306', '200304', '2244', '381.48', '67.32', '0', '179.52', '628.32', '246.84', '']
[text:'渤海石油(临时1)', text:'200306', text:'200304', text:'2244', text:'381.48', text:'67.32', text:'0', text:'179.52', text:'628.32', text:'246.84', empty:'']

'''

'''
xlsxwriter写入excel .xlsx 格式，可以写入。不能追加
'''
namesec = "学生信息"+"2143242"+".xlsx"
# work_booksec = xlsxwriter.Workbook(namesec)
# sheetsec = work_booksec.add_worksheet("小明学生信息表")
# head = ['缴费单位', '缴费年月', '费款所属年月', '缴费基数', '单位划入统筹', '单位划入个人账户', '个人缴纳统筹', '个人缴纳金额', '缴费合计', '划入个人账户', '备注']
# data=[
#     # [text:'缴费单位', text:'缴费年月', text:'费款所属年月', text:'缴费基数', text:'单位划入统筹', text:'单位划入个人账户', text:'个人缴纳统筹', text:'个人缴纳金额', text:'缴费合计', text:'划入个人账户', text:'备注'],
#     ['渤海石油(临时1)', '200306', '200303', '2244', '381.48', '67.32', '0', '179.52', '628.32', '246.84', ''],
#     # [text:'渤海石油(临时1)', text:'200306', text:'200303', text:'2244', text:'381.48', text:'67.32', text:'0', text:'179.52', text:'628.32', text:'246.84', empty:''],
#     ['渤海石油(临时1)', '200306', '200304', '2244', '381.48', '67.32', '0', '179.52', '628.32', '246.84', ''],
#     # [text:'渤海石油(临时1)', text:'200306', text:'200304', text:'2244', text:'381.48', text:'67.32', text:'0', text:'179.52', text:'628.32', text:'246.84', empty:''],
# ]
# for i in range(len(head)):
#     sheetsec.write(0,i,head[i])
#
# for i in range(len(data)):
#     for j in range(len(head)):
#         sheetsec.write(i+1,j,data[i][j])
#
# work_booksec.close()

# namesec = "学生信息"+"2143242"+".xlsx"



namesec = "学生信息"+"2143242"+".xlsx"


info = [['渤海石油(临时1)', '20030226', '200303', '2244', '381.48', '67.32', '0', '179.52', '628.32', '246.84', ''],]

'''
 openpyxl下标从1开始
'''
import openpyxl
import os
path = os.path.dirname(os.path.abspath(__file__))
print(path+'\'+namesec)
xfile = openpyxl.load_workbook(path+'\'+namesec)
sheetnames = xfile.sheetnames
print(sheetnames)
sheet1 = xfile.worksheets[0]
rows = sheet1.max_row
cols = sheet1.max_column
print(rows,cols)
print(len(info[0]))

for i in range(len(info[0])):
    sheet1.cell(rows+1,i+1).value=info[0][i]

xfile.save(path+'\'+namesec)