Data in excel comes in various forms and nature. Some time you are reading data from a well-defiend excel file and some time your data in excel is scattered. In many occasion you have to read the data from a single cell only.
In a scenario when your excel file data is scattered or you want to read data from a particular cell you can try the approach discuss in this post. Let us assume my excel data is like below screen. I have to read data of B5, C2 and D6 cell and combined them into one column.
To read the single cell or RANGE we have to select the range from the Excel Source Editor. I am not selecting Sheet1 or Sheet2 but RANGE names (compan1, company2 and company3) which we defined in the excel file.