# https://www.globalsino.com/ICs/page4853.html
# sniff

import csv

with open('C:\GlobalSino\images\TestImages\Excel\MyTest_x_y.csv', newline='') as csvfile:
    dialect = csv.Sniffer().sniff(csvfile.readline(), [',',';'])
    csvfile.seek(0)
    reader = csv.reader(csvfile, dialect)
    for row in reader:
        print(row)