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 ![]()
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…
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 ![]()
Whether it is a .txt file or excel file???..
Can you send me that excel file?..
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
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 ![]()
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
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 ![]()