How to use read range for the specific value

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 :smiley:

Happy learning :smiley:

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 :smiley:

cheers :smiley:

Happy learning :smiley:

3 Likes

Whether it is a .txt file or excel file???..

1 Like

It’s an excel file @Manish540

I want to read all of this.

image

cheers :smiley:

Happy learning :smiley:

3 Likes

Can you send me that excel file?..

1 Like

Hi @Manish540

The only data that I want to read are from A30 to A43

cheers :smiley:

Happy learning :smiley:

2 Likes

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

1 Like

Hi @apurba2samanta

Many thanks for your reply, but I doesnt work.
image

Result

What I did was to put the column on it, and it works.

image

cheers :smiley:

Happy learning :smiley:

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. :slightly_smiling_face:

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.

image

By the way many thanks for your effort.I just come up with another strategy.Thanks thanks for the support @apurba2samanta @Manish540

cheers :smiley:

Happy learning :smiley:

3 Likes

Hi @pattyricarte,

Always most welcome.:slightly_smiling_face:

Thanks & Regards,
Apurba

2 Likes