Assign an Excel formula to a datatable row

[Josh_James (Josh)]

Hello,

Trying to figure out a way to assign data table rows as Excel formulas. When I read an Excel sheet, store the DT, go through for each row in data table, assign the formula… When I write it back to the Excel sheet, the formula is there, but the value doesn’t show in the cell.

Only the formula itself appears in the cell, not the result. If I hover over the formula, that is correct.

[Anil_G (Anil Gorthi)]

@Josh_James

Are you writing using. Excel activities or workbook activities?

Ideally it should work with excel activities

Also try as RIGHT

Cheers

[Josh_James (Josh)]

Hi @Anil_G - I am using Workbook activities to read the sheet. We don’t have the Excel app as a company, we use GDrive. GDrive lets you upload Excel sheets.

I’m trying to do everything in a data table, then write the whole thing back to the locally stored Excel sheet, then upload that to Gdrive.

[Anil_G (Anil Gorthi)]

@Josh_James

But this would work with excel activities only as far as the formula in all sheets from datatable and not through workbook activities

Indtead as the data is present extract the data an dn write duirectly instead of formula

Cheers

[Josh_James (Josh)]

RIGHT returned the same result…

[Anil_G (Anil Gorthi)]

@Josh_James

Excel activities will aolve your issue

Or go with using substring and extract required info and write it

Cheers

[Josh_James (Josh)]

Yes, substring would solve this issue, but I have several different formulas to use in this sheet. I wanted to try this one first before I spent a lot of time on the others.