flow2k added the comment:
Okay, thanks for pointing to the doc. I did not expect the line termination to
affect escaping, but I can see why these may be related.
Per your comment, I've added quoting=csv.QUOTE_NONNUMERIC. Instead of Excel, I
am using Gdocs, and this escaping enables Gsheets
New submission from flow2k :
output = io.StringIO()
csvData = [1, 2, 'a', 'He said "what do you mean?"', "Whoa!\rNewlines!"]
writer = csv.writer(output,lineterminator='\n')
writer.writerow(csvData)
print(repr(output.getvalue())) #does not escape \r as expected
--
m
