OpenOfficeXML and HTML written to spreadsheet's cells

Question

I have been trying to write html content into Excel spreadsheet's cells using ExcelPackage OpenOfficeXML and c#.

I am getting errors stating that input string has an invalid token. Has anyone came across anything similar?

Saving html directly in Excel works OK.

I do not want to use html encoding as the content has to be in readable form.

Please include relevant code and FULL error messages to assist in the diagnosis of your problem. — tnw, Aug 12 '13 at 20:53
I have edited your title. Please see, "[Should questions include “tags” in their titles?](http://meta.stackexchange.com/questions/19190/)", where the consensus is "no, they should not". — John Saunders, Aug 12 '13 at 22:53

FlavorScape · Answer 1 · 2013-08-13T15:06:45.057

Without knowing more of the specifics:

If you're using XML to create your spreadsheet, you should use CDATA tags for HTML content

  <someEntry> <![CDATA[ YOUR HTML HERE ]]> </someEntry>

In c# you can add CDATA. It is a type of element.

XmlCDataSection CData;
CData = doc.CreateCDataSection("<someNodeName><h1>blah</h1></someNodeName>");
XmlElement root = doc.DocumentElement;
root.AppendChild(CData);

Otherwise, you probably need to escape quotes and double quotes \" \'

Or you can use System.Security.SecurityElement.Escape() to encode both single and double quotes.

score 0 · Answer 2 · answered Aug 12 '13 at 23:13

0

Escaping single quotes solved the problem - Replace("'", @"""");

Thank you all.

answered Aug 12 '13 at 23:13

Luke G

1,741
6
23
34

that's pretty poor form to take another answer, and then post your version of that answer to your own question. – FlavorScape Aug 12 '13 at 23:50
It's all about solving problems and sharing your findings, right? – Luke G Aug 13 '13 at 06:44
What if your HTML contained a backslash for some reason? – FlavorScape Aug 13 '13 at 15:08

OpenOfficeXML and HTML written to spreadsheet's cells

2 Answers2