Python处理envi导出的光谱曲线txt文件写入excel

最新推荐文章于 2023-05-23 10:32:58 发布

Hexk_

最新推荐文章于 2023-05-23 10:32:58 发布

阅读量858

点赞数

分类专栏： ENVI 文章标签： python excel 开发语言

本文链接：https://blog.csdn.net/Asphy/article/details/127420732

版权

ENVI 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

import xlwt

with open('I:地物纹理曲线.txt', 'r') as f:
    i = 0
    data_list = []
    while True:
        line = f.readline()
        if i < 8:
            i += 1
            continue
        elif not line:
            break
        else:
            data_list.append(line)
    excel_table = xlwt.Workbook()
    sheet1 = excel_table.add_sheet(u'Sheet1', cell_overwrite_ok=True)
    sheet1.write(0, 0, 'Bands')
    sheet1.write(1, 0, '互花米草')
    sheet1.write(2, 0, '建筑')
    sheet1.write(3, 0, '泥沙水体')
    sheet1.write(4, 0, '普通水体')
    sheet1.write(5, 0, '互花米草(水)')
    sheet1.write(6, 0, '沙土植被')
    for index, item in enumerate(data_list):
        result = item.strip().split()
        '''with open('I:地物纹理曲线_new.txt', 'a+') as w:
            for j in result:
                w.write(j + '\n')
            w.write('\n')'''
        for j_index, j_item in enumerate(result):
            sheet1.write(j_index, index+1, float(j_item))
    excel_table.save('I:地物纹理曲线.xls')