private static void ThreatsFromExelToList(string link)
{
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (ExcelPackage xlPackage = new ExcelPackage(new FileInfo(link)))
{
var myWorksheet = xlPackage.Workbook.Worksheets.First(); //select sheet here
var totalRows = myWorksheet.Dimension.End.Row;
var totalColumns = myWorksheet.Dimension.End.Column;
var sb = new StringBuilder(); //this is your data
for (int rowNum = 1; rowNum <= totalRows; rowNum++) //select starting row here
{
var row = myWorksheet.Cells[rowNum, 1, rowNum, totalColumns].Select(c => c.Value == null ? string.Empty : c.Value.ToString());
sb.AppendLine(string.Join("NEXTCELL", row));
sb.AppendLine("ENDROW"); //end of a row
}
string[] threatStringsByRows = sb.ToString().Split(new string[] { "ENDROW" }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 2; i < threatStringsByRows.Length; i++)
{
var threatString = threatStringsByRows[i].Replace("\n", "").Replace("\r", "").Split(new string[] { "NEXTCELL" }, StringSplitOptions.None);
if (threatString.Length == 10)
{
ISThreat tempoThreat = new ISThreat(Int32.Parse(threatString[0]));
tempoThreat.ThreatName = threatString[1].ToString();
tempoThreat.ThreatInfo = threatString[2].ToString();
tempoThreat.ThreatSource = threatString[3].ToString();
tempoThreat.ThreaObj = threatString[4].ToString();
tempoThreat.ConfidentialityViolation = Convert.ToBoolean(Int32.Parse(threatString[5]));
tempoThreat.IntegrityViolation = Convert.ToBoolean(Int32.Parse(threatString[6]));
tempoThreat.AvailabilityViolation = Convert.ToBoolean(Int32.Parse(threatString[7]));
parsedThreatList.Add(tempoThreat);
}
}
}
}
public ThreatInfo(ISThreat threat)
{
InitializeComponent();
ThreatID.Text = threat.ThreatId.ToString();
ThreatCnf.Text = (threat.ConfidentialityViolation ? "Да" : "Нет");
ThreatAvb.Text = (threat.AvailabilityViolation ? "Да" : "Нет");
ThreatIng.Text = (threat.IntegrityViolation ? "Да" : "Нет");
ThreatObj.Text = threat.ThreaObj.ToString();
ThreatInf.Text = threat.ThreatInfo.ToString();
ThreatName.Text = threat.ThreatName.ToString();
ThreatSource.Text = threat.ThreatSource.ToString();
}
