Read sheets from excel

Using looping concept read all sheets from excel. This is follow chart for easily understanding

To write scripts we have to initialize the global variables:

To create variables go to Tools->variables->global

Varaible1:

$G_SHEET_NO: Set data type-varchar, length- 11, value-1

Initialize the variable for looping

Varaible2:

$G_LIST_SHEET: Set data type-varchar, length- 11, value-1

Get the sheet name

write scripts using global variables:

Script-1:

$G_SHEET_NO =1;

Sql(‘New_Datastore’,’delete multiple_excel_sheets’)

Script-2:

$G_LIST_SHEET =’sheet||$G_SHEET_NO;

Print(‘Loading data from:’||$G_LIST_SHEET);

Script-3:

$G_SHEET_NO =$G_SHEET_NO +1;

write condition for while loop:

$G_SHEET_NO <=10;

Here , we will check the count of the file names is been correct or not

Just like let’s say we have totally 10 files to be loaded.

Then 1<=10 next

After increment 2<=10 like this loop will be iterated upto the condition is been dissatisfied.

After 11<=10 it goes to false path linked object

Files Path:

Source1  

Local: F:\EXCELFILE

Excel name:SHEET_LIST.xls

Work sheet: $G_LIST_SHEET

Codepage:utf-8