In Excel sheet diagonally I have to generate numbers from 1 to100.could you please help on this scenario.
Example: 1st column 1st cell should be 1
2nd column 2 cell should be 2
3rd column 3 cell should be 3
Already have an account? Login
Login to the Pathfinder Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Hi @Naveen Kumar , For this you could use this approach.
Please suggest without vb script. I want to implement it in automation anywhere only.
Hi @Naveen Kumar ,
You can either achieve it using the Click and Drag Excel Actions available in Automation 360, or you can use VBScript to achieve it:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set wb =objExcel.Workbooks.Add
Set ws = wb.Worksheets(1)
For i = 1 To 100
ws.Cells(i,i) = i
Set objExcel = Nothing