Not gettting all columns about excelmapper

[alexkbecker]

It worked!!!!
Thanks man!!!

[mganss]

If you're not mapping via the header row then you need to set HeaderRow = false (even though the sheet may contain a header row which you're not using for mapping columns to properties). In your example the data rows start at index 4 (numbering starts at 0 not 1!) so this seems to work:

var planilhaRessarcimento = new ExcelMapper(@"Dados\FICHAS_CAT_42.xlsx") 
{ 
    SkipBlankRows = true, 
    TrackObjects = false, 
    MinRowNumber = 4, 
    HeaderRow = false 
};

SkipBlankRows = true isn't even necessary for the specific example, nor is TrackObjects = false.