blocks|key|1379035|text|如果您读取的文件已经在UTF-8中编码，则代码工作正常，但如果使用不同的编码，代码将无法工作。我建议将文件加载到像Notepad%2B%2B这样的文本编辑器中，它告诉您文件的编码是什么(在状态栏中)。如果它不是编码在UTF-8开始，读和写作为UTF-8将无法工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1379036|如果要尝试读取系统默认编码中的文件，可以使用Encoding.Default而不是UTF8。然后，在编写该文件时，您应该写入一个新文件，因为您实际上不能将多个编码写入同一个文件。如果UTF-8不是，则默认编码可能是正确的编码。|offset|length|style|CODE|1379037|string+filePath+=+@"C:\users\yourname\desktop\TestFile.txt";
string[]+lines+=+File.ReadAllLines(filePath,+Encoding.Default);

string+outFile+=+@"C:\users\yourname\desktop\outfile.txt";
Stream+s+=+new+FileStream(outFile,+FileMode.Append);
StreamWriter+sw+=+new+StreamWriter(s,+Encoding.UTF8,+1000,+true);
foreach+(var+line+in+lines)
+++sw.WriteLine(line);
sw.Close();|code-block|syntax|javascript|1379038|或者，如果必须附加到同一个文件，则使用与读取文件相同的编码方式，或重写整个文件。如果原始文件在记事本中看起来没有问题，系统的默认编码很可能是正确的编码。如果要将文件保留在系统的当前编码中，请使用Encoding.Default。如果您想将整个文件的编码更改为UTF-8，我认为您必须重写整个文件，而不是追加。|1379039|如果Notepad%2B%2B在状态栏中显示了这一点，那么您就不能将该文件作为UTF-8读取。|1379040|📷|atomic|1379041|​|1379042|如果Notepad%2B%2B在状态栏中显示如下内容，则只能使用UTF-8：|1379043|1379044|1379045|1379046|您可以在Notepad%2B%2B中使用"Encoding“菜单的”8“命令使该文件与您的应用程序兼容。|1379047|警告:不要混淆“编码在UTF-8”命令和“转换为UTF-8”命令。如果文件看起来是正确的，你想使用“转换为UTF-8”。如果您使用“在UTF-8中编码”，则会将现有数据重新解释为新的编码，而不是将内容更改为使用新的编码。|1379048|编辑：将Encoding.GetEncoding(0)更改为Encoding.Default。|BOLD|1379049|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/5e9588598ff410590eb54263f6e9ab42.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/26f456d3d7ebf47e2cdf767808b27688.png^0|0|M|G|0|0|2P|G|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0|0|0|2|4|N|U|G|0^^$0|@$1|2|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1J|8|@$D|1K|E|1L|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1M|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1N|8|@$D|1O|E|1P|F|G]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1R|8|@]|9|@$D|1S|E|1T|1|1U]]|A|$]]|$1|T|3|U|5|6|7|1V|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1W|8|@]|9|@]|A|$]]|$1|X|3|U|5|6|7|1X|8|@]|9|@]|A|$]]|$1|Y|3|R|5|S|7|1Y|8|@]|9|@$D|1Z|E|20|1|21]]|A|$]]|$1|Z|3|U|5|6|7|22|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|23|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|24|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|25|8|@$D|26|E|27|F|16]|$D|28|E|29|F|G]|$D|2A|E|2B|F|G]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]]|18|$19|$5|1A|1B|1C|A|$1D|1E|1F|-4]]|1G|$5|1A|1B|1C|A|$1D|1H|1F|-4]]]]

Your code works OK if the file you'rte reading is already encoded in UTF-8, but it won't work if it's using a different encoding. I would recommend loading the file into a text editor like Notepad++ that tells you what the encoding of the file is (in the status bar). If it's not encoded in UTF-8 to start with, reading and writing as UTF-8 won't work.

If you want to try reading the file in the system's default encoding, you could use <code>Encoding.Default</code> instead of UTF8. Then you should write to a new file when writing the file because you can't really write multiple encodings to the same file. The default encoding is likely to be the correct encoding if UTF-8 isn't.

<pre><code>string filePath = @"C:\users\yourname\desktop\TestFile.txt";
string[] lines = File.ReadAllLines(filePath, Encoding.Default);

