Excel文件转Asc文件

单个转换

import os
import pandas as pd

filename = '(10)result01-1.xlsx'
df = pd.read_excel(filename)  # 读取Excel文件

# 将数据保存为ASC格式
asc_filename = os.path.splitext(filename)[0] + '.asc'  # 获取文件名并替换扩展名
with open(asc_filename, 'w') as file:
    # 写入文件头
    file.write('NCOLS {}\n'.format(df.shape[1]))  # 列数
    file.write('NROWS {}\n'.format(df.shape[0]))  # 行数
    file.write('XLLCENTER {}\n'.format(0))  # X轴坐标起始值
    file.write('YLLCENTER {}\n'.format(0))  # Y轴坐标起始值
    file.write('CELLSIZE {}\n'.format(1))  # 单元格大小
    file.write('NODATA_VALUE {}\n'.format(-9999))  # 无效值

    # 写入数据
    for i in range(df.shape[0]):
        row = df.iloc[i]
        row_str = ' '.join([str(x) for x in row.values])
        file.write(row_str + '\n')

 批量转换(指定目录批量转换，且转换文件也在指定目录下)

import os
import pandas as pd

folder_path = 'F:/data'  # 文件夹路径
for filename in os.listdir(folder_path):
    if filename.endswith('.xlsx'):
        # 读取Excel文件
        df = pd.read_excel(os.path.join(folder_path, filename))

        # 将数据保存为ASC格式
        asc_filename = os.path.splitext(filename)[0] + '.asc'  # 获取文件名并替换扩展名
        asc_path = os.path.join(folder_path, asc_filename)  # 获取保存ASC文件的路径
        with open(asc_path, 'w') as file:
            # 写入文件头
            file.write('NCOLS {}\n'.format(df.shape[1]))  # 列数
            file.write('NROWS {}\n'.format(df.shape[0]))  # 行数
            file.write('XLLCENTER {}\n'.format(0))  # X轴坐标起始值
            file.write('YLLCENTER {}\n'.format(0))  # Y轴坐标起始值
            file.write('CELLSIZE {}\n'.format(1))  # 单元格大小
            file.write('NODATA_VALUE {}\n'.format(-9999))  # 无效值

            # 写入数据
            for i in range(df.shape[0]):
                row = df.iloc[i]
                row_str = ' '.join([str(x) for x in row.values])
                file.write(row_str + '\n')

注意:

如果转换后不想要 以下内容

NCOLS 3
NROWS 169
XLLCENTER 0
YLLCENTER 0
CELLSIZE 1
NODATA_VALUE -9999

直接注释代码中的以下内容

file.write('NCOLS {}\n'.format(df.shape[1]))  # 列数
file.write('NROWS {}\n'.format(df.shape[0]))  # 行数
file.write('XLLCENTER {}\n'.format(0))  # X轴坐标起始值
file.write('YLLCENTER {}\n'.format(0))  # Y轴坐标起始值
file.write('CELLSIZE {}\n'.format(1))  # 单元格大小
file.write('NODATA_VALUE {}\n'.format(-9999))  # 无效值

转换前后(前面是excel数据),后面是asc文件数据