import glob
import pandas as pd
def extract_lines_from_txt_files(file_pattern, target_wavelength):
    # 獲取符合文件模式的txt文件路徑列表
    file_paths = glob.glob(file_pattern)
    results = []
    for file_path in file_paths:
        with open(file_path, 'r') as file:
            lines = file.readlines()
            # 提取包含目標波長的行
            target_lines = []
            for line in lines:
                if target_wavelength in line:
                    target_lines.append(line.strip())
            # 添加文件路徑和提取結(jié)果到列表
            results.append({'File': file_path, 'Lines': target_lines})
    return results
# 設(shè)置文件模式和目標波長
file_pattern = 'D:\\Users\\DELL\\Desktop\\test\\VIS=5\\*.txt'    # 根據(jù)實際的列名或波長進行設(shè)置
target_wavelength = '21321'  # 設(shè)置特定波長的字符串
# 調(diào)用函數(shù)提取行數(shù)
output = extract_lines_from_txt_files(file_pattern, target_wavelength)
# 創(chuàng)建DataFrame對象
df = pd.DataFrame(output)
# 保存結(jié)果到Excel文件
output_file = 'D:\\Users\\DELL\\Desktop\\PDF\\result.xlsx'  # 設(shè)置輸出文件路徑和名稱
df.to_excel(output_file, index=False)
print(f"提取結(jié)果已保存到 {output_file}")

# -*- coding: utf-8 -*-
"""
Created on Mon Nov 21 2022
@author: MMG
"""
# coding=utf-8
import os
path = "E:\\Program Files\\Nimbostratus cloud_100"
# new_path = "E:\\Program Files\\Mod5.2.2\\rural=5_view=136\\1"
def listfiles(dirpath):
    filelist = []
    for root, dirs, files in os.walk(dirpath):
        for fileObj in files:
            filelist.append(os.path.join(root, fileObj))
    return filelist
def main():
    filelist = listfiles(path)
    for fileobj in filelist:
        f = open(fileobj, 'r+')
        lines = f.readlines()
        f.seek(0)
        f.truncate()
        for line in lines:
            f.write(line. Replace('45.50000'#原文本,'5.000000'#改過后的數(shù)值))
        f.close()
if __name__ == main():
    main()