Laden Sie HTML mit StreamProvider in Excel
Contents
[
Hide
]
Beim Laden von HTML, das externe Ressourcen enthält, treten häufig die folgenden zwei Probleme auf:
- Wenn der HTML-Stream geladen wird, können die Bilder und externen Ressourcen, auf die von der HTML-Datei verwiesen wird, nicht über relative Pfade abgerufen werden.
- Externe Ressourcenpfade, auf die in HTML-Dateien verwiesen wird, müssen zugeordnet werden.
In diesem Artikel wird die Implementierung erläutertIStreamProvider Schnittstelle zum Einstellen derHtmlLoadOptions.StreamProvider Eigentum. Durch Implementieren dieser Schnittstelle können Sie externe Ressourcen während des Ladens von HTML-Streams laden oder diese externen Ressourcen sind relativ.
Dies ist der Hauptcode, der die Verwendung von zeigtHtmlLoadOptions.StreamProvider
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| class HtmlAttachedStreamProvider implements IStreamProvider | |
| { | |
| static boolean IsHRef(String picPath) | |
| { | |
| //This handles http://,https:// file:// and probably ftp://. | |
| if (picPath.startsWith("http://") | |
| || picPath.startsWith("https://") | |
| || picPath.startsWith("file://") | |
| || picPath.startsWith("ftp://")) | |
| { | |
| return true; | |
| } | |
| return false; | |
| } | |
| static InputStream GetInputStream(String fileName) | |
| { | |
| java.io.File f = new java.io.File(fileName); | |
| if(!f.exists() || !f.isFile()) | |
| { | |
| return null; | |
| } | |
| FileInputStream fis = null; | |
| try | |
| { | |
| return fis = new FileInputStream(f); | |
| }catch(Exception e) | |
| { | |
| return null; | |
| } | |
| } | |
| public void initStream(StreamProviderOptions options) | |
| { | |
| try | |
| { | |
| String absolutePath = null; | |
| String oldPath = options.getDefaultPath(); | |
| if(oldPath.equals("/Files/Image1.png")) | |
| { | |
| absolutePath = "G1.png"; | |
| } | |
| else if(oldPath.equals("/Files/image2.png")) | |
| absolutePath = "E1.png"; | |
| else if(oldPath.equals(https://www.aspose.com/templates/aspose/img/products/cells/aspose_cells-for-net.svg")) | |
| absolutePath = "F1.png"; | |
| if(absolutePath == null) | |
| { | |
| if(IsHRef(options.getDefaultPath())) | |
| { | |
| //get stream from path. | |
| } | |
| else | |
| { | |
| options.setInputStream(GetInputStream(options.getDefaultPath())); | |
| } | |
| return; | |
| } | |
| options.setInputStream(GetInputStream(absolutePath)); | |
| }catch(Exception e) | |
| { | |
| } | |
| } | |
| public void closeStream(StreamProviderOptions options) | |
| { | |
| try | |
| { | |
| if(options.getStream() != null) | |
| { | |
| options.getStream().close(); | |
| } | |
| }catch(Exception e) | |
| { | |
| } | |
| } | |
| } | |
| public static void main(String[] args)throws Exception{ | |
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| HtmlAttachedStreamProvider attachedStreamProvider = new HtmlAttachedStreamProvider(); | |
| HtmlLoadOptions options = new HtmlLoadOptions(); | |
| options.setStreamProvider(attachedStreamProvider); | |
| Workbook workbook = new Workbook( "html1.html", options); | |
| workbook.save("book1.xlsx"); | |
| } |