Excel Automation--help

Hi can anyone help into this Please
Here i have two columns name and id , Here i want if first index of id is Sweety1 then it continue till ‘Z’ like Sweety1_a, Sweety1_b till Sweety1_z, And after its counter will increment to 2 and the value will be Sweety2_a,Sweety2_b till Sweet2_z and if more entries of names then it continue to Sweety3,Sweety3_a,Sweety4,Sweety4_a…Sweety4_Z.
Please Help. I have to work with large set of data.

1 Like

Hi,Please help,i am trying this but this is not working
CharInc.xaml (9.8 KB)

Please do help.

1 Like

Hi @Anjali_Rani

Please find the attached xaml file for your reference. Try this and let me know whether it meet’s you expectations.

Cell_Hydrate.xaml (12.6 KB)

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

@Anjali_Rani I am trying this also. But it’s same error is anybody have solution of this error.

Thank you, But here i dont know How many times the Name is Present,According to that i have to increment the counter. if Sweety is present 30 times then it should stop on sweety2_C. Please help and it present 3 times then it should be like abc1,abc1_a,abc1_b and stop.According to Name its id should increase.

lets assume following:

a datatable with 2 cols: Name, ID and 3*27 Sweety



(From d In dtData.AsEnumerable
Group d By k=d(0).toString.Trim Into grp=Group
Let segcnt = CInt(Math.Ceiling(grp.Count / 27))
From i In Enumerable.Range(0,segcnt)
Let seg = grp.Skip(i*27).Take(27).toList
From t In seg.Select(Function (r,idx) Tuple.Create(idx,r))
Let token = (k & i + 1 & "_" & chr(96 + t.Item1)).Replace("_" & chr(96),"")
Let ra = New Object(){k, token}
Select dtResult.Rows.Add(ra)).CopyToDataTable


Find starter help here:
GroupBy_1Col_GMCounter_AZSegment.xaml (7.2 KB)


Hi @Anjali_Rani

I have made the changes and attached the updated xaml file for your reference.

Cell_Hydrate.xaml (13.8 KB)

And I’m not cleared about below line. Can you please elaborate it.


Sorry, i mean, If in “Name” column if sweety is Present 3times only then its id should be Sweety1, Sweety1_a, sweety1_b and stop.
And if in Name Sweety is present 30 times then its sd should increase like Sweety1,Sweety1_a,…sweety1_z, sweety2,Sweety2_a, Sweety2_b and stop.

Thank you, But i don’t know in our excel file how many time the Name Sweety will appear, according to that i have to increment its id. Please help.

Hi, Please Check

Cell_Hydrate (1).xaml (14.7 KB)

Hi @Anjali_Rani

Did you try this? Is this meet’s your expectation.


code is doing this dynamicly, also if other names will appear.

Had you test and received a different output?

1 Like

I tried this and the Output is what I posted,in name their is varsa and kishu still the id got incremented

Hi @Anjali_Rani

Okay, If the name is different from sweety in ‘Name’ column then the bot should not write in that row. Correct me if I’m wrong.


Yes,you are right now.

Hi again @Anjali_Rani

Please find the attached xaml file for your reference.

Cell_Hydrate.xaml (16.7 KB)

Output screen shot:

Hope it’s meet your expectation. Thanks.

1 Like

Thanks for this hospitality. :slightly_smiling_face:

Thank you so much.

1 Like

Thank you. This is working.

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