I am trying to process a spreadsheet with line feed/carriage return (CRLF) characters in a cell. There is a considerable amount of text in the cell as well. I'm converting the Excel spreadsheet to tab delimited text with:
sheet.SaveToFile(processFile, "\t", Encoding.UTF8);
The resulting text file has placed CRLF characters in the text file splitting the row into two rows. However, it appears to happen at 1024 characters. Is there any way to ensure that these rows don't get split by the CRLF's?