excel

Hi everyone, I am creating a bot in which one of the functionality is to copy data from multiple spreadsheets with fields like name, id, amount, etc. to a single spreadsheet. Data is getting copied from multiple sheets to a single sheet, although everything is copying fine except Amount...

Hello, I have a collection which contains row-id, I am looping through the collection and for these row ids I have take that particular row from given workbook and put that in a new workbook. For that I was trying to use copy and paste worksheet range stage but in cell reference I tried passing...

Hey Blue Prism gurus, I need to be able to read the Last Saved By metadata property from an Excel file using Blue Prism. Ideally, this would use VB.NET so that I could add the function to the existing Excel VBO, but C# would be acceptable. Any chance someone can provide me with such a...

I have a Code stage running the following: GetInstance(handle).Activecell.Validation.Add (Type:=xlValidateList, AlertStyle:=xlValidAlertStop,Formula1:=("Yes,No")) This is producing the following error: Page: Input Validation List Stage: Input Validation List Type: Error Action: Validate...

Hello all, I have an excel template that contains a macro that runs automatically when the file is opened. Problem: There is a form that appears in excel asking me to login to oracle in order to load the data as well as other options. (See screenshot 1) What I want/ what's Excepted: I want...

Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...

Our company has developed hundreds of automations, many of which interact with Excel. This required developing our own Excel VBOs for actions not included in the built-in Blue Prism Excel VBO. A major problem is that actions cannot be called from any business object other than the one that...

Hello, I'm trying to use a mixture of both the default MS Excel VBO actions, as well as some I made myself which are placed in an Extension object. Just now I am: • Creating an Excel Instance in the MS Excel VBO • Creating a new Workbook (normally named Book1) • Writing a collection to the...

"Internal : Could not execute code stage because exception thrown by code stage: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)" We are getting this error while we are using Excel VBO create instance in debug mode.

5 Home Microsoft Excel Select the language Select the language (English) English (Deutsch) German...

This is the text that I need to convert. I tried to put it in a Data Item and then using Split Text to split it. The result is saved in a Collection but only in one column. Is there any other way to throw this text in a collection without losing its structure and to create 6 columns and 4 rows...

Hello Everyone, I am trying to read date from a particular cell(Date format) in Excel(using OLEDB). Whenever the date is read, in the output the date changes to its previous day. Eg:- If the date in the cell is 17/02/2021 after reading in Blue Prism the output shows 16/02/2021. If...

This is the text that I need to convert. I tried to put it in a Data Item and then using Split Text to split it. The result is saved in a Collection. Is there any way to throw this text in a collection without losing its structure?

I am trying to implement a "Find and Replace" code stage within my Blue Prism Excel Object. The code stage is producing an error with: "Internal : Could not execute code stage: Parameter count mismatch." Any help would be much appreciated The Inputs are as follows: Handle Workbook Worksheet...

Hi All I am doing the automation activity for a excel web add-in , where when I launch a template - it consist of browser portion enabled and I have to automate that browser part and excel side of it as well. So I would like to know how to perform attach operation for the same. Can someone...

Hi everyone, I'm trying to change Command Text box in Connection Properties (see picture). It is an existing data connection in Excel and I need to change the query. I already found this thread discussing altering Connection String but I was not able to alter the code for my purposes. What...

Hi, I have a problem when trying to close Excel. When I use MS Excel VBO::Close Instance, the Excel would close, but process in Task Manager is still seen running. The same goes when using MS Excel VBO::Close All Instances. Process: - Export table from 3rd party program. Program opens MS Excel...

Hi! How can I get values from row starting from a particular cell from Excel file? Example, I need to extract all values from 2nd row, starting from B2 cell? P.s. it's better to extract non-empty cells. Thanks in advance.

Hi, I have a Code stage that creates Pivot Table in Excel. The first part of the code is general and the second part is there to describe how the Pivot Table should look like. I would like to be able to dynamically change the second part whenever I want to change the Pivot Table layout. How to...

Hi, We have an issue with Blue Prism (BP) saving Excel files to a directory that encrypts the file and locks the directory to other writes while the encrypted save completes. If two BP processes attempt to save files in the same directory at the same time, one process will receive a Microsoft...