How to read excel by rows fastest?

Help Activities
, ,
5

Hey Maria! I don’t know if I understood very well, but I believe the long time is due to multiple read cells!

You’ve already read the entire table and already have the information for this cells, so instead of the read cell you could use
If CurrentRow.Item(4).toString.Equals(numFile)
Then
Assign CurrentRow.Item(8).toString

6

Dear @Maria99

  1. For verifying “210” is in Excel ColumnD, you can make use of LINQ query. Output will be boolean datatype.

  2. Query to extract all the values from the row.

Refer to the attached workflow.
anyWhere.xaml (8.2 KB)

Regards,
Goutham

7

@GouthamVijay How to set assign is dtRow ?

image

image

File excel as below :
Master.xls (36.5 KB)

My flow as below:
Project.xaml (11.6 KB)

8

Any Idea for solve it?

9

Dear @Maria99

dtRow is of DataTable datatype

10

@GouthamVijay Change variable dtRow to DataTable already.

ฺBut error as below.

image
image1041×380 20.1 KB

Please guide me about it.

11

@Maria99 was the type DataRow?
If not you can set it as DataRow.

12

@Dawodm How to change it?

Project.xaml (11.6 KB)
Master.xls (37 KB)

13

Unfortunately I can not see the activity. There is a problem.
But try to set this type for your variable:
System.Data.DataRow

image
image1014×93 7.38 KB

14

@Dawodm It error.
image

15

And you tried with System.Data.DataTable?

16

@Dawodm error.

image

17

Can you please share your excel file. Because your statement is wrong. You search for the column name but this statment to search for the content of the column. So no column has this input.

18

Please try it as follows.

Sequence23.xaml (6.0 KB)

19

Dear @Maria99 ,

NumFile.ToString is a variable in your assign statement,

‘“+NumFile.ToString+”’

Replace with the above statement.

20

Here you have to set your variable instead of 210

21

@Dawodm If use for each row , it take time more to run.

Because I have data about 100 rows.

22

Then try this statment:
dt.Select(“ID=”+NumFile.ToString).CopyToDataTable

Sequence23.xaml (6.4 KB)

Please let me know if it works for you

1 Like
23

@Dawodm yes, It​ work​ correct.

24

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