How to export data from Python to CSV files that can be read in Excel

This article mainly introduces how to export data from Python to a CSV file that can be read by Excel, and how to design the skills related to using Python to Operate Excel, for more information about how to export data from Python to CSV files that can be read in Excel, see the following example. Share it with you for your reference. The specific implementation method is as follows:

Import csvwith open('eggs.csv ', 'wb') as csvfile: # spamwriter = csv. writer (csvfile, delimiter = '', quotechar = '|', # quoting = csv. QUOTE_MINIMAL) spamwriter = csv. writer (csvfile, dialect = 'excel ') spamwriter. writerow (['spam'] * 5 + ['baked Beans ']) spamwriter. writerow (['spam', 'lovely spam', 'Wonderful spam'])

I hope this article will help you with Python programming.