reactable icon indicating copy to clipboard operation
reactable copied to clipboard

Exporting to XLSX: keeping text formatting

Open werkstattcodes opened this issue 4 years ago • 1 comments

This is related to issue #194.

The reactable I am regularly using/sharing contains data which is color coded, i.e. certain words in a text field have specific colors (using e.g. <span style='color:red;'>keyword</span>; the color is displayed by using coldDef(html=T).

When exporting the table with the current csv option, these color codes get not translated/are kept as text. Is there any avenue to get the color codes also exported so that e.g. the keyword would be also red when exporting the table to excel?

Many thanks.

werkstattcodes avatar Dec 08 '21 22:12 werkstattcodes

I don't know enough about Excel to tell if this is possible, sorry. Is there any way to import raw HTML into Excel, or get Excel to interpret CSV content as HTML? If so, then it might be possible.

glin avatar Jan 03 '22 03:01 glin