csv编码处理

#!/usr/bin/env python
# -*- coding: UTF-8 -*-
import csv
import codecs
with open('test.csv', 'w', encoding='utf-8', newline='') as csvfile: 
    csvfile.write(codecs.BOM_UTF8.decode('utf-8') )
    spamwriter = csv.writer(csvfile, dialect='excel') 
    spamwriter.writerow(['测试'] * 5 + ['Baked Beans'])
    spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])