prevent import of control chars

I inherited an Excel spreadsheet.
The Excel file has many sheets.
It has some 0x0a LineFeed control chars in strings.
I can remove them search (regex) for '\n' and replace with nothing.

Is there a way to remove the LineFeed on import?
Or using ssconvert to save as text?

The following works great to export each sheet as a file, except for the unwanted LineFeed chars.

ssconvert -O 'format=raw separator=;' -S book.xlsx %s.txt

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]