Databases
StackOverflow2013
Postsdbo
POError on taking strings from an excel file to .xml file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError on taking strings from an excel file to .xml file
    primarykey
    data
    text
    <p>I am taking some strings from a .xlsx file (the strings are simple characters). Then I am trying to put those strings in an .xml file. But unfortunately, when I put those strings in the ‘createElement(StringVariableHere)’ method, I get the following error: "org.w3c.dom.DOMException: INVALID_CHARACTER_ERR: An invalid or illegal XML character is specified."</p> <p>I get the string values in this way:</p> <pre><code>switch (tempCell.getCellType()) { case Cell.CELL_TYPE_STRING: String tempColValue = tempCell.getStringCellValue(); } </code></pre> <p>And this is the line where i try to add my string values and it gives me the error.</p> <pre><code>Element titleChild = doc.createElement(StringVariableHere); </code></pre> <p>I even tried to clean the string using the following method i found online:</p> <pre><code>public String stripNonValidXMLCharacters(String in) { StringBuffer out = new StringBuffer(); // Used to hold the output. char current; // Used to reference the current character. if (in == null || ("".equals(in))) return ""; // vacancy test. for (int i = 0; i &lt; in.length(); i++) { current = in.charAt(i); // NOTE: No IndexOutOfBoundsException caught here; it should not happen. if ((current == 0x9) || (current == 0xA) || (current == 0xD) || ((current &gt;= 0x20) &amp;&amp; (current &lt;= 0xD7FF)) || ((current &gt;= 0xE000) &amp;&amp; (current &lt;= 0xFFFD)) || ((current &gt;= 0x10000) &amp;&amp; (current &lt;= 0x10FFFF))) out.append(current); } return out.toString(); } </code></pre> <p>Also i am using the following to check if it is valid or not, and when i add my string it returns false:</p> <pre><code>XMLChar.isValidName(StringVariableHere) </code></pre> <p>Thank you all so much for your time. Stefanos.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USStefanos
    1. USStefanos
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError on taking strings from an excel file to .xml file
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POError on taking strings from an excel file to .xml file
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POError on taking strings from an excel file to .xml file
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo what's your question?
      singulars
      1. POError on taking strings from an excel file to .xml file
      1. USdjechlin
 

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