Create a CVS file with escape sequence to highlight the word in red

Question

Question

Alan Nguyen · Oct 2

Hi,

I try to create a tab delimiter file with bold header, when I convert the file into Microsoft Excel, it has a bold header. The file can be in text or CSV exension.

Thank you.

Alan

Product version: IRIS 2021.1

Discussion (4)2

Log in or sign up to continue

Jeffrey Drumm · Oct 3

You cannot import formatted text in Excel with a tab delimited text file as the source. The file must be created in either native Excel format or HTML.

There are many posts and articles on this Developer Community that discuss the generation of Excel-compatible files that will support text formatting; too many options to list them all here. Search for "Excel files" and you may find an answer that will work for you.

1 0

score 0 · Answer 1 · 2024-10-02T16:10:20-04:00

David Hockenbroch · Oct 2

Neither text nor CSV files support any kind of formatting, just plain text.

0 0

score 0 · Answer 2 · 2024-10-02T16:15:48-04:00

Alan Nguyen · Oct 2

Hi David,

I create a text file and import into the Excel with the tab delimiter.

0 0

score 0 · Answer 3 · 2024-10-03T09:59:54-04:00

Alan Nguyen · Oct 3

Jeff, thank you very much.

Alan

0 0