Copy/Paste selected value only into new excel

[sherpa24 (pema)]

Hi all, I am having issue with copying a selected rows / columns from one excel to another , the column I am copying has formula in it but I only want the value of it. I am having trouble copying specific columns, read and write activity don’t work for formulated cells if you only want the value.

Thanks

[ovi (Viorela Preda)]

Hi pema,

Please take a look at these posts, there are some examples:

Copy Row from one DataTable to another

Barry John Edwards May 24, 2016 12:23 ANSWERED Hi, I am writing an automation where two excel spreadsheet worksheets are compared. If a row in Sheet 1 is not in Sheet 2 then the row is added to sheet 3. However, I get the following exception when I try it:- Add data row : This row already belongs to another table. I Googled this error and it appears to be because .NET will not allow a row from one table to be copied to another. Now there are plenty of solutions out there that involve us…

Copy dataTable row to another dataTable

Hi! I have tried to figure this out for a week now. So my problem is i have one big excel file with 12 columns in one row and it has lot of rows. Now i want to divide it to different excel files depending on one column. I have figured out how to get the specific row but now i need to add the rows to the new datatable that i can create the file. How to do that? Now i have done it so that i go through for each row in the datatable and inside the loop i use get row item then i use add data ro…