"TypeError: Unsupported Type In Write()"

I wish to print 'out.csv' data in excel file when the condition is not uppercase. But the data in out.csv is list of data instead of string. How do I write the list to excel file w

Solution 1:

How do I write the list to excel file without converting it to string

You could either loop over the list and write() out each element or you could use the XlsxWriter write_row() method to write the list in one go.

Something like this:

row = 0
col = 0
for module in data:
    str1 = ''.join(module)
    if str1.isupper():
        pass
    else:
        worksheet.write_row(row, col, module)
        row += 1