Hello All,
does anybody know how can I export text from DSE and preserve the formatting defined by HTML tags?
The use case is following:
1) I have a grid with fields where text can be formatted (bold, italic, underline, strikethrough text)
2) Formatted text is added thru the component richTextField from plugin created by Appian, which provides with a simple editor for rich text.
3) Formatted text is saved in DB as HTML text and it is converted to Rich Text display field only for displaying.
4) Customer is requesting the function which exports the data to Excel file and also preservers the formatting.
5) The export process works fine, but Excel does not correctly interpret HTML tags used for formatting. It is imported as a pure text.
This is the process model that I use.
Any advices on how to solve this case?
Thank you,
Michal
Discussion posts and replies are publicly visible
Hi Michal, the functions we have available to export data to Excel are notorious for removing any formatting. The only node I could suggest to try is unfortunately deprecated - "Export CDT to Excel" as part of the Excel Tools plugin. You will see around this forum that some of us have still had to apply this node in some situations, since we do not have this exact functionality OOTB. I'm not positive if it would solve your use case, nor do I know when it will be removed, but I do still have it running in a few production apps on 20.3.
Thank you for reply. I will try Export CDT to Excel, but I don't expect any miracles.