private static ExcelColumnInfo LookUpColumn(IList <ExcelColumnInfo> columnList, ExcelColumnOverrideInfo columnOverride)
        {
            ExcelColumnInfo existColumn = null;

            if (columnOverride.Index.HasValue && columnOverride.Index.Value < columnList.Count)
            {
                existColumn = columnList[columnOverride.Index.Value];
            }
            if (existColumn == null && !String.IsNullOrEmpty(columnOverride.Title))
            {
                existColumn = columnList.FirstOrDefault(c => c.Title == columnOverride.Title);
            }
            return(existColumn);
        }
        private static IList <ExcelColumnInfo> RemoveColumn(IList <ExcelColumnInfo> columns, ExcelColumnOverrideInfo removeInfo)
        {
            var toRemoveColumn = LookUpColumn(columns, removeInfo);

            columns.Remove(toRemoveColumn);
            return(columns);
        }