Formulas in Excel

Help Activities
, ,
1

Hi team,

This is what I have:

  1. Browse For File

    • Output - SelectedFile: “QuotePath”

  2. Input Dialog

    • Asks for the number of the last row. (I need it to easily discard the rest of the information I don’t need).

  3. Excel Application Scope

    • WorkbookPath: “QuotePath”
    • Output - Workbook: “QuoteWorkbook” (This variable is the type WorkbookApplication)

    Activities:
    A. Get Workbook Sheet (to know the name of the sheet)

    • Index: 0
    • Sheet: “oldSheetName”

    B. Read Range (reading to work in a clean file)

    • Range: “A16:R” + lastRow
    • SheetName: oldSheetName
    • Output - DataTable: quote

  4. Add Data Column

    • Column Name: “DescriptionFormula”
    • Data Table: quote
    • TypeArgument: String (not sure about this)
    • MaxLength: -1

  5. Read Text File

    • File Name: “Formula.txt” (I created this file in the project’s folder with the formula to use)
    • Output to: descriptionFormula

  6. For Each Row in Data Table

    • Data Table: quote

    Activities:
    A. Assign

    • Set Value: descriptionFormula
    • To Variable: CurrentRow(“DescriptionFormula”)

image
image512×956 32.3 KB

image
image511×612 20.5 KB

So, the workflow is ok. The problem is that in the Excel file, all I can see is the formula itself. I have to open the Excel file manually and double-click + Enter to see the result.

image
image1387×732 97.4 KB

Does anybody know how to work around it?

2

Hello @mardoza , have you tried to write using excel application scope and not workbook?
This may solve you issue.

3

Just Write the excel with Excel Aplication Scope and it will be fine.

4

Replace write range workbook activity with excel application scope & write range inside it.

5

Hello @erigert_ndokaj, @FerdinanAlberto, and @Jayesh_678! The thing is that I need the process to run in the background. I noticed I can’t do that with Excel Application Scope.