Read and write Notepad/Excel

Hi Fnds,

Have anybody tried R/W activity for Notepad/Excel by using Hotkeys…

plz comment!
Thanks in advance!

1 Like

Hi @venkateshtangudu

For reading, you can use the following procedure

  1. Open Notepad file
  2. Make sure the notepad window is active
  3. hot keys Ctrl + A - to select all the text in the notepad file
  4. hot keys Ctrl + C - to copy the selected text
    5… Use the following activity to get the selected text into your workflow
  1. The result from your previous activity is the data from notepad file you can use it in your workflow.

For writing, you can use the following procedure.

  1. Use reading steps to get the data into a string and save it in one variable
  2. hot keys Ctrl + A - to select all the text in the notepad file
  3. hot keys Delete - to delete all the text from the notepad file
  4. You can construct your new string - data from step 1 and any new info (oldData + " New Data")
  5. Use the following activity to set the your data from step 4 to clipboard
  1. hot keys Ctrl + C - to copy the text that set in the previous activity into the notepad file.

  2. hot keys Ctrl + S - to save the file.

Regards,
Karthik Byggari

2 Likes

Hi Karkhik,

can u plz share me the template of above scenario by using hot keys

Hi Karthik,

In notepad, how we can select particular line…to place the particular text in clipboard…
can share the snapshot in the state machine…