Excel with multiple sheets

[#1]

Hi,

How to load the data from the multiple sheets of an excelsheet. I have an excel which has 5 sheets all the data is from single table.

Do i need to write a seperate load statement for each sheet and concatenate that all. Is there any way we can do that in a single script.

[Anonymous]

Hi what if the sheet names are different? ie the tab names are as fallowed sam,kumar...........upto 200 sheets with different names is there any way to pull all the sheets regards Harsha

[renjithpl]

Hi,

you can use the below code for your application, but your sheet names should be renamed with either 1, 2, .... 200

with different names i guess this wont work,

there is a macro to rename the excel sheets, you can try in google...

for i=1 to 5

tab1:

LOAD column1,

column2,

column4

FROM

TEST1.xls

(biff, embedded labels, table is @$(i));

[Anonymous]

Hi Renijith use this below script for loading 300 sheets hope this helps.

for  i=1 to 300

load * from sheet$(i).xlsx;

next i