This project has moved and is read-only. For the latest updates, please go here.

EPPlus to accept richtext format

Sep 19, 2011 at 9:01 AM
Edited Sep 19, 2011 at 10:19 AM

Hello everyone!

 

what i'm trying to achieve is to print to excel an html source, but since html tags aren't supported by EPPlus, the nearest thing i could do is to parse the html into RTF format. Can anybody give me an idea as to how I can achieve this?

thanks!

 

is there something like:

Dim file As System.IO.FileInfo = New System.IO.FileInfo(location + "\myXL.xlsx")
Using xlPackage As OfficeOpenXml.ExcelPackage = New OfficeOpenXml.ExcelPackage(file)           

 Dim wSheet As OfficeOpenXml.ExcelWorksheet = xlPackage.Workbook.Worksheets("sheet1")

 wSheet.Cells(11, 11).RTFValue = "{\field{*\fldinst{HYPERLINK ""http://www.google.com""}}{\fldrslt{http://www.google.com}}"

xlPackage.Save()

end using

 

thanks!

Sep 20, 2011 at 8:08 PM

No support for that. If you must do it you have to translate the html tags to each style/hyperlink in EPPlus.