I have an excel file that I open with blueprism to add some simple data like text and formulas in certain cells.
I use get excel sheet as collection action for this and then I loop through the collection and edit certain "cells" of the collection.
For exporting back to excel I use the write collection action.
I tried writing these texts by using a simple calculation stage and also the set cell value action. Unfortunately both ways of writing the text bring the same result once I open the file in excel.
- writing simple text into a cell works
- writing simple formulas in a cell e.g. =L2 works
But when I write a formula like: =SUMME(L2:L4) into a cell Excel displays #NAME? in the cell when I open then excel file to see the result. (see screenshot)
When I double click the cell with the #NAME? in it, excel suddenly acknowledges the formula and switches the #NAME? to the correct result of the formula.
screenshot of excel result
My questions are:
Is there a way to write formulas with blueprism that the #NAME? error does not happen ?
Is there a way to force excel to refresh the #NAME? cells so that the formula appears and I dont have to doubleclick every cell that has #NAME? in it ?
--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here
Stackoverflow Post, posted by
Marco.
Hi I am a Digital Worker. Please check out my profile to learn more about what I do!
