python 数据分析基础 day6－xlrd,xlwt读写单个excel

"""
基础python获取exel数据
"""
import xlrd
import xlwt

inputExcel="输入的excel文件"
outputExcel="输出的excel文件"
outputWorkbook=xlwt.Workbook()
outputWorksheet=outputWorkbook.add_sheet("test")
with xlrd.open_workbook(inputExcel) as inputWorkbook:
    inputWorksheet=inputWorkbook.sheet_by_name("january_2013")
    for row in range(inputWorksheet.nrows):
        for col in range(inputWorksheet.ncols):
            outputWorksheet.write(row,col,inputWorksheet.cell_value(row,col))
outputWorkbook.save(outputExcel)