Not able to write data scrapped value in Excel file

Hello,

I am not able to write data scrapped value in Excel file.The value was scrapped from website.

Please share some data(Screenshot)…

image

First Used Build Data Table Activity After
Use Add Data Row Activity before write Range

Can you please explain in depth about how to use Build Data Table activity as I am not aware of it.

Hy @VIDIT_ZALA,

Try a small adjustment to your workflow, instead of the ‘Write Range’, try using the ‘Excel Application Scope’ Activity and then inside it the write range activity.

If it workds please like my post and mark my answer as solution
Any questions please let me know

Regards

Please share your Flow…

Thanks for the suggestion but I have already tried that but it is still not working.

@VIDIT_ZALA, ok!

Prior to printing the data into excel, run a quick check to see if some data is extracted into the data table. Print the Row count, for example

What is the error message you are getting?

Regards

Okay.

1.Read data from excel file.
2.Search that data which was readed from excel file.
3.Get the searched data and store back in excel file.

1 Build Data table(Create Column which you want) Create Variable of that
2 Read your Excel
3.Search your data
4 Add Data row activity
5 Write range activity

Hy @VIDIT_ZALA,

Are you getting an error message or nothing gets printed to your excel?

Nothing gets printed in excel file.

@VIDIT_ZALA, is there some data on the ‘ExtractedDataTable’ you scrapped?

Use a ExtractedDataTable.Rows.Count and use a ‘for each row’ activity

Hi @Shubham_Akole

Can you please provide me some idea about how the scrapped value is stored in Build Data Table . Sorry for the trouble but I am not able to do the task as I am a beginner in this.

From where you want to extract Data…

From the website.

Hi @Shubham_Akole
To be more clear I have provided you the steps below.
Task need to perform:
1.Read data from excel file.
2.Open particular website and perform login.
3.Search the data which was readed from excel file.
4.Get the data from website and store it back in the excel file.(The data which we want to get can be single value, multiple value or no value.)