string outFile = @"C:\users\yourname\desktop\outfile.txt";
Stream s = new FileStream(outFile, FileMode.Append);
StreamWriter sw = new StreamWriter(s, Encoding.UTF8, 1000, true);
foreach (var line in lines)
 sw.WriteLine(line);
sw.Close();
</code></pre>

Alternatively if you have to append to the same file, use the same encoding that you did for reading the file, or rewrite the whole file. If the original file looks OK in notepad, the system's default encoding is likely to be the correct encoding. If you want to leave the file in the system's current encoding, use <code>Encoding.Default</code>. If you want to change the encoding of the whole file to UTF-8, I think you'd have to rewrite the whole file instead of appending.

If Notepad++ shows this in the status bar, then you can't read the file as UTF-8
<a href="https://i.stack.imgur.com/AtECu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AtECu.png" alt="enter image description here"></a>

You can only use UTF-8 if Notepad++ shows something like this in the status bar:

<a href="https://i.stack.imgur.com/4CPVh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4CPVh.png" alt="enter image description here"></a>

You can use the "Encoding" menu's "Convert to UTF-8" command in Notepad++ to make the file compatible with your application.

Warning: Don't confuse the "Encode in UTF-8" command with the "Convert to UTF-8" command. If the file looks correct, you want to use "Convert to UTF-8". If you use "Encode in UTF-8" that will re-interpret the existing data as a new encoding instead of changing the content to use a new encoding.

Edit: Change <code>Encoding.GetEncoding(0)</code> to <code>Encoding.Default</code>.

blocks|key|2436854|text|而不是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2436855|StreamWriter+sw+=+new+StreamWriter(s,+Encoding.UTF8,+1000,+true);|code-block|syntax|javascript|2436856|用这个：|2436857|StreamWriter+sw+=+new+StreamWriter(s,+Encoding.Unicode,+1000,+true);|2436858|我刚刚试了一下，它在NotePad%2B%2B中显示得很正确|2436859|下面是我运行的用于测试它的示例：|2436860|++++++++using+(StreamWriter+swClifor+=+new+StreamWriter("test.txt",+true,+Encoding.Unicode))
++++++++{
++++++++++++string+cString+=+"en+dash+–,+left+double+quotes+“,+and+right+double+quotes+”";
++++++++++++swClifor.WriteLine(cString);
++++++++}|2436861|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Instead of:

<pre><code>StreamWriter sw = new StreamWriter(s, Encoding.UTF8, 1000, true);
</code></pre>

use this:

<pre><code>StreamWriter sw = new StreamWriter(s, Encoding.Unicode, 1000, true);
</code></pre>

I just tried it and it shows up correctly in NotePad++

Here's the sample I ran that I used for testing it:

<pre><code> using (StreamWriter swClifor = new StreamWriter("test.txt", true, Encoding.Unicode))
 {
 string cString = "en dash –, left double quotes “, and right double quotes ”";
 swClifor.WriteLine(cString);
 }
</code></pre>

blocks|key|2674434|text|哦，天哪，我现在想出来了，这看起来很傻，但事情就是这样的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2674435|NotePad%2B%2B状态栏显示为ANSI。一开始，我没有提供读或写的编码。|2674436|在查看要使用的编码选项时，我发现在默认编码中有一个选项：|2674437|string[]+lines+=+File.ReadAllLines(filePathTxt.Text,+Encoding.Default);|code-block|syntax|javascript|2674438|但是我从来没有尝试过这种方法，因为没有指定使用哪种编码必须是默认的，对吧？嗯，我想不是因为实际上在读和写的时候给了它这个，使它现在正常工作了。|2674439|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Oh man, I figured it out now, this seems silly, but here is what it was.

NotePad++ status bar showed it as ANSI. Initially I tried without providing the encoding on read or write.

When looking through the options of the encoding to use I saw there was an option in Encoding for Default:

<pre><code>string[] lines = File.ReadAllLines(filePathTxt.Text, Encoding.Default);
</code></pre>

BUT I never actually tried this one because surely not specifying which encoding to use must be the default already right? Well I guess not because actually giving it this on the read and write made it work correctly now.

