blocks|key|171570|text|我在这里做了一个小小的研究。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171571|这是ASCII表。一共有128个符号|171572|📷|atomic|offset|length|171573|下面是一些小的测试代码，它添加ASCII表中的每个符号，并尝试将其作为XML文档加载。|171574|static+public+void+RegexTry()
{
++++StreamReader+stream+=+new+StreamReader(@"test.xml");
++++string+xmlfile+=+stream.ReadToEnd();
++++stream.Close();

++++string+text+=+"";

++++for+(int+i+=+0;+i+<+128;+i%2B%2B+)
++++{
++++++++char+t+=+(char)+i;

++++++++text+=+xmlfile.Replace('П',+t);

++++++++XmlDocument+xml+=+new+XmlDocument();
++++++++try
++++++++{
++++++++++++xml.LoadXml(text);
++++++++}
++++++++catch+(Exception+ex)
++++++++{
++++++++++++Console.WriteLine("Char("%2Bi.ToString()+%2B"):+"+%2B+t+%2B+"+=>+error!+"+%2B+ex.Message);
++++++++++++continue;
++++++++}

++++++++Console.WriteLine("Char("+%2B+i.ToString()+%2B+"):+"+%2B+t+%2B+"+=>+fine!");
++++}

++++Console.ReadKey();
}|code-block|syntax|javascript|171575|因此，它返回：|171576|Char(0):+=>+error!+'.',+hexadecimal+value+0x00,+is+an+invalid+character.+Line+5,+position+7.
Char(1):+=>+error!+'',+hexadecimal+value+0x01,+is+an+invalid+character.+Line+5,+position+7.
Char(2):+=>+error!+'',+hexadecimal+value+0x02,+is+an+invalid+character.+Line+5,+position+7.
Char(3):+=>+error!+'',+hexadecimal+value+0x03,+is+an+invalid+character.+Line+5,+position+7.
Char(4):+=>+error!+'',+hexadecimal+value+0x04,+is+an+invalid+character.+Line+5,+position+7.
Char(5):+=>+error!+'',+hexadecimal+value+0x05,+is+an+invalid+character.+Line+5,+position+7.
Char(6):+=>+error!+'',+hexadecimal+value+0x06,+is+an+invalid+character.+Line+5,+position+7.
Char(7):+=>+error!+'',+hexadecimal+value+0x07,+is+an+invalid+character.+Line+5,+position+7.
Char(8):+=>+error!+'',+hexadecimal+value+0x08,+is+an+invalid+character.+Line+5,+position+7.
Char(9):+++++=>+fine!
Char(10):+
+=>+fine!
Char(11):+=>+error!+'',+hexadecimal+value+0x0B,+is+an+invalid+character.+Line+5,+position+7.
Char(12):+=>+error!+'',+hexadecimal+value+0x0C,+is+an+invalid+character.+Line+5,+position+7.
Char(13):+
+=>+fine!
Char(14):+=>+error!+'',+hexadecimal+value+0x0E,+is+an+invalid+character.+Line+5,+position+7.
Char(15):+=>+error!+'',+hexadecimal+value+0x0F,+is+an+invalid+character.+Line+5,+position+7.
Char(16):+=>+error!+'',+hexadecimal+value+0x10,+is+an+invalid+character.+Line+5,+position+7.
Char(17):+=>+error!+'',+hexadecimal+value+0x11,+is+an+invalid+character.+Line+5,+position+7.
Char(18):+=>+error!+'',+hexadecimal+value+0x12,+is+an+invalid+character.+Line+5,+position+7.
Char(19):+=>+error!+'',+hexadecimal+value+0x13,+is+an+invalid+character.+Line+5,+position+7.
Char(20):+=>+error!+'',+hexadecimal+value+0x14,+is+an+invalid+character.+Line+5,+position+7.
Char(21):+=>+error!+'',+hexadecimal+value+0x15,+is+an+invalid+character.+Line+5,+position+7.
Char(22):+=>+error!+'',+hexadecimal+value+0x16,+is+an+invalid+character.+Line+5,+position+7.
Char(23):+=>+error!+'',+hexadecimal+value+0x17,+is+an+invalid+character.+Line+5,+position+7.
Char(24):+=>+error!+'',+hexadecimal+value+0x18,+is+an+invalid+character.+Line+5,+position+7.
Char(25):+=>+error!+'',+hexadecimal+value+0x19,+is+an+invalid+character.+Line+5,+position+7.
Char(26):+=>+error!+'',+hexadecimal+value+0x1A,+is+an+invalid+character.+Line+5,+position+7.
Char(27):+=>+error!+'',+hexadecimal+value+0x1B,+is+an+invalid+character.+Line+5,+position+7.
Char(28):+=>+error!+'',+hexadecimal+value+0x1C,+is+an+invalid+character.+Line+5,+position+7.
Char(29):+=>+error!+'',+hexadecimal+value+0x1D,+is+an+invalid+character.+Line+5,+position+7.
Char(30):+=>+error!+'',+hexadecimal+value+0x1E,+is+an+invalid+character.+Line+5,+position+7.
Char(31):+=>+error!+'',+hexadecimal+value+0x1F,+is+an+invalid+character.+Line+5,+position+7.
Char(32):+++=>+fine!
Char(33):+!+=>+fine!
Char(34):+"+=>+fine!
Char(35):+#+=>+fine!
Char(36):+$+=>+fine!
Char(37):+%25+=>+fine!
Char(38):+=>+error!+An+error+occurred+while+parsing+EntityName.+Line+5,+position+8.
Char(39):+'+=>+fine!
Char(40):+(+=>+fine!
Char(41):+)+=>+fine!
Char(42):+*+=>+fine!
Char(43):+%2B+=>+fine!
Char(44):+,+=>+fine!
Char(45):+-+=>+fine!
Char(46):+.+=>+fine!
Char(47):+/+=>+fine!
Char(48):+0+=>+fine!
Char(49):+1+=>+fine!
Char(50):+2+=>+fine!
Char(51):+3+=>+fine!
Char(52):+4+=>+fine!
Char(53):+5+=>+fine!
Char(54):+6+=>+fine!
Char(55):+7+=>+fine!
Char(56):+8+=>+fine!
Char(57):+9+=>+fine!
Char(58):+:+=>+fine!
Char(59):+;+=>+fine!
Char(60):+=>+error!+The+'<'+character,+hexadecimal+value+0x3C,+cannot+be+included+in+a+name.+Line+5,+position+13.
Char(61):+=+=>+fine!
Char(62):+>+=>+fine!
Char(63):+?+=>+fine!
Char(64):+@+=>+fine!
Char(65):+A+=>+fine!
Char(66):+B+=>+fine!
Char(67):+C+=>+fine!
Char(68):+D+=>+fine!
Char(69):+E+=>+fine!
Char(70):+F+=>+fine!
Char(71):+G+=>+fine!
Char(72):+H+=>+fine!
Char(73):+I+=>+fine!
Char(74):+J+=>+fine!
Char(75):+K+=>+fine!
Char(76):+L+=>+fine!
Char(77):+M+=>+fine!
Char(78):+N+=>+fine!
Char(79):+O+=>+fine!
Char(80):+P+=>+fine!
Char(81):+Q+=>+fine!
Char(82):+R+=>+fine!
Char(83):+S+=>+fine!
Char(84):+T+=>+fine!
Char(85):+U+=>+fine!
Char(86):+V+=>+fine!
Char(87):+W+=>+fine!
Char(88):+X+=>+fine!
Char(89):+Y+=>+fine!
Char(90):+Z+=>+fine!
Char(91):+[+=>+fine!
Char(92):+\+=>+fine!
Char(93):+]+=>+fine!
Char(94):+%5E+=>+fine!
Char(95):+_+=>+fine!
Char(96):+`+=>+fine!
Char(97):+a+=>+fine!
Char(98):+b+=>+fine!
Char(99):+c+=>+fine!
Char(100):+d+=>+fine!
Char(101):+e+=>+fine!
Char(102):+f+=>+fine!
Char(103):+g+=>+fine!
Char(104):+h+=>+fine!
Char(105):+i+=>+fine!
Char(106):+j+=>+fine!
Char(107):+k+=>+fine!
Char(108):+l+=>+fine!
Char(109):+m+=>+fine!
Char(110):+n+=>+fine!
Char(111):+o+=>+fine!
Char(112):+p+=>+fine!
Char(113):+q+=>+fine!
Char(114):+r+=>+fine!
Char(115):+s+=>+fine!
Char(116):+t+=>+fine!
Char(117):+u+=>+fine!
Char(118):+v+=>+fine!
Char(119):+w+=>+fine!
Char(120):+x+=>+fine!
Char(121):+y+=>+fine!
Char(122):+z+=>+fine!
Char(123):+{+=>+fine!
Char(124):+%7C+=>+fine!
Char(125):+}+=>+fine!
Char(126):+~+=>+fine!
Char(127):++=>+fine!++|171577|您可以看到，有很多符号不能在XML代码中使用。要替换它们，我们可以使用Reqex.Replace|171578|static+string+ReplaceHexadecimalSymbols(string+txt)
{
++++string+r+=+"[\x00-\x08\x0B\x0C\x0E-\x1F\x26]";
++++return+Regex.Replace(txt,+r,"",RegexOptions.Compiled);
}|171579|PS。如果大家都知道的话我很抱歉。|171580|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/7bad9302b1b2b476b24eb5b6a4ecf4a2.gif|imageAlt^0|0|0|0|1|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1A|8|@]|9|@$G|1B|H|1C|1|1D]]|A|$]]|$1|I|3|J|5|6|7|1E|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1F|8|@]|9|@]|A|$N|O]]|$1|P|3|Q|5|6|7|1G|8|@]|9|@]|A|$]]|$1|R|3|S|5|M|7|1H|8|@]|9|@]|A|$N|O]]|$1|T|3|U|5|6|7|1I|8|@]|9|@]|A|$]]|$1|V|3|W|5|M|7|1J|8|@]|9|@]|A|$N|O]]|$1|X|3|Y|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16|17|-4]]]]

I made a small research here.

Here is the ASCII table. There are 128 symbols
<img src="https://i.stack.imgur.com/7guQC.gif" alt="asciitable">
Here is some small test code which adds every symbol from ASCII table and tries to load it as an XML document.

<pre><code>static public void RegexTry()
{
 StreamReader stream = new StreamReader(@"test.xml");
 string xmlfile = stream.ReadToEnd();
 stream.Close();

 string text = "";

 for (int i = 0; i &lt; 128; i++ )
 {
 char t = (char) i;

 text = xmlfile.Replace('П', t);

 XmlDocument xml = new XmlDocument();
 try
 {
 xml.LoadXml(text);
 }
 catch (Exception ex)
 {
 Console.WriteLine("Char("+i.ToString() +"): " + t + " =&gt; error! " + ex.Message);
 continue;
 }

 Console.WriteLine("Char(" + i.ToString() + "): " + t + " =&gt; fine!");
 }

 Console.ReadKey();
}
</code></pre>

As a result it returns:

<pre><code>Char(0): =&gt; error! '.', hexadecimal value 0x00, is an invalid character. Line 5, position 7.
Char(1): =&gt; error! '', hexadecimal value 0x01, is an invalid character. Line 5, position 7.
Char(2): =&gt; error! '', hexadecimal value 0x02, is an invalid character. Line 5, position 7.
Char(3): =&gt; error! '', hexadecimal value 0x03, is an invalid character. Line 5, position 7.
Char(4): =&gt; error! '', hexadecimal value 0x04, is an invalid character. Line 5, position 7.
Char(5): =&gt; error! '', hexadecimal value 0x05, is an invalid character. Line 5, position 7.
Char(6): =&gt; error! '', hexadecimal value 0x06, is an invalid character. Line 5, position 7.
Char(7): =&gt; error! '', hexadecimal value 0x07, is an invalid character. Line 5, position 7.
Char(8): =&gt; error! '', hexadecimal value 0x08, is an invalid character. Line 5, position 7.
Char(9): =&gt; fine!
Char(10): 
 =&gt; fine!
Char(11): =&gt; error! '', hexadecimal value 0x0B, is an invalid character. Line 5, position 7.
Char(12): =&gt; error! '', hexadecimal value 0x0C, is an invalid character. Line 5, position 7.
Char(13): 
 =&gt; fine!
Char(14): =&gt; error! '', hexadecimal value 0x0E, is an invalid character. Line 5, position 7.
Char(15): =&gt; error! '', hexadecimal value 0x0F, is an invalid character. Line 5, position 7.
Char(16): =&gt; error! '', hexadecimal value 0x10, is an invalid character. Line 5, position 7.
Char(17): =&gt; error! '', hexadecimal value 0x11, is an invalid character. Line 5, position 7.
Char(18): =&gt; error! '', hexadecimal value 0x12, is an invalid character. Line 5, position 7.
Char(19): =&gt; error! '', hexadecimal value 0x13, is an invalid character. Line 5, position 7.
Char(20): =&gt; error! '', hexadecimal value 0x14, is an invalid character. Line 5, position 7.
Char(21): =&gt; error! '', hexadecimal value 0x15, is an invalid character. Line 5, position 7.
Char(22): =&gt; error! '', hexadecimal value 0x16, is an invalid character. Line 5, position 7.
Char(23): =&gt; error! '', hexadecimal value 0x17, is an invalid character. Line 5, position 7.
Char(24): =&gt; error! '', hexadecimal value 0x18, is an invalid character. Line 5, position 7.
Char(25): =&gt; error! '', hexadecimal value 0x19, is an invalid character. Line 5, position 7.
Char(26): =&gt; error! '', hexadecimal value 0x1A, is an invalid character. Line 5, position 7.
Char(27): =&gt; error! '', hexadecimal value 0x1B, is an invalid character. Line 5, position 7.
Char(28): =&gt; error! '', hexadecimal value 0x1C, is an invalid character. Line 5, position 7.
Char(29): =&gt; error! '', hexadecimal value 0x1D, is an invalid character. Line 5, position 7.
Char(30): =&gt; error! '', hexadecimal value 0x1E, is an invalid character. Line 5, position 7.
Char(31): =&gt; error! '', hexadecimal value 0x1F, is an invalid character. Line 5, position 7.
Char(32): =&gt; fine!
Char(33): ! =&gt; fine!
Char(34): " =&gt; fine!
Char(35): # =&gt; fine!
Char(36): $ =&gt; fine!
Char(37): % =&gt; fine!
Char(38): =&gt; error! An error occurred while parsing EntityName. Line 5, position 8.
Char(39): ' =&gt; fine!
Char(40): ( =&gt; fine!
Char(41): ) =&gt; fine!
Char(42): * =&gt; fine!
Char(43): + =&gt; fine!
Char(44): , =&gt; fine!
Char(45): - =&gt; fine!
Char(46): . =&gt; fine!
Char(47): / =&gt; fine!
Char(48): 0 =&gt; fine!
Char(49): 1 =&gt; fine!
Char(50): 2 =&gt; fine!
Char(51): 3 =&gt; fine!
Char(52): 4 =&gt; fine!
Char(53): 5 =&gt; fine!
Char(54): 6 =&gt; fine!
Char(55): 7 =&gt; fine!
Char(56): 8 =&gt; fine!
Char(57): 9 =&gt; fine!
Char(58): : =&gt; fine!
Char(59): ; =&gt; fine!
Char(60): =&gt; error! The '&lt;' character, hexadecimal value 0x3C, cannot be included in a name. Line 5, position 13.
Char(61): = =&gt; fine!
Char(62): &gt; =&gt; fine!
Char(63): ? =&gt; fine!
Char(64): @ =&gt; fine!
Char(65): A =&gt; fine!
Char(66): B =&gt; fine!
Char(67): C =&gt; fine!
Char(68): D =&gt; fine!
Char(69): E =&gt; fine!
Char(70): F =&gt; fine!
Char(71): G =&gt; fine!
Char(72): H =&gt; fine!
Char(73): I =&gt; fine!
Char(74): J =&gt; fine!
Char(75): K =&gt; fine!
Char(76): L =&gt; fine!
Char(77): M =&gt; fine!
Char(78): N =&gt; fine!
Char(79): O =&gt; fine!
Char(80): P =&gt; fine!
Char(81): Q =&gt; fine!
Char(82): R =&gt; fine!
Char(83): S =&gt; fine!
Char(84): T =&gt; fine!
Char(85): U =&gt; fine!
Char(86): V =&gt; fine!
Char(87): W =&gt; fine!
Char(88): X =&gt; fine!
Char(89): Y =&gt; fine!
Char(90): Z =&gt; fine!
Char(91): [ =&gt; fine!
Char(92): \ =&gt; fine!
Char(93): ] =&gt; fine!
Char(94): ^ =&gt; fine!
Char(95): _ =&gt; fine!
Char(96): ` =&gt; fine!
Char(97): a =&gt; fine!
Char(98): b =&gt; fine!
Char(99): c =&gt; fine!
Char(100): d =&gt; fine!
Char(101): e =&gt; fine!
Char(102): f =&gt; fine!
Char(103): g =&gt; fine!
Char(104): h =&gt; fine!
Char(105): i =&gt; fine!
Char(106): j =&gt; fine!
Char(107): k =&gt; fine!
Char(108): l =&gt; fine!
Char(109): m =&gt; fine!
Char(110): n =&gt; fine!
Char(111): o =&gt; fine!
Char(112): p =&gt; fine!
Char(113): q =&gt; fine!
Char(114): r =&gt; fine!
Char(115): s =&gt; fine!
Char(116): t =&gt; fine!
Char(117): u =&gt; fine!
Char(118): v =&gt; fine!
Char(119): w =&gt; fine!
Char(120): x =&gt; fine!
Char(121): y =&gt; fine!
Char(122): z =&gt; fine!
Char(123): { =&gt; fine!
Char(124): | =&gt; fine!
Char(125): } =&gt; fine!
Char(126): ~ =&gt; fine!
Char(127): =&gt; fine! 
</code></pre>

