Delete Data from Table but not column formula

Help Studio
1

Hi,

I have one Excel File with Table Data with Some column Have formula Functionality.i want delete table data not formula. ex: i delete data then i copy past some data that time column formula is work.

Regards

3

@MD_Farhan1

  • Excel Application Scope
    • Read Range (Sheet: “YourSheetName”, Output: DataTableVariable)
    • Clear DataTable (DataTable: DataTableVariable)
    • Add Data Row (ArrayRow: YourNewDataRow, DataTable: DataTableVariable)
    • Write Range (Sheet: “YourSheetName”, DataTable: DataTableVariable)
4

Hi @MD_Farhan1 ,

You can copy the formula first in UiPath variable first then you can remove value and paste the formula again.

Regards,
Aman