Back to Devexpress

Workbook.ExportToHtml(Stream, HtmlDocumentExporterOptions) Method

officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-exporttohtml-x28-system-dot-io-dot-stream-devexpress-dot-xtraspreadsheet-dot-export-dot-htmldocumentexporteroptions-x29.md

latest4.9 KB
Original Source

Workbook.ExportToHtml(Stream, HtmlDocumentExporterOptions) Method

Exports the document’s data to the specified stream in HTML format using the specified options.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Docs.v25.2.dll

NuGet Package : DevExpress.Document.Processor

Declaration

csharp
public void ExportToHtml(
    Stream stream,
    HtmlDocumentExporterOptions options
)
vb
Public Sub ExportToHtml(
    stream As Stream,
    options As HtmlDocumentExporterOptions
)

Parameters

NameTypeDescription
streamStream

A Stream object to which the created HTML file should be sent.

| | options | HtmlDocumentExporterOptions |

A HtmlDocumentExporterOptions instance containing required export options.

|

Remarks

The default calculation mode for a Workbook is Manual. This mode implies that the Spreadsheet does not recalculate formulas before it generates an HTML file. Call the Workbook.Calculate or Workbook.CalculateFull method to calculate all formulas in the workbook before you export it to HTML.

The following code snippets (auto-collected from DevExpress Examples) contain references to the ExportToHtml(Stream, HtmlDocumentExporterOptions) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

office-file-api-dockerize-application/CS/DocumentConversionWebApi/Controllers/ConvertFileController.cs#L63

csharp
options.AnchorImagesToPage = true;
workbook.ExportToHtml(resultStream, options);
resultStream.Seek(0, SeekOrigin.Begin);

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/ExportActions.cs#L26

csharp
{
    workbook.ExportToHtml(htmlStream, options);
}

office-file-api-in-web-api-app/CS/BusinessObjects/Helpers.cs#L187

csharp
options.AnchorImagesToPage = true;
    workbook.ExportToHtml(resultStream, options);
}

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/ExportActions.vb#L22

vb
Using htmlStream As New FileStream("OutputWorksheet.html", FileMode.Create)
    workbook.ExportToHtml(htmlStream, options)
End Using

Implements

ExportToHtml(Stream, HtmlDocumentExporterOptions)

See Also

Workbook Class

Workbook Members

DevExpress.Spreadsheet Namespace