You can see there are a lot of symbols which can't be in XML code. To replace them we can use Reqex.Replace 

<pre><code>static string ReplaceHexadecimalSymbols(string txt)
{
 string r = "[\x00-\x08\x0B\x0C\x0E-\x1F\x26]";
 return Regex.Replace(txt, r,"",RegexOptions.Compiled);
}
</code></pre>

PS. Sorry if everybody knew that.

blocks|key|171637|text|XML+specification定义有效字符的方式如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|171638|Char+::=+#x9+%7C+#xA+%7C+#xD+%7C+[#x20-#xD7FF]+%7C+[#xE000-#xFFFD]+%7C+[#x10000-#x10FFFF]|code-block|syntax|javascript|171639|如您所见，#x12不是文档中的有效字符。|style|CODE|171640|你问如何删除它们，但我认为这不是你应该问的问题。他们根本就不应该出现。你应该拒绝任何这种格式错误的文档。简单地删除无效字符会抑制真正的问题。|171641|如果您正在创建有问题的文档，则需要修复生成它的代码，以便它生成有效的XML。|171642|entityMap|0|LINK|mutability|MUTABLE|url|http://www.w3.org/TR/xml/#charsets^0|0|H|0|0|0|5|4|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|13|8|@$A|14|B|15|K|L]]|9|@]|C|$]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|17|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

