explain about excel table for name and marks
Hi
Kindly elaborate your query pls
Cheers @riaz
@riaz
Welcome to UiPath Community:
Before posting your query please follow the below tips. So that we can answer your query much better.
Instruction to post your query:
-
Explain your process step of your query.
-
Which activity you are using.
-
what is the error getting on your machine.
-
If there is possible to upload your screen shot. It will better to understand the developer.
We are always ready to help you on this.
Happy Learning…
Regards,
Srenivasan Kannan
I hope you are asking the question about?
How to store excel data as data table and how to get the data column wise from row . am i right ?
- Use Excel application scope - to access excel application
2.Use Read Range - to store the data in data table variable - Use For each row - then assign data table variable into For Each row
- use Get row item - to get the column wise data which ever you want.
Please note that while using Get row item. Mention the column index or column name on property pane.
Tips:
What is column Name?
ColumnName - The name of the column whose value is to be retrieved from the DataRow. If this property is set, then the ColumnIndex property is ignored.
what is column index?
ColumnIndex - The index of the column whose value is to be retrieved from the DataRow.
Happy learning…
Regards,
Srenivasan Kannan