private static bool HandleHeaders(ExcelConvertorSettings settings, IDataRecord reader, ref string[] headers, ref int[] mandatoryColumnsIndexes) { if (reader.FieldCount == 0 || reader.RowHasEmptyCells()) { return(false); } var currentRow = reader.GetCurrentRow().Select(s => JsonCommon.StringCleanup(s.ToString())); var tmpHeader = JsonCommon.ToCamelCase(currentRow).ToArray(); var mci = new List <int>(); for (var i = 0; i < tmpHeader.Count(); i++) { if (settings.MandatoryColumns.Any(s => tmpHeader[i] .Equals(s, StringComparison.InvariantCultureIgnoreCase))) { mci.Add(i); } } mandatoryColumnsIndexes = mci.ToArray(); headers = tmpHeader; return(true); }