The <a href="http://www.w3.org/TR/xml/#charsets">XML specification</a> defines the valid characters like this:

<pre><code>Char ::= #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF]
</code></pre>

As you can see <code>#x12</code> is not a valid character in an XML document.

You ask how to remove them but I think that is not the question you should be asking. They should simply not be present. You should reject any such document as mal-formed. Simply removing invalid characters suppresses the real problem.

If you are creating the documents in question then you need to fix the code that generates it so that it generates valid XML.

blocks|key|4677531|text|这本质上是this+question的一个特例。我建议你使用那里的一个答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4677532|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/20762/how-do-you-remove-invalid-hexadecimal-characters-from-an-xml-based-data-source-p^0|5|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

This is essentially a special case of <a href="https://stackoverflow.com/questions/20762/how-do-you-remove-invalid-hexadecimal-characters-from-an-xml-based-data-source-p">this question</a>. I suggest you use one of the answers from there.

blocks|key|171779|text|只需使用jhon提供的上述修复程序更新这些函数，并在需要更新的地方检查代码中的这些函数。我已经测试过了，它会为你工作的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171780|++private+static+void+WriteDataTableToExcelWorksheet(DataTable+dt,+WorksheetPart+worksheetPart)
++++{
++++++++var+worksheet+=+worksheetPart.Worksheet;
++++++++var+sheetData+=+worksheet.GetFirstChild<SheetData>();

++++++++string+cellValue+=+"";

++++++++//++Create+a+Header+Row+in+our+Excel+file,+containing+one+header+for+each+Column+of+data+in+our+DataTable.
++++++++//
++++++++//++We'll+also+create+an+array,+showing+which+type+each+column+of+data+is+(Text+or+Numeric),+so+when+we+come+to+write+the+actual
++++++++//++cells+of+data,+we'll+know+if+to+write+Text+values+or+Numeric+cell+values.
++++++++int+numberOfColumns+=+dt.Columns.Count;
++++++++bool[]+IsNumericColumn+=+new+bool[numberOfColumns];

++++++++string[]+excelColumnNames+=+new+string[numberOfColumns];
++++++++for+(int+n+=+0;+n+<+numberOfColumns;+n%2B%2B)
++++++++++++excelColumnNames[n]+=+GetExcelColumnName(n);

++++++++//
++++++++//++Create+the+Header+row+in+our+Excel+Worksheet
++++++++//
++++++++uint+rowIndex+=+1;

++++++++var+headerRow+=+new+Row+{+RowIndex+=+rowIndex+};++//+add+a+row+at+the+top+of+spreadsheet
++++++++sheetData.Append(headerRow);

++++++++for+(int+colInx+=+0;+colInx+<+numberOfColumns;+colInx%2B%2B)
++++++++{
++++++++++++DataColumn+col+=+dt.Columns[colInx];
++++++++++++AppendTextCell(excelColumnNames[colInx]+%2B+"1",+col.ColumnName,+headerRow);
++++++++++++IsNumericColumn[colInx]+=+(col.DataType.FullName+==+"System.Decimal")+%7C%7C+(col.DataType.FullName+==+"System.Int32");
++++++++}

++++++++//
++++++++//++Now,+step+through+each+row+of+data+in+our+DataTable...
++++++++//
++++++++double+cellNumericValue+=+0;
++++++++foreach+(DataRow+dr+in+dt.Rows)
++++++++{
++++++++++++//+...create+a+new+row,+and+append+a+set+of+this+row's+data+to+it.
++++++++++++%2B%2BrowIndex;
++++++++++++var+newExcelRow+=+new+Row+{+RowIndex+=+rowIndex+};++//+add+a+row+at+the+top+of+spreadsheet
++++++++++++sheetData.Append(newExcelRow);

++++++++++++for+(int+colInx+=+0;+colInx+<+numberOfColumns;+colInx%2B%2B)
++++++++++++{
++++++++++++++++cellValue+=+dr.ItemArray[colInx].ToString();

++++++++++++++++//+Create+cell+with+data
++++++++++++++++if+(IsNumericColumn[colInx])
++++++++++++++++{
++++++++++++++++++++//++For+numeric+cells,+make+sure+our+input+data+IS+a+number,+then+write+it+out+to+the+Excel+file.
++++++++++++++++++++//++If+this+numeric+value+is+NULL,+then+don't+write+anything+to+the+Excel+file.
++++++++++++++++++++cellNumericValue+=+0;
++++++++++++++++++++if+(double.TryParse(cellValue,+out+cellNumericValue))
++++++++++++++++++++{
++++++++++++++++++++++++cellValue+=+ReplaceHexadecimalSymbols(cellNumericValue.ToString());
++++++++++++++++++++++++AppendNumericCell(excelColumnNames[colInx]+%2B+rowIndex.ToString(),+cellValue,+newExcelRow);
++++++++++++++++++++}
++++++++++++++++}
++++++++++++++++else
++++++++++++++++{
++++++++++++++++++++//++For+text+cells,+just+write+the+input+data+straight+out+to+the+Excel+file.
++++++++++++++++++++AppendTextCell(excelColumnNames[colInx]+%2B+rowIndex.ToString(),+cellValue,+newExcelRow);
++++++++++++++++}
++++++++++++}
++++++++}
++++}
++++static+string+ReplaceHexadecimalSymbols(string+txt)
++++{
++++++++string+r+=+"[\x00-\x08\x0B\x0C\x0E-\x1F\x26]";
++++++++return+Regex.Replace(txt,+r,+"",+RegexOptions.Compiled);
++++}

