Excel Interpretation of Blueprism Inputs

[MarcoMatuttis1]

I have a excel file that I open with blueprism to add some simple data like text in certain cells.

I use get excel sheet as collection for this.

I edit the collection and add texts and formulas

I can successfully enter text/formulas like =L2 in a cell and when I open the excel file in the MS Excel Software the result gets displayed correctly.

But when I enter more "complex" (not really complex) formulas like =SUMME(L2:L4) excel will display #NAME? in the cell.

When I double click the cell it switches the #NAME? to the correct result of the formula.

Is there a way to enter Text into cells that Excel interprets the input correct right away?

Or is there a button in excel that solves this. Maybe a way to format all the cells at once?

​​

------------------------------
Marco Matuttis
Robot Process Automation Developer
INTER Krankenversicherung AG
Mannheim
------------------------------

[AndreyKudinov]

If you want my opinion - I wouldn't expect Write Collection to work with formulas at all, because you might also want it to write text starting with "=".
In fact, my version explicitly escapes all such strings with '

If you want to set formulas, you can do it explicitly in separate action with code stage like this:

Dim xlInstance = GetInstance(handle)
Dim xlWorkSheet As Object = GetWorksheet(handle, workbookname, worksheetname)
xlWorkSheet.Range(cellref).Formula = value​

cellref can be a range. And FormulaLocal works here too if you really want to use locale specific version, although I wouldn't do that.

------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------