internal static ExcelRowDataModel AddDataToExcelRow(FileStatusLine fileStatusLine, ExcelRowDataModel data)
{
if (fileStatusLine.SerialNumber != data.SerialNumber)
{
return(data);
}
data.Engineer = fileStatusLine.Engineer;
data.Bank = fileStatusLine.Bank;
data.ActNumber = fileStatusLine.ActNumber;
data.ActDate = fileStatusLine.Date;
data.Explanation = fileStatusLine.Explanation;
data.Resume = fileStatusLine.Summary.ToRussianString();
data.WorkDescription = fileStatusLine.WorkDescription;
data.Result = fileStatusLine.WorkResult.ToRussianString();
data.JobsType = fileStatusLine.WorkType.ToRussianString();
return(data);
}
public void LoadExcelModel(string fileName, ExcelRowDataModelList listExcelRowDataModel)
{
try
{
string cell1, cell2, excelmodelcell3;
if (File.Exists(fileName))
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(fileName);
Excel.Worksheet xlWorksheet = xlWorkbook.Sheets[1]; // assume it is the first sheet
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
for (int i = 2; i <= rowCount; i++)
{
ExcelRowDataModel excelmodel = new ExcelRowDataModel();
if (xlRange.Cells[i, 1] != null && xlRange.Cells[i, 1].Value2 != null)
{
excelmodel.Scope = xlRange.Cells[i, 1].Value2.ToString();
}
if (xlRange.Cells[i, 2] != null && xlRange.Cells[i, 2].Value2 != null)
{
excelmodel.Project = xlRange.Cells[i, 2].Value2.ToString();
}
if (xlRange.Cells[i, 3] != null && xlRange.Cells[i, 3].Value2 != null)
{
excelmodel.Namespace = xlRange.Cells[i, 3].Value2.ToString();
}
if (xlRange.Cells[i, 4] != null && xlRange.Cells[i, 4].Value2 != null)
{
excelmodel.Type = xlRange.Cells[i, 4].Value2.ToString();
}
if (xlRange.Cells[i, 5] != null && xlRange.Cells[i, 5].Value2 != null)
{
excelmodel.Member = xlRange.Cells[i, 5].Value2.ToString();
}
if (xlRange.Cells[i, 6] != null && xlRange.Cells[i, 6].Value2 != null)
{
excelmodel.MaintainabilityIndex = xlRange.Cells[i, 6].Value2.ToString();
}
if (xlRange.Cells[i, 7] != null && xlRange.Cells[i, 7].Value2 != null)
{
excelmodel.CyclomaticComplexity = xlRange.Cells[i, 7].Value2.ToString();
}
if (xlRange.Cells[i, 8] != null && xlRange.Cells[i, 8].Value2 != null)
{
excelmodel.DepthofInheritance = xlRange.Cells[i, 8].Value2.ToString();
}
if (xlRange.Cells[i, 9] != null && xlRange.Cells[i, 9].Value2 != null)
{
excelmodel.ClassCoupling = xlRange.Cells[i, 9].Value2.ToString();
}
if (xlRange.Cells[i, 10] != null && xlRange.Cells[i, 10].Value2 != null)
{
excelmodel.LinesofCode = xlRange.Cells[i, 10].Value2.ToString();
}
listExcelRowDataModel.Add(excelmodel);
}
}
}
catch (AccessViolationException)
{
}
catch (Exception ex)
{
//System.Windows.Forms.MessageBox.Show("Unknown error", "Unknown error");
}
}
