Mahesh Bodepudi

Mahesh Bodepudi

  • NA
  • 90
  • 57k

Showing comments in excel

Jun 14 2016 11:21 AM
Hi,
I am working on excel comments using C#.
if (Fcount > 0)
{
comment = string.Join(Environment.NewLine, dtModified.AsEnumerable().Where(p => p.Field<string>(Constants.FuncName) == FunName1 && (string)p[Constants.Date] == date && (string)p[Constants.PF] == "F").Select(a => a.Field<string>(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
1:06:42 AM,LL:3,Value:0.699428437325653,HL:10
1:06:42 AM,LL:3,Value:0.699428437325653,HL:10
1:06:42 AM,LL:3,Value:0.699428437325653,HL:10
1:06:42 AM,LL:3,Value:0.699428437325653,HL:10
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
3
3
3
3,Value:0.699428437325653
0.718108917040355
0.718004332154577
0.717611501159894
0.716311910658491
0.716757724249684,HL:10
10
10
10
10
10
Please help on this

Answers (1)