Can you please help me

[Mohita_Sharma]

I want to create four tables PG_ SUBMITTED_OFFERS, PG_EXPIRED_OFFERS,PG_REFUNDED_OFFERS, PG_UPGRADED_OFFERS for each sheet in the attached excel.

[piyushagarwal.0108]

@Mohita_Sharma

want to create four tables PG_ SUBMITTED_OFF

Hey, just use the Write range activity for this task

1. File Name should be same
2. Sheet Name should be different as per your requirements
3. You Need 4 tables so 4 write range can do your work or you can simple create an array of your list names and loop over them, if data table columns are same

[1996 (Neelima G)]

Hi @Mohita_Sharma,

Refer this below link :

Create Table Activities

Hi there, I was about to create a table in an excel sheet from time to time. But I can’t directly indicate the range of the table to be formed. This is due to the table range might be change from time to time, that’s why I can’t specify it with a specific range. So how am I going to fill in the range column? [Capture2]

Activities - Create Table

Create data table for every sheet

Hello, I have an excel with multiple number of sheets. I want to read the excel and store the data of every sheet into different datatable. The name of datatable should be in sequence. I want this to be done in for each loop. I am using for each loop for every sheet but when i use read range to read I am not able to create datatable with the sheetname. For example : I have Excel.xlsx with 3 sheets namely 2014,performance,result. I want three datatable with names dt1,dt2,dt3.

Thanks,
Neelima.