Recent content by CamiCat

Thanks a lot. Can I send you a message with the csv I'm trying to read? I'm having problems in reading the values of the rows in the correct columns. Many Thanks, Camilla.

Thanks @sahil_raina_91. I get the error. I need t read the file at this path Can you please help me? Thanks Camilla

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, CAmilla.

Hello friends, @sivagelli, I need to import a csv file with many rows in a Table situated in BluePrism Database. how is it possible to do that? Thank you, Camilla.

Thank you so much @Sachin_Kharmale . I'll try and let you know as soon as possible. Cami

Hello friends how to send Ctrl +h command in an Excel file open? I tried with Send Hotkey "^H" on Excel Application but doesn't work. Can you please help me? CAmilla.

Hello friends, can anyone tell me how is it possible to extract from BluePrism the Start and End Execution Time of a Process? Thank you so much, cami :)

Thank you so much for your precious help @Jiri.Hurda . Camilla.

Hello friends, 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. Thanks, Camilla.

Thank you so much. Can you please provide me screenshots of the activities? Thank you, Camilla

Thank you so much @DTforrpa. I'll try and let you know as soon as possible. Cami

Hello All, 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...

Hi all, 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.