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.
Please take a look at these posts, there are some examples:
Barry John Edwards
May 24, 2016 12:23 ANSWERED
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…
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…