/// <summary> /// Gets pointArray from file from specified path /// </summary> /// <returns></returns> private int[,] getPointsFromFile() { if (Properties.Settings.Default.PathToTemplate.Equals("")) { MessageBox.Show("Please select a template in settings", "Failed to read points"); return null; } int[,] pointsArray = new int[41, 41]; try { var workbook = new XLWorkbook(Properties.Settings.Default.PathToTemplate); IXLWorksheet worksheet; if (!workbook.TryGetWorksheet("Points", out worksheet)) { MessageBox.Show("Worksheet 'Points' not found in template", "Failed to read points"); return null; } for (int i = 3; i < 41; i++) { for (int j = 2; j < 39; j++) { var value = worksheet.Cell(i, j).Value.ToString(); if (value.Equals("")) { break; } if (!int.TryParse(worksheet.Cell(i, j).Value.ToString(), out pointsArray[-2 + i, 42 - j])) { MessageBox.Show("Error reading points" + i + " " + j); break; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Failed to read points"); return null; } return pointsArray; }