10-11-20 10:55 AM
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?
13-11-20 12:09 PM
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.