Plotting Image using data from excel sheet!

Help
1

Hi All,

I am trying to plot image in MS Paint. I am proving x & y coordinates and RGB information from an excel sheet. Below is the screenshot for reference.
image
I need to give condition that if Red<50 And Green<50 And Blue<50 then it should plot in the plot in the given XY coordinate.
I am taking Robot-Draw Skecth- StandAlone Workflow solution as reference. Kindly suggest the method to do it using excel sheet.

Please suggest how the worlflow can be corrected.
out.xlsx (13.2 KB) Pixel.xlsx (19.6 KB)
Import.xaml (22.4 KB)

2

@Anamika15 If that condition is to be achieved first, then i guess you can filter the datatable once you have read the Excel file and then pass the filtered Datatable to plot the X & Y points

3

Import.xaml (22.4 KB)
Pixel.xlsx (19.6 KB) out.xlsx (13.2 KB)

Please check if you could help with the correction in this workflow.

4

@Anamika15 Can you tell me What is the missing activity ? Some Activities wont be visible in my workflow cause it wont be installed :sweat_smile: , Can you show me your import workflow as a screenshot in here?Capture

5

Below is the missing activity:

image
image516×510 13.7 KB

6

@Anamika15 That’s the main part, I have never used Multiple Assign :sweat_smile: . But Normal assign Assigns from Right to left, but in your case i feel you’re trying to assign left to right

7

@Anamika15 Also What package have you installed to Get the Multiple Assign Activity?

8
  1. Assign and multiple assign work similarly. It’s just multiple assign is little more convenient to use when you have to assign multiple values.
  2. I did not installed any package to get multiple assign option. I m using 2019.7 community version. Its already there in my activity section.
9

@Anamika15 Is your problem solved now :sweat_smile:

10

Nopes

11

@Anamika15 Did you interchange row(“X”) and C in Multiple Assign?

12

I am not able to understand what difference this will make in workflow?

13

@Anamika15 Do you want to Assign the value of C to row(“X”) or you want to assign the value of row(“X”) to C? :sweat_smile:

14

I want to assign the value of row(“X”) to C.

15

@Anamika15 Then you need to Interchange it

16

that helped… thanks :slight_smile:

1 Like
17

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