excel

Hi, I wanted to see if you all had any insight to help me with this excel automation that I'm working on. Essentially I'm trying to open two workbooks and run some macros and then save the workbooks. There are three aspects of the automation that I have questions on and I would appreciate any...

I am reading a set of column headings from Excel. I am then using the read value to make a decision. My issue is that one of the values in the Excel is "Town", when Blueprism reads the value it reads it as "Town " . I have checked the excel and the value is "Town". Why would this happen?

Hi I need to save data as xlsx file downloaded from SAP. The SAP window has an excel button that shows an excel preview mode with multiple sheets and can be saved as it shows. I want to save it from that preview window because I can save it with the sheets. The problem is I cannot use Excel...

We are trying to automate some custom Excel Add-Ins (e.g. Smartview, Vision) using SendKeys to navigate the tabs using Excel keytips. I have seen some threads around automating Smart View but as we are doing this with several other Add-Ins we would like to explore this solution as it is...

I need help to merge two collections with a different number of rows. I have one collection (the target collection) which contains all rows that I need to write this collection in a excel worksheet. The last column contains no data. These data I want to get from the other collection...

Hi Could anyone advise me on how I'd move a block of cells elsewhere on my spreadsheet? For example I would like to move A64 - A126 to B1 to B63. Thanks

I've been given a CSV file that is organised by this format. It reads something like: ID,1 Name,Ryan DOB,11/11/11 Postcode,xxx xxx I'm able to separate the values into an Excel spreadsheet but struggling to figure out how to efficiently move the cells into my desired format. E.G...

Hello - I am trying to get the CSV values into a collection. However, when there is a date item for ex: '5/5/2018' - when it is converted into a collection it is having a text value like '28170'. If the date value in excel is 05/05/2018 - then it is properly being read. How can we solve this...

Hello, I would like to Import a txt file into Excel without using Collections. How do I manage to do this? Thank you for any help!!!

Hi, I used autofilter to filter a huge Excel-file. Now I would like to copy some rows with the Action "Copy and Paste Worksheet Range". This is not working for me in the correct way - I would like to copy only the visible, filtered cells. I was trying to modify the Code Stage of "Copy and...

Hi, I am attempting to get a collection from an excel worksheet using the excel VBO. Normally this works fine. However, my file has approx. 200k lines. I am getting a system out of memory error message. Is there anyway to load this volume of data into a collection?

How can we apply excel functions through Blue Prism??

Hi All, I came across following issue, I'm not able to create an excel instance using BluePrism. The create instance action hangs for a while and returns error message: Cannot create ActiveX component I checked if the 'CreateObject' function generally works with simple VBS and the Excel was...

Hi, I am trying to convert an excel document into a text file. I originally tried Save as, which didn't work, I tried writing to Notepad but couldn't get that to Word. So what I would like to do is either write the collection directly to MS Word or if not possible, write to Excel and then...

Hi, I need to get a particular cell value from an excel sheet. I can not pass the cell address directly as it may vary from sheet to sheet. But the cell is always the bottom right cell, and has a complete blank row and column around it. Can you give any ideas how to reach that cell and get the...

Hi Team, I want to Swap the cell values in Excel Sheet using blueprism. For Example : I have Data in cell A and B Columns and I Want Swap Cells Values data B to A Regards, Devendhar

Hi, I wish to copy data from excel into notepad. Is there a way to do this? I have opened excel, opened notepad but it appears none of the options within Excel VBO seem to match what I want. I have tried 'Write to Clipboard' but am unsure what the Input value would be. Please help :) Thank you

Hi, i need to compare two excel file cell values and store the result in another word document. How should i proceed? Can i get a brief idea of the steps?

Hi How to access folders and excel files in a shared folder using Blueprism VBOs. The folder path will be like \\Cnbb11023\Robotics\MyExcel.xls. Thanks in advance

I have requirement to filter the records on the basis of one criteria and after comparing both the sheets, paste the records into another sheet. In both the excels the templates are same and there first three rows and last row are merge rows. What i did: After perform all my bot functionality...