Export HTML String Value of the Cells to the DataTable

Possible Usage Scenarios

Using Aspose.Cells APIs, developers can fill a DataTable with corresponding HTML strings (based on cells values) while exporting worksheet data. This document explains how to export HTML strings for the formatted cells data to fill a DataTable using Aspose.Cells APIs.

Export HTML String Value of the Cells to the DataTable

The following sample code illustrates how to export HTML string value of the cells to the DataTable while exporting data from worksheet into DataTable. Please see the sample Excel file, its screenshot and the console output for a reference.

Screenshot

todo:image_alt_text

Sample Code

Console Output

 <Font Style="FONT-FAMILY: Calibri;FONT-SIZE: 11pt;COLOR: #00b0f0;Background-Color: #ffe699;">Crow</Font>