Check string exist and write into another position on same excel file

Learn Academy Feedback
1

Hi everyone.

I have scrapted data from website. I want to check some string exist in ExtractDataTable and then write them into different columns in same excel file.

In the Write Range activity, how to do this ?

Pls kindly check picture as below and support me.

Thanks in advance.

1
11920Ă—1080 221 KB

2

I have used Add Data Row activity as below picture… but it have error when I run.

Pls check

2
21920Ă—1080 230 KB
3
31920Ă—1080 237 KB

3

@trunghai,

Here, You have to use Write Cell activity to write into cell.

4

Hi @lakshman

I faced with one new error.

4
41920Ă—1080 244 KB

5

@trunghai,

In write cell, you have to pass string the one you want to write it. But you are passing Data Table here. SO, it is giving error.

6

Hi @lakshman

Sorry, Pls check my XAML file and edit …

Thanks you so much!File.xaml (14.4 KB)

7

Hi @lakshman

I have edited

2
21920Ă—1080 239 KB
1
11920Ă—1080 177 KB
. the result written into excel file but have something wrong.

8

Need to add activity “Build data table” with name “dtout” before add row , and configure its columns like row …

9

hi @habouzied

Sorry, could you pls edit in my XAML file for your suggest ?

Thanks you!File.xaml (14.4 KB)

10

sorry because , language you used is not english,i will try to do same idea …on other XAML…
but mail idea is :
you need to create table by “Build data table” which you will use in ADD ROW
this table should have same structure of row …then you can use in write range…

11

Hi @habouzied

Thanks you.

But I want to use Write Cell activity in this case.

I want to check in ExtractDataTable which scrapted from Website… if the string exist in this DataTable, it will write that row into A column and other will write into B column on the same excel file.

12

Hi @lakshman & @habouzied

Sorry, attached file is my XAML file… I have used Write Activity but the result which written into excel file not correct.

Pls kindly check.What is wrong in my process ?

Thanks in advance.
File.xaml (14.3 KB)

1
11920Ă—1080 182 KB

13

Check this please , it may helpSequence1.xaml (13.8 KB)

1 Like
14

Hi @habouzied

Thanks you so much… I will do with my project and inform to you result later.

15

Hi @habouzied

Thanks you so much. The result is fine.

And now, I have a excel file with two column.

I want to check all of row in Column A to find the word “apple” and after write result into the Col B.

How to do that ?

Pls kindly suggest me this sample.

Thanks you!File Filter.xlsx (8.1 KB)

16

I have done this case by myself…^^

2 Likes
17

sorry , i just see your comment :slight_smile:

1 Like
18

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