How to enter scraped data based out on filters in different sheets?

studio

#1

Hi,
i have scrapped data for a wheather forecasting website for different different cities. Now i want to paste that data in respective sheets in a excel. I have already get the sheets name through for each activity.
how can i perform this, please help?


#2

You can use write range and specify the sheet name. If sheet doesn’t exist, it will create a new one.


#3

Hi,
Did you complete this process?


#4

You can loop through the data you scrapped and use the write range.
Use the dynamic sheet names (eg: use city name as sheet name so that it helps to write the data)’
Hope this helps.

Thanks,
Meg


#5

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