Databases
StackOverflow2013
Postsdbo
POOOXML SDK illegal character replacements
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOOXML SDK illegal character replacements
    primarykey
    data
    text
    <p>I am having an issue with creating an XLSX document with the Open XML SDK 2.0 from MS.</p> <p>My issue is that I need to display some of these illegal characters in the excel sheet, but if I just add them to the sheet, the document will not load.</p> <p>I am using this function </p> <pre><code> private static string ProcessString(string str) { return System.Security.SecurityElement.Escape(str); } </code></pre> <p>Which will give me Tom&amp;apos;s ball instead of Tom's ball. (Well I haven't figured out how to get the latter as the excel generated won't open.)</p> <p>Anybody know how to make the illegal XML characters show using OOXML in an Excel sheet?</p> <p>EDIT:<br> In function I am using to create a text cell is:</p> <pre><code>private static Cell CreateTextCell(string header, UInt32 index, string text) { var c = new Cell { DataType = CellValues.String, CellReference = header + index }; var cellValue = new CellValue(text); c.Append(cellValue); return c; } </code></pre> <p>I know it has to do with illegal characters because when I didn't include a particular field in my text it worked, then when I included it, Excel would give me a parser error and a blank document.</p> <p>The text that I deal with also happens to have HTML tags in it as well.</p> <p>ps. lol, I just noticed that the markdown used parsed my HTML escape making my example look ridiculous.</p> <p>edit 2:</p> <p>Some example of input:</p> <ul> <li><p>Cancer&apos;s Complexity: Are we Looking at the Wrong Levels to Develop Effective Interventions?</p></li> <li><p>Prospective study of breast cancer risk in mutation-negative women from &lt;i&gt;BRCA1&lt;/i&gt; or &lt;i&gt;BRCA2&lt;/i&gt; mutation-positive families in the Kathleen Cuningham Foundation Consortium for Research into Familial Breast Cancer (kConFab).</p></li> <li><p>Germline &lt;em&gt;BRCA2&lt;/em&gt; mutations correlate with aggressive prostate cancer and adverse outcome.</p></li> </ul> <p>The html formatting is basically so it displays on the web page. I should just strip off the basic formatting tags. But more importantly, I want the excel file to load and escaping the values is a sure way of doing just that.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMin
    1. USMin
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOOXML SDK illegal character replacements
      1. USSamuel Neff
      1. VTFavorite
    2. VO
      singulars
      1. POOOXML SDK illegal character replacements
      1. This table or related slice is empty.
      1. VTUpMod
    1. COsorry, what is the exact `str` value you are passing in? you can use the `<pre>your str</pre>` tag to edit your post to show what it looks like.
      singulars
      1. POOOXML SDK illegal character replacements
      1. USTodd Main
    2. COPlease show more of the relevant code.
      singulars
      1. POOOXML SDK illegal character replacements
      1. USSamuel Neff
    3. COcan you use post a few examples of the html text you are passing in (what you are passing in, what you are expecting it to be and what is actually coming out the other end of your routine)? I'm having a really hard time understanding what the exact problem is you're dealing with.
      singulars
      1. POOOXML SDK illegal character replacements
      1. USTodd Main
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload