I want to copy “Secret Key” from a website and paste it into the current row of the excel sheet. It can be copied and pasted into message box however it does not work for the excel.
The left side is the flow I have done
The right side is the excel sheet. I want to put the Secret Key into the B column
If there is a solution it would be much appreciated thank you!
Yoichi
(Yoichi)
October 17, 2023, 2:08am
2
HI,
For now, can you check if GetText works correctly using PreviewExtraction as the following?
Please change scraping method if necessary.
Regards,
Hello thanks for the advice however it is extracting the text correctly yet I am still unable to write it into my excel file.
Yoichi
(Yoichi)
October 17, 2023, 6:07am
4
Hi,
Can you check if file path of excel is correct?
Or can you share your workflow as file, if possible?
Regards,
I can share my workflow however I am restricted since I’m a new user.
Yoichi
(Yoichi)
October 17, 2023, 6:21am
6
HI,
Can you set Breakpoint at the WriteCell activity as the following, then run as Debug mode?
Workflow will stop there, then press F11 (step into) and check the following.
・Whether data is written in the sheet or not.
・Check content of variable and Activities argument is same as what you expect at Locals panel
Regards,
My problem has been resolved thank you so much for your help!!
1 Like
Sorry to bother again. Instead of cell B2, I need it to be whatever is the current row. Example, it is on row 5, i need it to write on B5 however now it keeps writing on B2. Thanks again.
Yoichi
(Yoichi)
October 17, 2023, 1:59pm
9
Hi,
Which activity as loop do you use? if ForEachRow, for example, the following will work.
Regards,
Sorry for the late reply. I have tried doing what you have done however am encountering an error.
Yoichi
(Yoichi)
October 19, 2023, 1:40am
11
Hi,
Which data type set for idx variable? It should be Int32. And it should be set at Index property of ForEachRow activity. Can you check these?
Regards,
It is working now, thanks so much for your help
1 Like
system
(system)
Closed
October 22, 2023, 2:17am
13
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.