Python读excel内容并写入文件

import xlrd
from openpyxl import load_workbook
wb = load_workbook('D:/libra/try.xlsx')     #excel地址
f = open('D:/libra/print.c','w')            #打印输出文件地址
worksheet1 = wb.worksheets[0]         #读excel哪个sheet
rows1 = worksheet1.max_row            #有多少行
cols1 = worksheet1.max_column         #有多少列

for row in range(1,rows1+1):

    num = worksheet1.cell(row,1).value
    name = worksheet1.cell(row,2).value
    mark = worksheet1.cell(row, 3).value

    if(str(name) != 'None'):
        f.write('//num: ' + str(num)+'\t' + 'name: ' + str(name) + '\t')
    if (str(mark) != 'None'):
        f.write(str(mark))
    f.write('\n')


f.close()

excel如图：

打印结果如图：