How can I Split excel row into array?

Help
,
1

I want to read an excel row and split it into an string array so I can later copy each column and use it, but i cant get it working, can someone help me?

2

You do not need this. Columns can be directly addressed from the row element using the headers as row(“Column Header”).tostring

3

@c.ciprian
It doesnt works for me it says: Strict On doesn’t let implicit conversion from string to Integer. (SalidaRow is the Read row Output

Screenshot_1
Screenshot_11157Ă—363 16.9 KB

4

Yes. you need to do an explicit conversion there. Try cint(salidarow(“whatever”).tostring)

5

@c.ciprian same error with that.

6

@fpardo

Are you using a for each row activity to loop through your datatable? You have yo loop through a datatable and get the values using the above command

7

@Lahiru.Fernando I dont want to loop on any datatable, i want to read a specific row (A2) on an excel and put both column values into an array. Im using Read Row activity.

8

@Lahiru.Fernando
This is the excel im using.
word.xlsx (8.8 KB)

9

Try this

Dt_excel is the datatable

Dt_excel(1)(0) to acess row 1 and column 0 which is column A

10

@Lahiru.Fernando

Screenshot_2
Screenshot_21144Ă—485 18.3 KB

Error: Option Strict On don’t lets link on execution time.

If I put only SalidaRow(0) it shows me the first row value but enters in a infinite loop, don’t know why.
Screenshot_3

11

Ok I know why theres a infinite loop, its my bad haha. thanks for the help :smiley:

1 Like
12

If there is a solution here for your issue please make sure you mark it as the solution so it could help others…

1 Like
13

Okay, im still new in the forum, I don’t even knew it :smiley:

1 Like
14

no worries… we are all here to help you guys while learning and improving ourselves… :slight_smile:

2 Likes
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.