How to get the cell values from 3 different columns in an excel file

[kumarma]

Hi,

There are 2 sheets in my Excel file, i have named ranges for the data within those sheets. I want to load the data from Column A, B & D from A6 till A21 and its corresponding column cell values (B6 till B21 - D6 till D21)

Column Values in A will be the Title and Column Values in B and D will be the Actual Numbers

Named range for Sheet 1 data is S_1 and for Sheet 2 is S_2

How is this possible?

[Vegar]

Use the load data wizard to get the correct syntax for sheet 1 then you can just loop through the sheets changing the number from 1, 2 to X by a variable.

For _i = to 2 step 1

LOAD A, B, C From excel.xlsx (..., 'Sheet $(_i)',...);

next _i