Reading values from Excel with C# converting double to string

Question

I have the code below to iterate through an Excel file to convert it to a pipe delimited file.

for (rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
            {
                for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
                {
                    str = str +"|"+ (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2;

                }
                sw.WriteLine(str);
                str = "";

            }

Problem is that when I get to a numerical value I get a runtime error "Can't convert double to string"

Any ideas how I can write a double value from Excel to file using StreamWriter?

str = str +"|"+ (range.Cells[rCnt, cCnt] as Excel.Range).Value2.ToString() — garryp
– garryp, Commented Sep 8, 2016 at 11:42
Check stackoverflow.com/questions/30231413/… . because Value2 might be null according to that link — Johan
– Johan, Commented Sep 8, 2016 at 11:45

user2960398 · Accepted Answer · 2016-09-08 11:48:26Z

2

public static string ToStr(object readField)
{
    if ((readField != null))
    {
        if (readField.GetType() != typeof(System.DBNull))
        {
            return Convert.ToString(readField);
        }
        else
        {
            return "";
        }
    }
    else
    {
        return "";
    }
}

str = str +"|"+ ToStr((range.Cells[rCnt, cCnt] as Excel.Range).Value2);

Use this way

answered Sep 8, 2016 at 11:48

user2960398

3834 silver badges19 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:51:45Z

2

Casting a value to string like you are doing in your example, does not convert the value to a String value. Since your value is a double as you say you have to use the ToString() method to get a String representation of that value.

for (rCnt = 1; rCnt <= range.Rows.Count; rCnt++)
{
  for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++)
  {
    str = str +"|"+ (range.Cells[rCnt, cCnt] as Excel.Range).Value2.ToString();
  }
  sw.WriteLine(str);
  str = "";
}

Casting vs Converting an object toString, when object really is a string

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Sep 8, 2016 at 11:47

Bojan B

2,1214 gold badges20 silver badges26 bronze badges

Collectives™ on Stack Overflow

Reading values from Excel with C# converting double to string

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related