topic Excel produces exception when in Product Forum

MS Excel VBO exception

AnatoliyBanniko — Wed, 15 Nov 2017 16:07:00 GMT

Hi, I have faced strange issue. Yesterday Excel vbo Open workbook and write collection worked perfectly but today everything has changed 😕 I was working on Dev2 final assignment and during the creation of process for reporting i faced issue of getting exceptioin at write collection stage. Exception was " Exception has been thrown by a traget invocation." Im trying to solve this issue all day but i simply donot understand the problem, i dont see it. Did anyone encounter that? What could be the problem and solution? Thank you in advance!

Which version of office are

Denis__Dennehy — Wed, 15 Nov 2017 17:48:00 GMT

Which version of office are you using? Blue Prism is not yet certified for Office 16/365. I ask because I have interfaced with every version of Excel from 2000 and 2013 and have never seen that error.

Deplorably, I am using 2013

AnatoliyBanniko — Thu, 16 Nov 2017 09:17:00 GMT

Deplorably, I am using 2013 version. I thought that when i was changing import CSV action in that VBO for my purposes, i broke something. (import csv works fine, though, still) I re-imported original MS Excel VBO, didnt help. Asked DWF IT to help, still waiting for an answer.

Excel produces exception when

AnatoliyBanniko — Thu, 16 Nov 2017 17:00:00 GMT

Excel produces exception when code tries to interact with the cells. In particular, when its trying to use SetProperty function to write collection into cells. Although, i tried to use Set Cell Value action, it sets the cell value(e.g. col * row item) and then produces the exception. This is confusing.

Basic computer restart solved

AnatoliyBanniko — Mon, 20 Nov 2017 08:30:00 GMT

Basic computer restart solved the problem. ;D