Thank you so much @sahil_raina_91 .
The file is a csv and not an Excel.
I'm getting this error when using this action:
'Get Worksheet as Collection' Process: 'Test' Subsheet: 'Get Collection From Csv' ERROR: Internal : Could not execute code stage because exception thrown by code stage: Illegal...
Thank you so much @sahil_raina_91.
I've tried the SQL server data - Set Connection and it works.
Now I ask you another question:
I need to Read an Excel File , Read the Collection of rows associated to it and insert the rows (without duplicates) in a Datatable inside the Database.
How can I do...
Hi, (@sahil_raina_91, @Pete_L )
I want to ask you kindly which are the steps necessary to connect BluePrism to a Table in SqlServerExpress and execute a query on it.
What are the steps involved?
CAn you please provide me an example of workflow that does this?
Thank you so much,
How to get the last date of a month with out using any code stage?
I would like to get that only by passing as parameters the year and month, not the day.
Any ideas and suggestions appreciated.
I am trying to pass the value in the cell using SET CELL Value function however it is throwing error ""HRESULT: 0x800A03EC""
The value is ""=+VLOOKUP(B3,'C:\*******\[ConsolidatedReport.xlsx]Sheet1'!$A$1:$N$1600,1,FALSE)".
I have valdated it before running. However i have an...
I would like to clarify is it possible to perform the Excel function "VLOOKUP" using Blue Prism? If so/not what is the approach to automate the VLOOKUP across 2 Excel data files?
Many thanks in advance.