How can i create an excel file from data scraping?

How can i create a excel file from data scraping

1 Like

@Soudios

Once you used Data Scraping, you have an OutPut as a DataTable, so after doing so, you add Excel Application Scope, inside you add Write Range and you give it your DataTable…

1 Like

How can i chose the name i want for my excel file plz ?

1 Like

@Soudios

Like this :point_down:

image

2 Likes

not the sheet, the excel file

1 Like

@Soudios

Ah, sorry! You can change it on the Excel Scope…, you can even make it dynamic, using a variable or argument… For example : “C:\Users\” +varName+ “.xslx”

1 Like

oh yes thank you, but can i add the varname + date of today

1 Like

@Soudios

Yes, you can do what ever you want ! Give it a try and get back to me…

1 Like

my data scraping doesnt stop, where can i change the settings ?

1 Like

@Soudios

There’s two ways to do so :point_down:

After used DataScraping, you can click on it and go to Properties, change the number of results you want to get…

Or, while using DataScraping, it will ask you the number of results that you want to get…

image

2 Likes

What i want is, when all the pages are done, the data scraping finish, is it possible ?

1 Like

@Soudios

It stops automaticaly, when there no more results to get, or it reached it’s max number or results asked to get…

1 Like

for me it doesnt stop, i think its because it doesnt clik on the good button, how can i use the anchor plz ?

i need to click on this button :

But i have also this button on the same page

1 Like

@Soudios

Share the Selector, of that Arrow button…

1 Like

image

2 Likes

@Soudios

I think the problem comes from the title, do a quick check change page and check the selector, so that you can see what changes?

1 Like

image

1 Like

@Soudios

Give me more details please :slight_smile:

i understood, the problem is the number of resut, if the pages is less than 100 it will continue until the 100

1 Like

but it will not stop automaticaly, so how i can resolve this plz ?

1 Like