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.
Are you writing using. Excel activities or workbook activities?
Ideally it should work with excel activities
Also try as RIGHT
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.
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
RIGHT returned the same result…
Excel activities will aolve your issue
Or go with using substring and extract required info and write it
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.