private List <ThreatEntry> GetFileData(string fileName) { Excel.Application excel = new Excel.Application(); Excel.Workbook excelWorkbook = excel.Workbooks.Open(Directory.GetCurrentDirectory() + "/" + fileName, 0, true); Excel.Worksheet excelSheet = excelWorkbook.Sheets[1]; Excel.Range excelRange = excelSheet.UsedRange; List <ThreatEntry> fileData = new List <ThreatEntry>(excelRange.Rows.Count); for (int iRow = 3; iRow <= excelRange.Rows.Count; iRow++) { int columnCount = excelRange.Columns.Count - 2; string[] rowValues = new string[columnCount]; for (int jColumn = 1; jColumn <= columnCount; jColumn++) { rowValues[jColumn - 1] = excelSheet.Cells[iRow, jColumn].Value.ToString(); } ThreatEntry newEntry = new ThreatEntry ( int.Parse(rowValues[0]), rowValues[1].Replace("\r\n", "\n"), rowValues[2].Replace("\r\n", "\n"), rowValues[3].Replace("\r\n", "\n"), rowValues[4].Replace("\r\n", "\n"), rowValues[5] == "1", rowValues[6] == "1", rowValues[7] == "1" ); fileData.Add(newEntry); } excel.Quit(); return(fileData); }
public EntryDiff(ThreatEntry before, ThreatEntry after) { Before = before; After = after; }