Write serial numbers in one row

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

@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

It is not writing in excel sheet

Thanks,
Mohd

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

1 Like

OK I will check

Thanks,

If it helps, please mark as resolved.

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

Thanks,
Mohd

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

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

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

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

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

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

Thanks,
Mohd

@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

Can you please share the sample code

Thanks,
Mohd

@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)

Thanks i will check tomorrow

Thanks,
Mohd

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

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

Thanks,
Mohd

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)