How to read data from Excel nth Row
Most of you might face this common problem that records are not in the common format in excel sheet reports as column header is on first row and records are following. Here I am try to explain one of the real scenario which I had faced.
In this below excel sheet, you can see that records are beginning from 6th row(B6) and 2nd column(B).
There so many ways to handle this, for me the easiest way is to use SQL Command in Excel Source as show below.
No comments:
Post a Comment