Linefeed lost when assign value to cell
Created originally on Bitbucket by mingyeh (Ming Yeh)
To anyone whom may concern,
I'm working on a script used to export data from SQL Server to Excel. Most of features are working as expected, until I tried to assign the SQL script to a cell via openpyxl.
The code is quite straightforward:
#!python
#Save SQL script
sqlSheet = wb.create_sheet(title='SQL', index=1)
sqlSheet['A1'].value = sql
wb.save(fileName)
print('Data saved as ' + fileName)
There are some line feeds and tab characters in the SQL script, but lost when assign it to cell .
I think it might be useful to add a feature to retain the line feed and tab characters when assign a string value to cell.
Thanks so much for the effort on this brilliant library, It really helps!