Carga HTML a Excel con StreamProvider
Contents
[
Hide
]
Al cargar html que contiene recursos externos, a menudo nos enfrentamos a los siguientes dos problemas:
- Cuando se carga la secuencia html, las imágenes y los recursos externos a los que hace referencia el archivo html no se pueden obtener a través de rutas relativas.
- Las rutas de recursos externos a las que se hace referencia en los archivos html deben mapearse.
Este artículo explica cómo implementarIStreamProvider interfaz para configurar elHtmlLoadOptions.StreamProvider propiedad. Al implementar esta interfaz, podrá cargar recursos externos durante la carga de secuencias Html o estos recursos externos son relativos.
Este es el código principal que muestra el uso deHtmlLoadOptions.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"); | |
| } |