写入excel（openpyxl）

写入excel（openpyxl）

csv、excel写入

    import openpyxl
    workbook = openpyxl.Workbook()
    name_ss = globals()
    VI2 = ['NDVI','RATIO','SWIR','NIR']
    for i in range(1,9):
        filename = "第"+str(i)+"类"
        worksheet = workbook.create_sheet(filename)
        l = len(name_ss['L'+ str(i) +'_' + 'NDVI'])
        for c in range(1,5):
            for j in range(1,l+1):
                va = name_ss['L'+ str(i) +'_' + VI2[c-1]] 
                worksheet.cell(row = 1, column = 1 ).value = '序号'
                worksheet.cell(row = 1, column = c + 1  ).value = VI2[c-1]
                worksheet.cell(row = j + 1, column = 1 ).value = j 
                worksheet.cell(row = j + 1, column = c + 1 ).value = va[j-1]
    workbook.save(r'G:**\**\*****.csv')