How to paste copied text into excel file

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!

HI,

For now, can you check if GetText works correctly using PreviewExtraction as the following?

image

Please change scraping method if necessary.

image

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.

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.

HI,

Can you set Breakpoint at the WriteCell activity as the following, then run as Debug mode?

image

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.

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.

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 :smile:

1 Like

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