Load Html to Excel with StreamProvider

When loading HTML files which contain external resources, we often face the following two issues:

When the HTML stream is loaded, the images and external resources referenced by the HTML file cannot be obtained through relative paths.
External resource paths referenced in HTML files need to be mapped.

This article explains how to implement the IStreamProvider interface for setting the HtmlLoadOptions.StreamProvider property. By implementing this interface, you will be able to load external resources during loading HTML streams, even when these external resources are referenced relatively.

This is the main code showing the usage of the HtmlLoadOptions.StreamProvider property

Provide exported worksheet HTML file path via IFilePathProvider interface Render Gradient Fill for the WordArt while Converting Spreadsheets to HTML