Export Cell Content from Spreadsheet Documents
- 3 minutes to read
You can use the Spreadsheet API to export cell content to HTML and RTF.
#Export to HTML
Use the following API to export cell content to HTML and specify export options:
- GetHtmlContent()
- Gets cell content as a string in HTML format.
- GetHtmlContent(HtmlCellContentExportOptions)
- Gets cell content as a string in HTML format. Allows you to specify export options.
- HtmlCellContentExportOptions
- Contains options for cell content export to HTML.
- FontUnit
- Gets or sets the measurement units used for the font size when exporting cell content to HTML.
- IgnoreDisplayFormat
- Gets or sets whether to ignore the display format when exporting cell content to HTML.
The following snippet loads a document from a file and exports content from cell B3. The IgnoreDisplayFormat property is set to true
and the FontUnit property is set to Pixel. The cell contains conditional formatting.
using DevExpress.Spreadsheet;
using DevExpress.XtraSpreadsheet.Export;
//...
spreadsheetControl1.LoadDocument("Documents\Document.xlsx", DocumentFormat.Xlsx);
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet[4, 1]; //B3
HtmlCellContentExportOptions htmlExportOptions = new HtmlCellContentExportOptions();
htmlExportOptions.IgnoreDisplayFormat = true;
htmlExportOptions.FontUnit = DevExpress.XtraSpreadsheet.Export.Html.HtmlFontUnit.Pixel;
string htmlContentString = cell.GetHtmlContent(htmlExportOptions);
//...
The resulting HTML string looks as follows:
<font style="font-family:Calibri;font-size:15px;font-weight:normal;font-style:normal;color:#FFFFFF;">cell with conditional formatting</font>
#Export to RTF
Use the following API to export cell content to RTF and specify export options:
- GetRtfContent()
- Gets cell content as a string in RTF format.
- GetRtfContent(RtfCellContentExportOptions)
- Gets cell content as a string in RTF format. Allows you to specify export options.
- RtfCellContentExportOptions
- Contains options for cell content export to RTF.
- IgnoreDisplayFormat
- Gets or sets whether to ignore the display format when exporting cell content to RTF.
The following snippet loads a document from a file and exports content from cell B3. The IgnoreDisplayFormat property is set to true
:
using DevExpress.Spreadsheet;
using DevExpress.XtraSpreadsheet.Export;
//...
spreadsheetControl1.LoadDocument("Documents\Document.xlsx", DocumentFormat.Xlsx);
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];
Cell cell = worksheet[4, 1]; //B3
RtfCellContentExportOptions rtfExportOptions = new RtfCellContentExportOptions();
rtfExportOptions.IgnoreDisplayFormat = true;
string rtfContentString = cell.GetRtfContent(rtfExportOptions);
//...
The resulting HTML string looks as follows:
{\rtf1\deff0{\fonttbl{\f0 Calibri;}}{\colortbl;}{\fs22 cell with conditional formatting}}