How to get all columns from excel without knowing column names

Help
, , ,
1

Hi All,

I have to fetch the all the column from excel sheet without knowing the coulmn name.

For ex: i have excel sheet where it has 5 column and now i have written workflow only to fetch 5 column but in future i may add 5 or 10 more extra column to that excel sheet and i don’t want to change any thing in my workflow.

Please help me on this how to write this logic .

1 Like
2

Hi,

If you are using read range then do not mention range in that activity, so it will read all the data from the excel sheet.

Include “Add Header” property for the Read Range activity, so you will get the first row as your datatable header.

1 Like
3

actually my example is like. i need to get the min and max value from each column …

Please find the attached excel files.
step1: First i have to read the excel file
step2: i need to add those data to queues
step3: get the queues item and i have to do the min and max value operation.

But here above steps i can do only for what the data is there in excel sheet. as of now i have 5 column i have written workflow for that. but in future i will add 10 more extra column to excel sheet. and i should not change any code in myworkflow.

For this i have to use split function , i dont no how to get those column names.
Test.xlsx (8.1 KB)

1 Like
4

Hi,

As per my understanding I have done something with the given excel sheet.
Check the attached xaml for min max value of each column.

MinMax.xaml (8.3 KB)

5

Thank you so much @sarathi125 really it helped me so much thank you so much.

I will try to do with the same in queues. if i have doubts i will post it please help me on this.

6

Cheers

7

Hi Sarathi,

Now i have to add all these data to queues , Now in item information , what i have to write argument , so that it will add all the column data’s to queues. there should be only one argument . suppose in future i should not add any arguments in itemj information queues , if i add extra columns in excel.

Please find the attached scrrenshot

Capture
Capture1261×702 31.7 KB
Capture1
Capture11462×701 40.8 KB

8

Hey,

If you want to add all these into a single queue item then you can use List Of Integer/Double/string datatype in the collection.

Then you have to add the queue item out of the for loop.

9

Can you Please give some logic … i’m not getting.if its possible you can write code as you done in previous one. Please if its possible.

10

Hey, check this xaml. Change the Queue name to yours before run the xaml

MinMax.xaml (11.8 KB)

11

Thank you @sarathi125 … i will check it now. thanks buddy thank you much… it helped me.

12

Hi @sarathi125 when i’m running the code i’m

Capture3
Capture3965×441 26.9 KB
getting below error .

Please help me

13

Are you trying to use platform.uipath.com or any own orchestrator

14

i’m using platform.uipath.com inside here i’m using local machine my own orchestrator

15

Oh okay, Just now I ran this and added an queue item with the below xaml, please check.

MinMax.xaml (11.9 KB)

16

Hi @Kiran_Bg,

Row(0).toString → Collumn 1

Row(1).toString → Collumn 3

Row(2).toString → Collumn 4

…

always start counting columns from 0

17

Hi @sarathi125 thank you so much for your continuous responses.
i’m getting missing or invalid property. i’m using 2018.4 version. can you please send me screenshot what you added in queue item. so that i will make changes in my code.

Capture4
Capture4691×484 8.77 KB

18

Capture
Capture787×493 42.6 KB

19

in my properties don’t have ItemInformationCollection. Could you please tell me inside item information what is the datatype and value i have to give . so that i will check

Capture5
Capture5422×594 13.9 KB

20

Please update your UiPath Studio to the latest version. I am not able to check with the previous version as mine is the latest one.