blocks|key|2674457|text|试着做这个..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2674458|我必须写非英语(孟加拉)语言，但不支持这种语言。|2674459|工作:+Encoding.Unicode和Encoding.UTF32使用StreamWriter在C#中支持外文字符|2674460|用这个：|2674461|+StreamWriter+wr+=+new+StreamWriter(@"D:\TestBook.xls",+true,+Encoding.Unicode);++|code-block|syntax|javascript|2674462|或|2674463|+StreamWriter+wr+=+new+StreamWriter(@"D:\TestBook.xls",+true,+Encoding.UTF32);+|2674464|C#代码：|2674465|+private+void+ExportExcel()
++++{
++++++++try
++++++++{
++++++++++++DataTable+dt+=+new+DataTable();

++++++++++++//Add+Datacolumn
++++++++++++DataColumn+workCol+=+dt.Columns.Add("Name",+typeof(String));
++++++++++++dt.Columns.Add("BanglaLanguage",+typeof(String));
++++++++++++dt.Columns.Add("City",+typeof(String));

++++++++++++//Add+in+the+datarow
++++++++++++DataRow+newRow+=+dt.NewRow();

++++++++++++newRow["Name"]+=+"MahalingaM";
++++++++++++newRow["BanglaLanguage"]+=+"সালাউদ্দিন+স্টোর";//Bangla+Language
++++++++++++newRow["City"]+=+"Coimbatore";
++++++++++++dt.Rows.Add(newRow);

++++++++++++//open+file
++++++++++++//non+english+not+support(ex:+Bangla+Language)
++++++++++++//+StreamWriter+wr+=+new+StreamWriter(@"D:\TestBook.xls");

++++++++++++//non+english+support(ex:+Bangla+Language)
++++++++++++StreamWriter+wr+=+new+StreamWriter(@"D:\TestBook.xls",+true,+Encoding.Unicode);+//+Encoding.Unicode+or+Encoding.UTF32

++++++++++++for+(int+i+=+0;+i+<+dt.Columns.Count;+i%2B%2B)
++++++++++++{
++++++++++++++++wr.Write(dt.Columns[i].ToString().ToUpper()+%2B+"\t");
++++++++++++}

++++++++++++wr.WriteLine();

++++++++++++//write+rows+to+excel+file
++++++++++++for+(int+i+=+0;+i+<+(dt.Rows.Count);+i%2B%2B)
++++++++++++{
++++++++++++++++for+(int+j+=+0;+j+<+dt.Columns.Count;+j%2B%2B)
++++++++++++++++{
++++++++++++++++++++if+(dt.Rows[i][j]+!=+null)
++++++++++++++++++++{
++++++++++++++++++++++++wr.Write(Convert.ToString(dt.Rows[i][j])+%2B+"\t");
++++++++++++++++++++}
++++++++++++++++++++else
++++++++++++++++++++{
++++++++++++++++++++++++wr.Write("\t");
++++++++++++++++++++}
++++++++++++++++}
++++++++++++++++//go+to+next+line
++++++++++++++++wr.WriteLine();
++++++++++++}
++++++++++++//close+file
++++++++++++wr.Close();

++++++++++++//xls+to+xlsx+convertion
++++++++++++Microsoft.Office.Interop.Excel.Application+app+=+new+Microsoft.Office.Interop.Excel.Application();
++++++++++++Microsoft.Office.Interop.Excel.Workbook+wb+=+app.Workbooks.Open(@"D:\TestBook.xls",+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing);
++++++++++++wb.SaveAs(@"D:\TestBook.xlsx",+Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing,+Type.Missing);
++++++++++++wb.Close();
++++++++++++app.Quit();

++++++++}
++++++++catch+(Exception+ex)
++++++++{
++++++++++++throw+ex;
++++++++}
++++}|2674466|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|14|8|@]|9|@]|A|$K|L]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

