Hi @pauloengenharia5 ,
Could you provide/Show us the Expression used in the Assign Activity ?
I’m trying to get a value from excel and record it in outClipboard and then play it in SAP
at the output of my read range I have a variable called dtExcel
in my Assig I have: out_ToClipboard = String.Join(Environment.NewLine,(From r In in_Excel Select r.item(“B:B”))))
Maybe you could try shifting to the below approach :
out_ToClipboard = String.Join(Environment.NewLine,in_Excel.AsEnumerable.Select(Function(x)x("B:B").ToString).ToArray)
Here, the assumptions are :
in_Excel → Datatable type variable, Output from Read Range Activity
"B:B" → Column Name in the Datatable (Not Column Range in Excel)
Let us know if you are still receiving issues and would also like you to Debug and Check in Immediate Panel the values of the datatable, so we can be sure as to what we are doing is right.
hello friend thanks for the help i keep getting the same error i am sharing my workflow if you can help me i appreciate it
Test.xaml (7.9 KB)
Since we do not know the Data Content. We can check by correcting the workflow with the below Changes :
You were using a Workbook Read Range inside the Excel Application Scope Activity, which is not the right way. You would need to use the Excel package’s Read Range Activity.
In the Range Property of Read Range Activity, keep it blank.
Update the Expression in the Assign Activity to take the second column data from the Datatable like below :
String.Join(Environment.NewLine,in_Excel.AsEnumerable.Select(Function(x)x(1).ToString).ToArray)
Instead of "B:B", we are using 1 as column index to get the data from the Second Column in Excel which I assume is the required column.
Check this updated workflow and let us know if it works :
Test.xaml (9.9 KB)
If it doesn’t work, let us know what was the error received.
Issue - Job stopped with an unexpected exit code 0xE0434352
it gave this error “Issue - Job stopped with an unexpected exit code 0xE0434352”
This shouldn’t be happening, Could you check by restarting Studio ?
I restarted but it didn’t work, when I put “H:H” in the READ RANGE activity it passes this step, but it gives another error
in my ASSIGN => out_ToClipboard = String.Join(Environment.NewLine,in_Excel.AsEnumerable.Select(Function(x)x(1).ToString).ToArray)
Make sure in_Excel actually has a value. Look at it in debug mode with a breakpoint on the Assign.
in_Excel should be in the output of Read Range.
Are you trying to pass value from another Workflow to your “in_Excel”? Bc I see you have in_Excel created in Arguments.