Export HTML String Value of the Cells to the DataTable
Contents
[
Hide
]
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
Sample Code
Console Output
<Font Style="FONT-FAMILY: Calibri;FONT-SIZE: 11pt;COLOR: #00b0f0;Background-Color: #ffe699;">Crow</Font>