Comments by Member 11053420

Member 11053420 7-Oct-14 0:30am View

the messagebox.show displaying as same as in excel sheet, its displaying row by row value... its not summing and grouping

Member 11053420 6-Oct-14 0:26am View

Deleted

Can anyone please help me for the above issue

Member 11053420 2-Oct-14 2:28am View

Hi, i have tried below code .. i wanted to group and sum the values but its not grouping at all. Pls find my code below
var groupp=from k in excelFile.Worksheet(sheetName).ToList() select k;
var grouped = from row in groupp group row by row["Issue Type"] into g select new { edd = g.Key, c = g.Sum(row => Convert.ToDouble(row["Time Spent"])) };
foreach (var groupe in grouped)
MessageBox.Show("key is" + groupe.edd + " : count=" + groupe.c);

Member 11053420 2-Oct-14 2:27am View

Deleted

Hi, i have tried below code .. i wanted to group and sum the values but its not grouping at all. Pls find my code below
var groupp=from k in excelFile.Worksheet(sheetName).ToList() select k;
var grouped = from row in groupp group row by row["Issue Type"] into g select new { edd = g.Key, c = g.Sum(row => Convert.ToDouble(row["Time Spent"])) };
foreach (var groupe in grouped)
MessageBox.Show("key is" + groupe.edd + " : count=" + groupe.c);

Member 11053420 2-Oct-14 2:27am View

Hi, i have tried below code .. i wanted to group and sum the values but its not grouping at all. Pls find my code below
var groupp=from k in excelFile.Worksheet(sheetName).ToList() select k;
var grouped = from row in groupp group row by row["Issue Type"] into g select new { edd = g.Key, c = g.Sum(row => Convert.ToDouble(row["Time Spent"])) };
foreach (var groupe in grouped)
MessageBox.Show("key is" + groupe.edd + " : count=" + groupe.c);

Member 11053420 1-Oct-14 7:24am View

Thanks.. I will try and come back if required or incase if i face any issue

Comments by Member 11053420 (Top 6 by date)