去除多余空格,只需要加上newline=''即可,方法如下:
with open("new.csv","w",newline='')as f: csv.writer(f).writerow(sheet_title)
具体实例:https://www.cdsy.xyz/computer/programme/Python/241207/cd64826.html