Is there a way to auto detect header row and data rows?

[devkincaid]

Imagine I have the possibility for random excel rows above and below the actual data rows and header. Basically find rows with the most same number of cells. That's the stuff you are trying to import. The first column in that set would be header row.

This is useful for excel imports that have required header or footer rows that have nothing to do with the data. It would also allow more flexibility without forcing the user into using a template.

[donnytian]

I don't have any idea about how to auto-detect header row and date rows. We already have a setting to specify header row number. Maybe we can have another to specify the range of data rows?