Hi Friends,
I want to read all the data in the table from 1 to 6 how can I achieve it. Many thanks in advance.
cheers 
Happy learning
5 Likes
Use read range activity to read all data but don’t specify the range…
range should be empty…
Provide the proper sheet name and proper file…
1 Like
Hi @Manish540
I know that @Manish540 but if i dont specify the value in the range.It will read all the data The data that i need are from 31 to 41 only .
By the way thank you for your swift reply
cheers
Happy learning
3 Likes
Whether it is a .txt file or excel file???..
1 Like
Can you send me that excel file?..
1 Like
Hi @pattyricarte,
If you want to read only 30th row to 43rd row then, during using Read Range activity you should use “30:43” in Range section and Add Headers option must be unchecked.
I’m attaching screenshot for your convenience.
Hope you may find solution.
Thanks & Regards,
Apurba
2 Likes
Many thanks for your reply, but I doesnt work.
Result
What I did was to put the column on it, and it works.
cheers
Happy learning
5 Likes
Hi @pattyricarte,
I have tested the code and it works fine. I’m attaching the workflow.
Forum(pattyricarte).zip (8.8 KB)
Please have a look.
As your attached screenshot, you mentioned the Range as E30:AJ4*. But my dear I think we have somehow hard coded here.
But if it’s working fine then, just chill and enjoy. 
Thanks & Regards,
Apurba
2 Likes
yes i just hardcoded it for testing purposes because theres alot of logic that i need to put up in the codes .I saw your codes and it looks great.How ever it wont work with this kind of excel format.
By the way many thanks for your effort.I just come up with another strategy.Thanks thanks for the support @apurba2samanta @Manish540
cheers
Happy learning
3 Likes
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil