將 kktix 的 csv 裡的檔案連結加工，讓 Google sheet 可以直接觀看圖片，方便檢驗身分

add_image.py

import csv
import argparse

# 使用 Python3
# python3 add_image.py 檔案路徑

URL_ROW_NAME = "聯絡人 學生資格資料"

parser = argparse.ArgumentParser(description="Input the csv file path.")
parser.add_argument('file_path', metavar="file path", type=str, nargs=1, help="the kktix csv local file path")

args = parser.parse_args()
file_path = args.file_path[0]
with open(file_path, newline="", encoding="utf-8") as csvfile:
    new_file_path = file_path.replace(".csv", "_new.csv")
    with open(new_file_path, "w", newline="", encoding="utf-8") as new_csvfile:
        reader = csv.DictReader(csvfile)
        fieldnames = reader.fieldnames
        writer = csv.DictWriter(new_csvfile, fieldnames=fieldnames)
        writer.writeheader()
        for row in reader:
            row[URL_ROW_NAME] = '=image("' + row[URL_ROW_NAME] + '")'
            writer.writerow(row)