++++private+static+void+AppendTextCell(string+cellReference,+string+cellStringValue,+Row+excelRow)
++++{
++++++++//++Add+a+new+Excel+Cell+to+our+Row+
++++++++Cell+cell+=+new+Cell()+{+CellReference+=+cellReference,+DataType+=+CellValues.String+};
++++++++CellValue+cellValue+=+new+CellValue();
++++++++cellValue.Text+=+ReplaceHexadecimalSymbols(cellStringValue);
++++++++cell.Append(cellValue);
++++++++excelRow.Append(cell);
++++}

++++private+static+void+AppendNumericCell(string+cellReference,+string+cellStringValue,+Row+excelRow)
++++{
++++++++//++Add+a+new+Excel+Cell+to+our+Row+
++++++++Cell+cell+=+new+Cell()+{+CellReference+=+cellReference+};
++++++++CellValue+cellValue+=+new+CellValue();
++++++++cellValue.Text+=+ReplaceHexadecimalSymbols(cellStringValue);
++++++++cell.Append(cellValue);
++++++++excelRow.Append(cell);
++++}|code-block|syntax|javascript|171781|谢谢让我知道，如果你需要进一步的帮助。|171782|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Just update these functions with the mentioned fix provided by jhon and where you have to update check these functions in your code. it will work for you i have tested.

