Write serial numbers in one row

Help Studio
1

Can Someone help me how to write serial numbers in one row (1 2 3 4 5 6 and so on…) in my excel sheet. Already I created SR NO. (Column Name). Please, anyone, help me it’s urgent.

Thanks,
Mohd

2

@mohammed_zain,

You will have to use write cell activity which writes value in a row

Please let us know if you stuck

Thanks,
Pankaj

3

It is not writing in excel sheet

Thanks,
Mohd

4

This is my solution, hope to help you
Main.xaml (9.2 KB)

1 Like
5

OK I will check

Thanks,

6

If it helps, please mark as resolved.

7

Thanks it is very helpful but a,b,c alphabets how can remove that.

Thanks,
Mohd

8

Please go to the build datatable activity and delete the words such as abc.

9

Actually i want serial numbers dynamically bot should write based on data one by one if the data is more than 1000 also.

Thanks,
Mohd

10

I didn’t understand what you meant, can you be more specific?
Regards.

11

IF there is more than 1000 row data in excel sheet it should write all the serial numbers from 1,2,3 and so on.

Thanks,
Mohd

12

This is the xaml file I provided, please check.
RegardsMain.xaml (10.6 KB)

13

I am getting serial numbers based on build data, I need serial numbers based on data entering in rows

Thanks,
Mohd

14

@mohammed_zain
in general generating a serial of numbers can be done like this:
grafik

taking this as a base other things can be done e.g.:

  • creating a datatable with x rows, or x columns
  • iterating over the list an write cell information
    …

For aligning out a solution more close to your case a more clear description on given input data and expected output data would help us for further suggetions. Thanks

1 Like
15

Can you please share the sample code

Thanks,
Mohd

16

@mohammed_zain

Lets assume:

  • excel data is readin in into a datatable dtData
  • an additional column “SR NO” will be added to dtData
  • in each SR NO column value the row index is to set

Find some demo xaml here:
AddRowIndexToExistingDataTable.xaml (7.8 KB)

1 Like
17

Thanks i will check tomorrow

Thanks,
Mohd

18

Hi @mohammed_zain
Declare a variable as Int and assign a default value of 1
Use write cell activity and write this variable in write cell activity as CStr(variable)
and after every data entry before looping back to next item. Try incrementing the variable as (variable+1).
For next item it will make the number as 2 and for every iteration it will increment by 1.

Hope this helps!
Thanks,
Aditya

1 Like
19

Sorry! I dint got this can you please send sample attachment.

Thanks,
Mohd

20

Hi @mohammed_zain,

Here is an example of what i said before.
In this example i have taken the DT which contains values and without serial Numbers and writing them with serial Numbers in Sno.xlsx.
If this solves your question then mark it as solution
Cheers!
ExcelSno.zip (23.4 KB)