近期在做大批量提交的作用，大批量提交使用的是以分号做为分节符的csv文件。在产品测试为了更好地检测大批量提交的作用，*须大批量的信息实现检测。

这个时候我便想起还可以使用Python转化成csv开展检测。

*，在PyCharm中挑选 File -> New -> Python File

特定文件夹名称 例如 generate_CSV_file.py

下面便是敲代码了：

import csv

import osdef generate_csv():

current_dir = os.path.abspath('.')

file_name = os.path.join(current_dir, "generated_800rows.csv") # open file in binary model to avoid generate empty line in Windows

csvfile = open(file_name, 'ab ') writer = csv.writer(csvfile, delimiter=',') header = ['Scheduled KPI Plan name', 'Description', 'Plan Type', 'Visibility', 'Location Filter',

'Resource Filter', 'Time Filter', 'Calculation Model', 'Alert_Rule_Group',

'Multi_Attribute_Filter', 'RECURRENCE_TYPE', 'Execute Every', 'Executed On',

'Start Scheduling Date/Time', 'End Scheduling Date/Time'] writer.writerow(header)

rows = []

one_row = [] index_of_rows = 0 while (index_of_rows < 400): index_of_rows = index_of_rows 1 one_row = ['KPITST_MAR5_' str(index_of_rows), 'Test 20190619', 'Scheduled KPI Plan', 'Global', 'BUSER2_GLOBAL', 'ATP_RF_1', 'PF_HAN', 'ATP_KPI_CALMODEL', 'ATP_KPI_ALERTS_GP', '', 'Minutes', 5, '', '2019-07-05T08:00:00.000Z', '2019-12-13T08:00:00.000Z'] rows.append(one_row) while (index_of_rows < 800): index_of_rows = index_of_rows 1 one_row = ['KPITST_MAR5_' str(index_of_rows), 'Test 20190619', 'Scheduled KPI Plan', 'Global', 'BU_CREATED_GLOBAL', 'BUSER2_GLOBAL', 'ATP_PAST1', 'ATP_KPI_CALMODEL', 'ATP_KPI_ALERTS_GP', '', 'Days', 1, '', '2019-07-12T08:00:00.000Z', '2019-10-13T08:00:00.000Z'] rows.append(one_row) writer.writerows(rows); csvfile.close() if ._name._ == '._main._': generate_csv()

进行编码后，鼠标右键-> Run 该py 文档。

运作取得成功后，便会形成一个.csv文件，默认设置储存部位是

开启转化成的csv文件，能够看见该csv文件的**行是header。