Putting formula text in a DataTable

datatable
excel
enterprise

#1

I am trying to use the datatable format to put numbers and formula into a csv file. However, when we export the datatable to the CSV, the formulas stay there as text. The only way to activate them is to use the Enter key.

For instance, when inputting SUM, the Excel won’t show a sum of two numbers, instead it would show “=SUM(A1:A2)”

How can I make the Excel formulas active when putting them in Excel?


Insert excel formulas from Datatable into Excel as formulas and not as strings
Fastest way to write an excel formula into an entire column
#2

Are you performing this inside excel Excel activity (inside application scope or Workbook Activities?


#3

We are exporting a Excel File from DataTable


#4

FYI…works for me with Write cell inside excel application scope but not with Workbook write cell, did not try Write range(datatable).


#5

Actually it uses the “Write Range” command


#6

You did not answer my question yet, which write range activity are you using? There are two activities excel write range and work book write range. it works with excel write range
excel_formula.xaml (9.3 KB)
123.xlsx (7.9 KB)