private void load_button_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog; ExcelFile loadedFile; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; bool first_run = true, finish = false, write = true; int j = 0; openFileDialog = new OpenFileDialog { Title = "Browse Excel Files", CheckFileExists = true, CheckPathExists = true, RestoreDirectory = true, DefaultExt = "xlsx", Filter = "xlsx files (*.xlsx)|*.xlsx", FilterIndex = 2, ShowReadOnly = true }; if (openFileDialog.ShowDialog() != DialogResult.OK) { return; } loadedFile = ExcelFile.Load(openFileDialog.FileName); total_rows = 0; foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (write && !first_run && !finish) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { if (String.Equals(cell.Value.ToString(), "TOTAL:")) { finish = true; break; } setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); ++j; write = true; } write = false; } elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); setLoad(total_rows); ++total_rows; j = 0; } first_run = false; } } MessageBox.Show("File loaded!"); load_button.Enabled = false; save_button.Enabled = true; get_hours_normal.Enabled = true; }