How to read from excel in a specific encoding?

Question

I copied from an excel file to a txt file the column names. I read from the txt file the following way:

CultureInfo cultureHU;
Encoding encodingHU;
cultureHU = CultureInfo.GetCultureInfo("hu-HU");
encodingHU = Encoding.GetEncoding(cultureHU.TextInfo.ANSICodePage);
using (StreamReader sr = new StreamReader("settings.txt", encodingHU, true))
{
...
}

How do I read from an Excel file with the same encoding? If I do it the default way (xlRange.Cells[1, i].Value.ToString()), then I get wrong values:

in the excel and txt file I have: "Szerzõdõ"
reading from the text file in encodingHU encoding I get: "Szerződő" (this is the correct format)
reading from excel in C# i get: "Szerzõdõ"

SLaks · Accepted Answer · 2012-11-18 01:51:10Z

2

You can convert the bad string to the correct encoding like this:

Console.WriteLine(encodingHU.GetString(Encoding.Default.GetBytes(str)));

answered Nov 18, 2012 at 1:51

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

markotny · Accepted Answer · 2021-06-15 07:31:58Z

0

I used ExcelDataReader. I needed coding 1250

ExcelReaderConfiguration conf = new ExcelReaderConfiguration();
conf.FallbackEncoding = Encoding.GetEncoding(1250);

using (IExcelDataReader reader = ExcelReaderFactory.CreateReader(stream, conf))
{
...
}

answered Jun 15, 2021 at 7:31

markotny

111 bronze badge

Collectives™ on Stack Overflow

How to read from excel in a specific encoding?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related