Writing a c# app to digest some old spreadsheets. When reading an Excel file that contains line feeds (by using Alt-Enter while in a cell), I can't seem to use "Worksheet.SaveAs" to save a CSV file. It treats the linefeed as a carriage return and a new cell.

Interop.Excel should recognize the linefeeds and remove them during the save. Sample Table and result

0

There are 0 best solutions below