<pre><code> private static void WriteDataTableToExcelWorksheet(DataTable dt, WorksheetPart worksheetPart)
 {
 var worksheet = worksheetPart.Worksheet;
 var sheetData = worksheet.GetFirstChild&lt;SheetData&gt;();

 string cellValue = "";

 // Create a Header Row in our Excel file, containing one header for each Column of data in our DataTable.
 //
 // We'll also create an array, showing which type each column of data is (Text or Numeric), so when we come to write the actual
 // cells of data, we'll know if to write Text values or Numeric cell values.
 int numberOfColumns = dt.Columns.Count;
 bool[] IsNumericColumn = new bool[numberOfColumns];

 string[] excelColumnNames = new string[numberOfColumns];
 for (int n = 0; n &lt; numberOfColumns; n++)
 excelColumnNames[n] = GetExcelColumnName(n);

 //
 // Create the Header row in our Excel Worksheet
 //
 uint rowIndex = 1;

 var headerRow = new Row { RowIndex = rowIndex }; // add a row at the top of spreadsheet
 sheetData.Append(headerRow);

 for (int colInx = 0; colInx &lt; numberOfColumns; colInx++)
 {
 DataColumn col = dt.Columns[colInx];
 AppendTextCell(excelColumnNames[colInx] + "1", col.ColumnName, headerRow);
 IsNumericColumn[colInx] = (col.DataType.FullName == "System.Decimal") || (col.DataType.FullName == "System.Int32");
 }

 //
 // Now, step through each row of data in our DataTable...
 //
 double cellNumericValue = 0;
 foreach (DataRow dr in dt.Rows)
 {
 // ...create a new row, and append a set of this row's data to it.
 ++rowIndex;
 var newExcelRow = new Row { RowIndex = rowIndex }; // add a row at the top of spreadsheet
 sheetData.Append(newExcelRow);

 for (int colInx = 0; colInx &lt; numberOfColumns; colInx++)
 {
 cellValue = dr.ItemArray[colInx].ToString();

 // Create cell with data
 if (IsNumericColumn[colInx])
 {
 // For numeric cells, make sure our input data IS a number, then write it out to the Excel file.
 // If this numeric value is NULL, then don't write anything to the Excel file.
 cellNumericValue = 0;
 if (double.TryParse(cellValue, out cellNumericValue))
 {
 cellValue = ReplaceHexadecimalSymbols(cellNumericValue.ToString());
 AppendNumericCell(excelColumnNames[colInx] + rowIndex.ToString(), cellValue, newExcelRow);
 }
 }
 else
 {
 // For text cells, just write the input data straight out to the Excel file.
 AppendTextCell(excelColumnNames[colInx] + rowIndex.ToString(), cellValue, newExcelRow);
 }
 }
 }
 }
 static string ReplaceHexadecimalSymbols(string txt)
 {
 string r = "[\x00-\x08\x0B\x0C\x0E-\x1F\x26]";
 return Regex.Replace(txt, r, "", RegexOptions.Compiled);
 }

 private static void AppendTextCell(string cellReference, string cellStringValue, Row excelRow)
 {
 // Add a new Excel Cell to our Row 
 Cell cell = new Cell() { CellReference = cellReference, DataType = CellValues.String };
 CellValue cellValue = new CellValue();
 cellValue.Text = ReplaceHexadecimalSymbols(cellStringValue);
 cell.Append(cellValue);
 excelRow.Append(cell);
 }

 private static void AppendNumericCell(string cellReference, string cellStringValue, Row excelRow)
 {
 // Add a new Excel Cell to our Row 
 Cell cell = new Cell() { CellReference = cellReference };
 CellValue cellValue = new CellValue();
 cellValue.Text = ReplaceHexadecimalSymbols(cellStringValue);
 cell.Append(cellValue);
 excelRow.Append(cell);
 }
