How Python saves a CSV file that cancels empty lines

In Python, when an SCV file is saved in the usual way (which can be read by Excel), when opened with Excel, it is inevitable that there is a blank line on every other line, and manual removal is cumbersome.

However, if you add a parameter when you store the file, you can cancel the empty line:

Example:

def save_csvfile (CSVData, Filename):
With open (Filename, "w", newline = "") as CSVFile:
writer = Csv.writer (csvfile, dialect = ' Excel ')
Writer.writerows (CSVData)
Csvfile.close ()

The key is: newline = ""

How Python saves a CSV file that cancels empty lines