Explain about excel table

explain about excel table for name and marks

@SrenivasanKanna

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:

  1. Explain your process step of your query.

  2. Which activity you are using.

  3. what is the error getting on your machine.

  4. 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

@riaz

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 ?

  1. Use Excel application scope - to access excel application
    2.Use Read Range - to store the data in data table variable
  2. Use For each row - then assign data table variable into For Each row
  3. 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