cancel
Showing results for 
Search instead for 
Did you mean: 

Get Cell Value VBO Excel

CemileDemirci
Level 3
  Hello Everyone Is it possible to get multiple Cell values from different cells in excel, i have to read 15 different cells (like A2 , H3, BK25)from excel to check this excel. Does someone made this easier than add 15 actions into the proces. Cemile
3 REPLIES 3

BenKirimlidis
Level 7
Instead of calling each cell individually.  Create a collection containing the cell references (would recommend naming the cells and addressing that name rather than the cell number e.g. cell A5 contains a staff name or something, call that cell 'StaffName' or something). So the collection will have a field called A4, A6, B9 etc.  Or the fields would be called StaffName , Salary, JobTitle etc.  Whatever you're tryign to capture. Then have a loop or a conditional statement, whatever you prefer to cycle through and address each cell reference and store it in your collection.  This way if you ever want to add/remove an item you just add/remove additional item fro mthe collections lsit of fields. Additionally if you were extracting data from multiple excels all in the same format, you can add a new row for each one and build a lsit of work items that way. Hope that helps

CemileDemirci
Level 3
Hi Ben, Thank you for the answer. The layout of the excel is a form so its complex to get this in an collection, im searching for an code what does "" get cell value"" but you can give multiple cells as input for it.   CD58      

AndreyKudinov
Level 10
You can add that kind of action in VBO (with code stage or just blueprism loop).  Doing it in code stage has no real benefits, unless you are getting a big range with one interop call instead of many many single one. You process can be a single ""do the right thing"" action calling VBO if you want to.