I have an export to excel where I enter the excel crlf character. All of that works fine but when I open the excel file the column is not formatted to handle crlf and I have to set it to Wrap Text manually. Is there any way to format this column with wrap text?
2 Answers, 1 is accepted
answered on 13 Dec 2016, 05:43 PM
To wrap the text of the desired cell you should find the respective cell, set its TextWrap property by hooking OnInfrastructureExporting exporting eventand insert the newline character ('\n') wherever you want the text to be wrapped. A sample code which presents header cell text wrapping is attached below: