excel

  1. B

    Assigning multiple variable in single column

    Hi All, I'm working on some excel validation. The requirement is When the DOB is null then i should populate the corresponding Name in a cell. I have around 100 records. In the loop some (eg:2,4,5) iterations of DOB is null. Now i want to write Name2, Name4,Name5 in a single cell (eg:A1)...
  2. A

    [Blue Prism] Tell me how to assign the value obtained from the two column values in Excel to a variable

    Assumptions What you want to do is as described in the subject line. The result is that the Collection data read from Excel I would like to take the form of assigning to a variable so that the value can be used universally. * Here, the Row of this Collection data is dynamic and there is one or...
  3. H

    Data Extraction From Excel Using OLEDB

    Hi All, I need help on extracting data from Excel file. I cannot use MS Excel VBO - because Sheet has more than 10 duplicate column names(but data inside them is different). So if I try to extract using Excel VBO I get an error stating column name already exists in the data table. So I tried...
  4. D

    Create table in Excel

    Hi, How can i automate a process that put my data in excel inside a table?
  5. J

    Find Next Empty Cell doesn't work

    Hi, I have been having a problem writing data from a collection to a worksheet. I have an woorkbook that needs to be updated constantly and when I use the action of finding the last empty cell it takes a tandom cell in the middle of the worksheet.
  6. B

    Error: Excel Get Worksheet as Collection

    Hey, I'm new at RPA/Blue Prism. I've got a problem with the Action "Get Worksheet as Collection". In the excel sheet are hidden columns. These are not found. Blue Prism returns error message: Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found...
  7. S

    Copy the Comments from Excel and paste in application

    There is a client Application :in application after process of Account in Comment section we need to provide comments , the comments template will be in Excel , there will be around 10 accounts ,selection the comments is based on process of Accounts. for ex comments in Excel: Client ABC...
  8. P

    How to move from last row of column to first row of next column??

    Hi, In first row after iteration completes in column1 how to jump to Particular cell in column 2 for example: A9 to B3
  9. R

    Delete/Insert Row in Excel via Macro

    Hello, I want to delete or insert a row in excel. I wrote macros for both, and I have BP call the macros and pass in arguments. Can anybody tell me why nothing happens when I call these macros? I believe my syntax is correct, and I'm having success passing in arguments from BP to another macro...
  10. P

    Update Column in Excel using OLEDB

    Hi Did any one use Update query to update column with a formula in Excel, Excel was like 160K Rows of data, SO it taking time to update using other ways , Pls help me out if any one did update query , I am trying but getting error , my connection string was correct (as tested using get...
  11. B

    External Table is not in the expected format ...Error while using OLEDB in Blue prism

    Hi Experts, I am using OLEDB in my process and running the process in 3 different bots. and getting the below error in two bots for reading same file. External Table is not in the expected format strange thing is, one bot is throwing the error while reading the sheet1 and another have read...
  12. B

    External Table is not in the expected format ...Error while using OLEDB in Blue prism

    Hi Experts, I am using OLEDB in my process and running the process in 3 different bots. and getting the below error in two bots for reading same file. External Table is not in the expected format strange thing is, one bot is throwing the error while reading the sheet1 and another have read...
  13. R

    Attach to running excel workbook Application Modeler

    Excel 2016, 64bit application. I've created some menu navigation steps in Object Studio, Everything works if I have excel launch as a new application from within the modeler.... however... When trying to attach to an existing workbook within the modeler, no combination of things seems to...
  14. C

    Copy and paste range in excel error

    Hello all! So I'm trying to copy and paste a column of data (Column D in my case). It's about 7k rows long and I need to move it from one worksheet to another worksheet in the same workbook. I can't have the top row (it's a title) so I made a quick data item with the row # (minus 1). I keep...
  15. I

    Everytime the machine is reboot the robots can't access folders

    Hi, guys. I have a big issue, the robots were implemented on a Windows 10 Virtual machine and every time we have to reboot this machine to update, the robots loose all the connection with the folders, won't write or save excels file, and so on. It's like they lost the administrator privileges...
  16. C

    Unable to open Repairable Excel File with Blue Prism

    I am trying to open an Excel file which is corrupted but repairable. If I opened it normally then the attached screenshot shows the message displayed and if you click ok the excel file repairs is there any way to emulate this in Blue Prism. I tried the start process but it doesn't move forward...
  17. C

    How to convert Column A row values as header of Column B

    HI All, PFA I had query while performing one action, I want to convert column A row values as header to Column B in a colection in BLUEPRISM. Kindly plz anyone help us. Thx sample O/p should come as ----- Firstname as column with value pawan
  18. S

    Write collection in excel

    Hi All, Any idea on below error while writing collection Via blueprism ERROR: Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC
  19. D

    Set cell value in Excel .xlsm file

    Hello everyone, I already completed the official documentation (those 200 pages) and also done 2 processes, but now I have a problem writing a value that is stored in a data item into an Excel file. These are the steps followed: 1) Create instance 2) Open workbook 3) Show workbook 4) Worksheet...
  20. D

    Paste data item in Excel (set cell value) not always working

    Hello everyone, I have already done some processes (including all the official tutorials that are in that pdf of 200 pages that I don't remember the name), but today I faced a problem that never happened to me and I couldn't fix it: I need to paste the information that is in a data item into a...
Top