Try do this....
I have to write non english(Bangla) Language, but not support this language.
Working:
Encoding.Unicode and Encoding.UTF32 is supporting foreign characters using StreamWriter in C#
use this:
<pre><code> StreamWriter wr = new StreamWriter(@&quot;D:\TestBook.xls&quot;, true, Encoding.Unicode); 
</code></pre>
or
<pre><code> StreamWriter wr = new StreamWriter(@&quot;D:\TestBook.xls&quot;, true, Encoding.UTF32); 
</code></pre>
C# code:
<pre><code> private void ExportExcel()
 {
 try
 {
 DataTable dt = new DataTable();

 //Add Datacolumn
 DataColumn workCol = dt.Columns.Add(&quot;Name&quot;, typeof(String));
 dt.Columns.Add(&quot;BanglaLanguage&quot;, typeof(String));
 dt.Columns.Add(&quot;City&quot;, typeof(String));

 //Add in the datarow
 DataRow newRow = dt.NewRow();

 newRow[&quot;Name&quot;] = &quot;MahalingaM&quot;;
 newRow[&quot;BanglaLanguage&quot;] = &quot;সালাউদ্দিন স্টোর&quot;;//Bangla Language
 newRow[&quot;City&quot;] = &quot;Coimbatore&quot;;
 dt.Rows.Add(newRow);

 //open file
 //non english not support(ex: Bangla Language)
 // StreamWriter wr = new StreamWriter(@&quot;D:\TestBook.xls&quot;);

 //non english support(ex: Bangla Language)
 StreamWriter wr = new StreamWriter(@&quot;D:\TestBook.xls&quot;, true, Encoding.Unicode); // Encoding.Unicode or Encoding.UTF32

 for (int i = 0; i &lt; dt.Columns.Count; i++)
 {
 wr.Write(dt.Columns[i].ToString().ToUpper() + &quot;\t&quot;);
 }

 wr.WriteLine();

 //write rows to excel file
 for (int i = 0; i &lt; (dt.Rows.Count); i++)
 {
 for (int j = 0; j &lt; dt.Columns.Count; j++)
 {
 if (dt.Rows[i][j] != null)
 {
 wr.Write(Convert.ToString(dt.Rows[i][j]) + &quot;\t&quot;);
 }
 else
 {
 wr.Write(&quot;\t&quot;);
 }
 }
 //go to next line
 wr.WriteLine();
 }
 //close file
 wr.Close();

 //xls to xlsx convertion
 Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
 Microsoft.Office.Interop.Excel.Workbook wb = app.Workbooks.Open(@&quot;D:\TestBook.xls&quot;, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
 wb.SaveAs(@&quot;D:\TestBook.xlsx&quot;, Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
 wb.Close();
 app.Quit();

 }
 catch (Exception ex)
 {
 throw ex;
 }
 }
</code></pre>

I'm reading csv files that contain special characters such as the long en dash –, left double quotes “, and right double quotes ” and I can't figure out the proper way to read and write these correctly. I thought it was UTF8 or Unicode but it reads and writes them as a square or ? with a diamond. Opening the files in notepad++ to confirm. Maybe another specific encoding is needed? Here is the code I've been using so far, tried a few variations of this with different encoding.:

<pre><code>string[] lines = File.ReadAllLines(filePathTxt.Text, Encoding.UTF8);
...
Stream s = new FileStream(filePath, FileMode.Append);
StreamWriter sw = new StreamWriter(s, Encoding.UTF8, 1000, true);
</code></pre>

Input of: 

Surveys – Public

Documents:,“A”

comes out as

Surveys � Public

Documents:,�A�

Also shows problems in debugger as soon as it's read into the string array.

Edit: I've tried Unicode also. I'm using NotePad++, Win 10. The problem is definitely in the Read step, because if I add the following line to manually write a line of data, like so:

<pre><code> sw.WriteLine("Surveys – Public");
</code></pre>

That line writes the dash fine, so it's on the initial read of the file from the source csv where the characters get messed up. I've tried reading with a few different encodings, and NotePad++ just shows the csv as being ANSI.

What is the encoding to read and write files with special characters such as en dash, left quotes, etc?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在读取包含特殊字符的csv文件，例如long en dash -、左双引号“和右双引号”，而且我无法找到正确读取和写入这些字符的正确方法。我以为它是UTF8或Unicode，但它将它们读写为正方形或？带着钻石。打开notepad++中的文件以确认。也许还需要另一种特定的编码？下面是我到目前为止使用的代码，用不同的编...

问用特殊字符(如en破折号、左引号等)读写文件的编码是什么？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用特殊字符(如en破折号、左引号等)读写文件的编码是什么？EN