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

XML Encode/Decode?

Feb 17, 2015 at 4:54 PM
We have Excel spread sheets that are populated from SSIS and we wanted to apply some more formatting after population, so we are trying EPPlus. Unfortunately, if the cell contains a an XML character like ">" or "<" it gets encoded to "&gt;" and "&lt;". More specifically, I guess I should say, after EPPlus manipulated the document and it is opened with Excel, Excel shows &gt; rather than the > character.

Is there a way to prevent this sort of encoding or to apply a decode before saving or some other setting that needs to be set to avoid this?

Thanks!