I'm wondering if there is any way to make the values of all the functions listed in Excel fixed values

I am currently in the process of deleting a particular column in Excel, but the remaining columns refer to the deleted column, and when I am done processing, they are in the state of Ref.

Therefore, I would like to set all the values in the target Excel to fixed values instead of functions before deleting the column, but I have not found a good way to do this.

So, if you know how to do this, please let me know.
Thank you very much.

Hi

May be you can first read that entire excel as a DATATABLE with read range activity and save it as a variable named dt

This will get all the value instead of functions in back end

Then we can remove the column with this expression

dt = dt.DefaultView.ToTable(False, “ColumnName-1”, “ColumnName-2”,….,”ColumnName-N”)

Mention the column name you want to retrieve back and dont mention then one which is not needed

This will give you the columns you want with data

Then you can write that to a excel with data value

Cheers @Kirigirisu_Coin

1 Like

Thank you for not only telling me how to deal with the function, but also how to delete it.
Thanks to you, I was able to broaden my horizons.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.