EasyXLS

Rich text format in cell

Concept

EasyXLS™ library allows you to import or export rich text format in the cells of an Excel file, by means of HTML syntax when setting the value for the cell.

The following tags are supported:
<b>
<strong>
<i>
<u>
<s>
<strike>
<sup>
<sub>
<font color= face= size=>
The above tags have the same meaning as in HTML.

In order to set the underline style for a group of characters EasyXLS uses four specific tags:
<underline single>
<underline double>
<underline single-accounting>
<underline double-accounting>

Concept in action

The below example shows how to export rich text format (RTF) in an Excel cell.

Source code sample

C#.NET
VB.NET
C++.NET
J#.NET
Java
PHP
ASP
C++
VB6
VBS
Coldfusion

The screen shot below represents the exported Excel file with rich text in cell generated by the code sample above.

Exported Excel file with rich text format in cell


Available for: Professional, Excel Writer, Excel Reader
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files
Java Excel Reader
Java version to read and import Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT