@lakshman
first,Let the robot go to “https://www.kitapyurdu.com/” and ask to user which one of the 3 (book types) options you want to search. After the user selects oneand then the robot should search and show the page. after that I want to save (the author,book…) data in excel (data scarping).
On the off chance of sounding like a stickler I have to say this workflow is far from perfect because the website throws quite some errors while running it repeatedly. Maybe surround everything with a try catch so that your bot exits gracefully.
Regards
PS : you can find the results that I got also in the attached zip file.
ı tried but it didin’t give data in excel, ı chose “bilim” valule in input dialog, it’s run but excel file is empty deneme_2.xls (2 Bytes) 300619_project1.xaml (15.7 KB)
thank you so much
if ı changed filepath file in write csv , it’s run but excel file is empty
when you choose “bilim” value ,can you share me? “bilim” value excel data? ı curious
data content
Here, you are trying to write in Excel file but you are using Write CSV Activity. Instead of this use Write Range Activity and pass that DataTable to write into Excel file.
And also before doing this file use Kill process Activity to close all opened Excel files and in this pass process name as “excel”
Exactly what @lakshman said. I can see that your excel file is open in one of the tabs and xls in write csv is not possible. You can do a ‘Workbook write range’
PS : If you write an xls file in ‘write csv’ it will also work but it will prompt you that whether you want to access the file which isn’t in the correct format through
@lakshman@Raghavendraprasad
thank you for information
ı am so sorry ı begin to learn 2 days ago ı don’t know, how can ı add “write range” in process, ı search but ı didi’t understand
Hi buddy
You were almost done
It ExtractDatatable buddy not Excelworkbookscope…i think we need to change that
Fine
And also Write range that you have used is correct…but the scope of the variable ExtractedDatatable is not to the whole sequence, so that shows error…
Now go to variable panel (at down) and change the variable scope of the variable ExtractedDatatable to thw wholw sequence name by clicking on the drop down in the column scope in variable panel