private void ClearEarlierResultsIfPresent(Worksheet worksheet, int headerRow, int lastColumn, List <InputCompany> verifiedCompanies, List <InputCompany> erroredWhileReadingInputFileCompanies)
{
foreach (var company in verifiedCompanies)
{
Range rangeToClean = worksheet.Range[SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(company.RowNumber, lastColumn + 1), SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(company.RowNumber, lastColumn + _numberOfColumnsToClean)];
ClearRange(rangeToClean);
}
foreach (var errcompany in erroredWhileReadingInputFileCompanies)
{
Range rangeToClean = worksheet.Range[SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(errcompany.RowNumber, lastColumn + 1), SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(errcompany.RowNumber, lastColumn + _numberOfColumnsToClean)];
ClearRange(rangeToClean);
}
Range headerRange = worksheet.Range[SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(headerRow, lastColumn + 1), SpreadSheetHelper.ConvertCellAddresFromNumsToLetterNum(headerRow, lastColumn + _numberOfColumnsToClean)];
headerRange.Font.Bold = true;
headerRange.Interior.Color = XlRgbColor.rgbLightGray;
//headerRange.Formula = string.Empty;
headerRange.WrapText = true;
}