</code></pre>

Thanks let me know if u need further help.

blocks|key|171816|text|我认为x26+"&“是一个有效的字符，它可以被XML反序列化。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171817|因此，要替换非法字符，我们应该使用：|171818|//+Replace+illegal+character+in+XML+documents+with+blank
//+See+here+for+reference+http://www.w3.org/TR/xml/#charsets
var+regex+=+"[\x00-\x08\x0B\x0C\x0E-\x1F]";
xml+=+Regex.Replace(xml,+r,+String.Empty,+RegexOptions.Compiled);|code-block|syntax|javascript|171819|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I think x26 "&amp;" is a valid character and it could be de-serialized by XML.

So to replace illegal character, we should use:

<pre><code>// Replace illegal character in XML documents with blank
// See here for reference http://www.w3.org/TR/xml/#charsets
var regex = "[\x00-\x08\x0B\x0C\x0E-\x1F]";
xml = Regex.Replace(xml, r, String.Empty, RegexOptions.Compiled);
</code></pre>

blocks|key|4677674|text|Regex解决方案即使在100MB的XML文档上也能很快地工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4677675|下面的表达式字符串可以完成这项工作。|4677676|"[\x00-\x08\x0B\x0C\x0E-\x1F]"|code-block|syntax|javascript|4677677|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Regex solution is working quite fast even on 100MB XML document.

