public Information CalculateSingleWorksheetSync(Excel.Worksheet wks) { int resultFromCalculation = 0; int resultTryParse; int lastRow = ExcelFeatures.LastRowPerColumn(1, wks); for (int i = 1; i < lastRow; i++) { if (Int32.TryParse(wks.Cells[i, 1].Text, out resultTryParse)) { resultFromCalculation += resultTryParse; } } Information infoToReturn = new Information(wks.Name, resultFromCalculation, lastRow); Console.WriteLine(infoToReturn.ToString()); return(infoToReturn); }
public async Task <Information> CalculateSingleWorksheetAsync(Excel.Worksheet wks) { int lastRow = ExcelFeatures.LastRowPerColumn(1, wks); int result = await Task.Run(() => { int resultFromCalculation = 0; int resultTryParse; for (int i = 1; i < lastRow; i++) { if (Int32.TryParse(wks.Cells[i, 1].Text, out resultTryParse)) { resultFromCalculation += resultTryParse; } } return(resultFromCalculation); }); Information infoToReturn = new Information(wks.Name, result, lastRow); Console.WriteLine(infoToReturn.ToString()); return(infoToReturn); }