Robotic Process Automation (RPA)

 View Only
Expand all | Collapse all

How to remove formula in excel and keep values

  • 1.  How to remove formula in excel and keep values

    Posted Mon June 26, 2023 02:48 AM

    Hi,

    I have problem using RPA in excel.

    My excel file contains formula in some cells.

    When the RPA open this file and get excel table to data table, the output look like this:

    As you can see, Column 10 and Column 15 has '#VALUE!' which is in excel file is contain formula.

    This is my excel file

    Column K and P contains formula.

    Can you help me to solve this case?

    This is the code:

    defVar --name excelFile03 --type Excel
    defVar --name sheetVA --type DataTable
    defVar --name rowsVA --type Numeric
    excelOpen --file "fileExcel" excelFile03=value
    excelGetTable --file ${excelFile03} --sheet SheetVA --fromrow 2 --fromcolumn 1 sheetVA=value rowsVA=rows

    Thank you



    ------------------------------
    Muhammad Ramadhan
    ------------------------------


  • 2.  RE: How to remove formula in excel and keep values

    IBM Champion
    Posted Tue July 18, 2023 01:03 PM

    I haven't come across this scenario yet, but perhaps using "Excel Calculate Formula" command before the "excelGetTable" could work?

    Another not-so-clean option would be to save the file in another format (like CSV) and read the Data Table from that.



    ------------------------------
    Vinicius Marques
    ------------------------------