openpyxlでexcelの読み書きを自動化…していいのかを考えよう - Qiita

import random with open("testdata_csv.csv", "w") as out_file: for _ in range(50000): out_file.write(",".join([str(random.randint(0, 1000)) for _ in range(100)]) + "\n") import openpyxl as xl import datetime as dt ROWS = 50000 COLS = 100 CHECK_INTERVAL = 10 def put_interval_to_csv(start: dt.datetime, end: dt.datetime, row_count, target): with open(f"log_{target}.csv", "a") as log_file: log_file.wri