The following expression string would do the work.

<pre><code>"[\x00-\x08\x0B\x0C\x0E-\x1F]"
</code></pre>

blocks|key|171880|text|对我来说起作用的是检查特殊字符。失败的特殊字符的字符代码类似于“&”，它也用于“<”中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|171881|public+static+string+CleanInvalidEscapedXmlCharacters(string+s)
++++{
++++++++if(s+==+null+)+return+null;

++++++++StringBuilder+sbOutput+=+new+StringBuilder();
++++++++char+ch;

++++++++//keeps+track+of+which+character+the+previous+character+was.
++++++++bool+hitAmp+=+false;
++++++++bool+hitPound+=+false;
++++++++bool+hitX+=+false;

++++++++string+escapedHold+=+"";
++++++++
++++++++for(+int+i+=+0;+i+<+s.Length;+i%2B%2B+)+
++++++++{
++++++++++++ch+=+s[i];
+++++++++++++++
++++++++++++//check+this+first+so+that+the+x+gets+ignored.
++++++++++++if(hitX)
++++++++++++{
++++++++++++++++//found+the+end+of+the+escaped+portion
++++++++++++++++if(ch+==+';')
++++++++++++++++{
++++++++++++++++++++ch+=+(char)+Int32.Parse(escapedHold,+NumberStyles.AllowHexSpecifier);

++++++++++++++++++++escapedHold+=+"";
++++++++++++++++++++hitX+=+false;
++++++++++++++++++++hitPound+=+false;
++++++++++++++++}
++++++++++++++++else
++++++++++++++++{
++++++++++++++++++++//found+another+digit+in+the+escaped+portion
++++++++++++++++++++escapedHold+%2B=+ch;
++++++++++++++++++++continue;
++++++++++++++++}
++++++++++++}

++++++++++++if(hitPound)
++++++++++++{
++++++++++++++++if(ch+==+'x')
++++++++++++++++{
++++++++++++++++++++//found+&#x
++++++++++++++++++++hitX+=+true;
++++++++++++++++++++continue;
++++++++++++++++}
++++++++++++++++else
++++++++++++++++{
++++++++++++++++++++//found+&#+but+no+x
++++++++++++++++++++//reset+hits+and+output+&#+and+current+character.
++++++++++++++++++++hitAmp+=+false;
++++++++++++++++++++hitPound+=+false;
++++++++++++++++++++sbOutput.Append('&');
++++++++++++++++++++sbOutput.Append('#');
++++++++++++++++++++sbOutput.Append(ch);
++++++++++++++++++++continue;
++++++++++++++++}
++++++++++++}

++++++++++++if(ch+==+'&')
++++++++++++{
++++++++++++++++//found+an+initial+&
++++++++++++++++hitAmp+=+true;
++++++++++++++++continue;
++++++++++++}
++++++++++++if+(hitAmp)
++++++++++++{
++++++++++++++++if+(ch+==+'#')
++++++++++++++++{
++++++++++++++++++++//found+&#
++++++++++++++++++++hitPound+=+true;
++++++++++++++++++++hitAmp+=+false;
++++++++++++++++++++continue;
++++++++++++++++}
++++++++++++++++else
++++++++++++++++{
++++++++++++++++++++//found+&+but+no+#+so+this+is+something+like+&lt;
++++++++++++++++++++//reset+hits+and+output+the+&+and+current+character
++++++++++++++++++++hitAmp+=+false;
++++++++++++++++++++hitPound+=+false;
++++++++++++++++++++sbOutput.Append('&');
++++++++++++++++++++sbOutput.Append(ch);
++++++++++++++++++++continue;
++++++++++++++++}
++++++++++++}

++++++++++++if(!hitAmp+&&+!hitPound+&&+!hitX)
++++++++++++{
++++++++++++++++if+((ch+>=+0x0020+&&+ch+<=+0xD7FF)+%7C%7C
++++++++++++++++++++(ch+>=+0xE000+&&+ch+<=+0xFFFD)+%7C%7C
++++++++++++++++++++ch+==+0x0009+%7C%7C+ch+==+0x000A+%7C%7C+ch+==+0x000D)
++++++++++++++++{
++++++++++++++++++++sbOutput.Append(ch);
++++++++++++++++}
++++++++++++}
++++++++}

++++++++return+sbOutput.ToString();
++++}|code-block|syntax|javascript|171882|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

