loading tables

[prabhas277]

Hi experts,

for  example i have 50 excel sheets  now i want load 20 sheets from the 50 sheets.now my req is i want load 10-15 shhets,20-25 and 30-35 and 45 to 50 how i can get it?

[tresesco]

Some good discussion links are here: Re: Import multiple sheets in excel

[sujeetsingh]

what you need is still not clear?

Well you can write codes to load sheets with a number added to the name of sheet and then use these numbers for sorting and loading.

[kuczynska]

You can create subroutine and load your tables in the loop, considering some conditions (like validating the excel sheet numbers).

[krishna20]

Hi,

This may helps you,

Load Multiple excel sheets using For loop