Showing comments in excel

Hi,

I am working on excel comments using C#.

if (Fcount > 0)

{

comment = string.Join(Environment.NewLine, dtModified.AsEnumerable().Where(p => p.Field(Constants.FuncName) == FunName1 && (string)p[Constants.Date] == date && (string)p[Constants.PF] == "F").Select(a => a.Field(Constants.Time))) + "LL:" + LowLevel + "," + "Value:" + Value + "," + "HL:" + HighLevel;

}

If Fcount is 6 then

I should get the output as(comment variable )

1:06:42 AM,LL:3,Value:0.699428437325653,HL:10

But

I am getting the out put as

1:06:42 AM

1:08:19 AM

1:09:57 AM

1:11:35 AM

1:13:13 AM

1:14:51 AMLL:3

3,Value:0.699428437325653

0.718108917040355

0.718004332154577

0.717611501159894

0.716311910658491

0.716757724249684,HL:10

Please help on this

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Hello,
Notice that there is a problem where there is , (comma)
Just to establish, why not, for the time being, put some other character such as ? in place of , and test.
Because Excel is also programmed to give , (comma) a special treatment, from the point of view of comma separated values (csv) it is possible , might be creating problem.
One more thing:
Why not try enclosing the whole string within double-quotes. That might solve!