How to write a formula in csv cell?

[vijai1 (vijai)]

how to write a formula in csv cell?

[arivu96 (Arivazhagan A)]

Hi @vijai1,

Please check the below screenshot for writing formula,

Regards,
Arivu

[aksh1yadav (AKSHAY YADAV)]

Hey @vijai1

You can check the Existing Thread for the same

Fastest way to write an excel formula into an entire column

Hello everyone, Is the Write Value activity the fastest way to write formulas in Excel sheets? I’m asking you this because as far as I know when we are using this activity, we need to iterate between the excel rows in order to fulfill each row with the proper Excel formula, which means that it takes some time if the excel sheet contains too many rows (an average of 1 second per row, to write a new formula on a specific column). If I use the Write Range activity, is there a way to accept f…

Excel Variable SUM Formula

Hi all, I am attempting to write a SUM formula in Excel for an entire column. The issue I am running into is that the cell I want to place the formula in (at the end of the data) is variable based on the amount of information in the spreadsheet. How do I write a SUM formula when the cell is not static? Thanks for your help all

Excel formulas in local language is not working

Scenario: Steps to reproduce: Attach a workbook, use “Write Cell” and add a formula in non english. Example in Swedish: “=SUMMA(A1:A10)” Current Behavior: Excel doesn’t recognize this as a correct formula. Expected Behavior: Studio/Robot/Orchestrator Version: 2017.1 Last stable behavior: Last stable version: OS Version: Win10 Others if Relevant: (workflow, logs, .net version, service pack, etc):

Regards…!!
AKsh

[vijai1 (vijai)]

hi arivu,

BUt , will it work on csv?

[vijai1 (vijai)]

Hi All,

how to convert a csv to excel?

[vijai1 (vijai)]

hi arivu,

it is not working in csv file…