I know its a basic question, i searched for but im not clear with the concept
Im a newbie to Uipath automation. Where we use index in excel automation. Whats the purpose of using index. In Projects, usually we use to get the last row/ column count know.
We will use index to read row values from Excel file. We can read particular row value by specifying either Column Name or Column Index. If column positions are fixed then we will use Index.
Eg. row(“ColumnName”) or row(0)
Note: Here, 0 is index and it refers to first column in Excel file.