How to take read range rows count and write cell of 1 to A column

how to take read range rows count and write cell of 1 from A3 cell to read range rows count and how to do this without using excel application scope

Hi @sathish_Kumar6

Could you elaborate more…

1 Like

For example i have one excel file which has like 400 rows count and I want 1 as to write 400 times in another excel from A3 cell it has to write as (1) - 400 times

same i want to write yyyyMMdd as 400 times from c3 cell

Hi @sathish_Kumar6

Please check the below workflow it will give the output as per your requirement.

Regards
Main.xaml (12.7 KB)

Hi @sathish_Kumar6

Input:

Output:

Regards

im getting 1 as for A3 only

please attach code or steps

Hi @sathish_Kumar6

Please check the below work flow and also I have attached the work flow for better understanding.

Main.xaml (13.2 KB)

Regards

1 Like

instead while i tried for each row and it worked thanks

Hi @sathish_Kumar6

You’re Welcome!!

Happy Automation!!

1 Like

thanks

happy automation

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.