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

_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Reply via email to