BLUE PRISM MS EXCEL - Merge Cells without removing the value

Hover over an image to enlarge

$50.00

This product is electronically distributed.

Do you have any painful experience of using "Get Worksheet As Collection" to work with merged cells?

We provide a new action to deal with the unstructured data.

 

For example, please see the table below.

number Name Name(katakana) gender phone number post number address        
1 秦明音 ハタアカネ 0335661437 160-0005 東京都 新宿区 愛住町 1-15-6  
2 三浦里奈 ミウラリナ 0967064848 861-4171 熊本県 熊本市南区 御幸西 3-12  
3 本山美和子 モトヤマミワコ 0773173227 604-0861 京都府 京都市中京区 大倉町 3-11-12 グリーン大倉町202

If you use "Get Worksheet As Collection" to convert this table into collection, it will fail because of the merged cell.

Merged cell will cause the blank header issue and you can not get the completed value.

But we provide the solution about this issue.

Only you need to do is input the start column and end column, and then this action will convert this table into the table below.

number Name Name(katakana) gender phone number post number address        
1 秦明音 ハタアカネ 0335661437 160-0005 東京都新宿区愛住町1-15-6
2 三浦里奈 ミウラリナ 0967064848 861-4171 熊本県熊本市南区御幸西3-12
3 本山美和子 モトヤマミワコ 0773173227 604-0861 京都府京都市中京区大倉町3-11-12グリーン大倉町202

And now you can use "Get Worksheet As Collection" without any pain.

Note: As you see, this action will directly change the cell values. If you want to use this action, please make sure the worksheet is unprotected. And if you don't want to change the cell values in the source excel file, please don't save the workbook after you using this action. 

 

Example:

If you have a worksheet like this below, after you use the "Get Worksheet As Collection" action, you can find the value of [Collection.address] didn't contain the whole address. 

The value of [Collection.address] only contains the value from G column. The ohter values will be sent to "Column1", "Column2", "Column3"....

So you can use "Merge Cells without removing the value" action to make sure you can get the collection which you really want.

As the picture below, all you need to do is input the start column and end column and the start row to this action, and it will merge the cells without losing value. 

 

After the change, you can use "Get Worksheet As Collection" action to get what you really want.

 

 

 

 

No posts found

Write a review
Immediately Available

Most products are downloadable and available immediately after purchase

Quality assurance and service

We vet all products for quality and best practise

Refunds within 20 days

You have 20 days to test your purchase and request a refund if it doesn't meet your expectations