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;
}
