Writing multi-line strings to cells using xlwt module
Question: Python: Is there a way to write multi-line strings into an excel cell with
just the xlwt module? (I saw answers suggesting use of openpyxl module)

The `sheet.write()` method ignores the \n escape sequence. So, just xlwt, is
it possible? Thanks in advance.


Answer: I found the answer in the [python-excel Google
Group](https://groups.google.com/d/topic/python-excel/9eMr2npsKXY/discussion).
Using `sheet.write()` with the optional `style` argument, enabling word wrap
for the cell, does the trick. Here is a minimum working example:

    
    
    import xlwt
    book = xlwt.Workbook()
    sheet = book.add_sheet('Test')
    
    # A1: no style, no wrap, despite newline
    sheet.write(0, 0, 'Hello\nWorld')
    
    # B1: with style, there is wrap
    style = xlwt.XFStyle()
    style.alignment.wrap = 1
    sheet.write(0, 1, 'Hello\nWorld', style)
    book.save('test.xls')
    

While in cell A1 shows `HelloWorld` without linebreak, cell B1 shows
`Hello\nWorld` (i.e. with linebreak).