What worked for me was checking the special characters. The special character which was failing had the char code similar to '&amp;' which is also used in '&lt;'
<pre><code>public static string CleanInvalidEscapedXmlCharacters(string s)
 {
 if(s == null ) return null;

 StringBuilder sbOutput = new StringBuilder();
 char ch;

 //keeps track of which character the previous character was.
 bool hitAmp = false;
 bool hitPound = false;
 bool hitX = false;

 string escapedHold = &quot;&quot;;
 
 for( int i = 0; i &lt; s.Length; i++ ) 
 {
 ch = s[i];
 
 //check this first so that the x gets ignored.
 if(hitX)
 {
 //found the end of the escaped portion
 if(ch == ';')
 {
 ch = (char) Int32.Parse(escapedHold, NumberStyles.AllowHexSpecifier);

 escapedHold = &quot;&quot;;
 hitX = false;
 hitPound = false;
 }
 else
 {
 //found another digit in the escaped portion
 escapedHold += ch;
 continue;
 }
 }

 if(hitPound)
 {
 if(ch == 'x')
 {
 //found &amp;#x
 hitX = true;
 continue;
 }
 else
 {
 //found &amp;# but no x
 //reset hits and output &amp;# and current character.
 hitAmp = false;
 hitPound = false;
 sbOutput.Append('&amp;');
 sbOutput.Append('#');
 sbOutput.Append(ch);
 continue;
 }
 }

 if(ch == '&amp;')
 {
 //found an initial &amp;
 hitAmp = true;
 continue;
 }
 if (hitAmp)
 {
 if (ch == '#')
 {
 //found &amp;#
 hitPound = true;
 hitAmp = false;
 continue;
 }
 else
 {
 //found &amp; but no # so this is something like &amp;lt;
 //reset hits and output the &amp; and current character
 hitAmp = false;
 hitPound = false;
 sbOutput.Append('&amp;');
 sbOutput.Append(ch);
 continue;
 }
 }

 if(!hitAmp &amp;&amp; !hitPound &amp;&amp; !hitX)
 {
 if ((ch &gt;= 0x0020 &amp;&amp; ch &lt;= 0xD7FF) ||
 (ch &gt;= 0xE000 &amp;&amp; ch &lt;= 0xFFFD) ||
 ch == 0x0009 || ch == 0x000A || ch == 0x000D)
 {
 sbOutput.Append(ch);
 }
 }
 }

 return sbOutput.ToString();
 }
</code></pre>

I am loading a lot of xml documents and some of them return errors like "hexadecimal value 0x12, is an invalid character" and there are different character. How to remove them?

C# hexadecimal value 0x12, is an invalid character

我加载了许多xml文档，其中一些返回错误，如“十六进制值0x12，是一个无效的字符”，还有不同的字符。如何移除它们？

问C#十六进制值0x12是无效字符
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#十六进制值0x12是无效字符EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C#十六进制值0x12是无效字符
EN