This project has moved. For the latest updates, please go here.

HTML formatted Cell - PasteSpecial

Apr 23, 2013 at 10:08 PM
Hello all,
I'm using the EPPlus Library with great success. However, I have the need where I need to put some dynamic HTML inside a cell.

I've tried setting richText = true; but this will not deal with HTML formatting.

I've seen several things about using "PasteSpecial" but this was for the COM object to play with Excel documents.
I don't even have a file on the hard drive, I am doing all my work inside a memory stream.

If anyone has any idea how to put HTML inside a cell and have Excel render that html, or have a way to "PasteSpecial" using EPPlus, I would be very greatful.
Thanks
-Shane
Jun 5, 2013 at 5:59 PM
Having similar issue. I am using FreeTextBox control from www.freetextbox.com. While retrieving my dataset to have EPPLUS render it into excel file as "it is", the HTML tagges are rendered into the excel file.

Please if there is anyone that has solution to make EPPLUS render into excel rather than the HTML will be greatly appreciated.

Thanks.

Isaac.