I want to give numbering to extrated data for extracted data

[Adithyeshwar_goud]

i want to give numbering to extrated data for extracted data so what can i need to use in order to give numbering to the excel sheet based on the extracted data count

[mkankatala (Mahesh Kankatala)]

Hi @Adithyeshwar_goud

Could you be more specific!! Provide the Input and required output for our better understanding.

[Anil_G (Anil Gorthi)]

@Adithyeshwar_goud

If you need to add a serial number column then use as below

Weite data to excel levaing first column

Then use write cell and write 1 in the first cell A2

Then use one more write cell with A3 as cell and formula as "A2+1"

Then use auto fill range which fills the series

Cheers

[Yogesh1 (Yogesh)]

Create a variable number = 1
Max_number = row.count
For each max_number
number = number+1

[rlgandu (Rajyalakshmi Gandu)]

@Adithyeshwar_goud

Assign activity:
counter = 1 ’ Initialize a counter variable

For Each row In extractedData.Rows
row(“SerialNumber”) = counter
counter = counter + 1
Next

[Adithyeshwar_goud]

bro can you send the sample main file please

[Adithyeshwar_goud]

bro can you send the sample main file please

[pravallikapaluri]

Hi @Adithyeshwar_goud

Hope it helps!!

[pravallikapaluri]

@Adithyeshwar_goud
Yes