private void ChooseFirstFolderButton_Click(object sender, System.EventArgs e) { chosenPath = ManagerSearcherCommon.SelectFile(); if (!string.IsNullOrEmpty(chosenPath.Trim())) { StatusLabelText.Text = "Start process"; ChoosenPathLabel.Text = chosenPath; } }
public void ProcessFileByEpp() { FileInfo fi = new FileInfo(excelFilePath); if (fi.Exists) { p = new ExcelPackage(fi); ExcelWorksheet workSheet = p.Workbook.Worksheets[1]; DataTable dt = new DataTable(); var start = workSheet.Dimension.Start.Row + 1; var end = workSheet.Dimension.End.Row; for (int row = start; row <= end; row++) { string names = workSheet.Cells[row, 3].Text; string URL = workSheet.Cells[row, 4].Text; if (string.IsNullOrEmpty(names)) { break; } var data = ManagerSearcherCommon.GetMiddleAndSurname(names).Split(','); string middlename = data[0]; string surname = data[1]; object arg = row; tasks.Add(Task.Factory.StartNew(new Action <object>((argValue) => { try { int num = Convert.ToInt32(argValue); Debug.WriteLine(num); if (isNFF(middlename, surname, URL)) { workSheet.Cells[num, 6].Value = "NFF"; } else { workSheet.Cells[num, 6].Value = "FF"; } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }), arg)); } } }