How to open a notepad?

Help StudioX
1

Dear fellows

In Studio x , Is there an activity that can open a notepad ?
“Use Application/Broswer” is not what i’m looking for.

Here is my problem.

  1. copy some datas in an excel sheet. ( Ctrl + C )
  2. paste to a notepad ( Using “Write Text File” activity )

For the next step, I need to copy datas which is saved to 2 step and paste an excel sheet.
To do this, I need to open the notepad but can’t find the way.

Can you advise ?

How to execute notepad in Studio x?
2

Hi @PARK_Bin

=> Read the Excel using Read Range Workbook and store the data in DataTable say dt
=> Use the below syntax in Set Variable Value activity:

OutputText = String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(row) String.Join(", ", row.ItemArray)))

=> Use Write Text File to write the OutputText variable to text file.

In this case no need of using Use Application/Browser activity

Regards

3

Thank you for this explanation.
but , If you don’t mind, May I ask explaning more simple ?

4

Hi @PARK_Bin

Check the below image for better understnading

image
image880×604 26.3 KB

2nd point is a linq query which converts the datatable into a text format.

If possible share an excel file with dummy data I will help you with workflow.

Regards

5

Many thank !
I’ll try.

1 Like
6

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