Hello, all here I am using write range activity My excel sheet2 having data like where heading contain NAR keyword.
head1 | head2| head3
abc |xyz |pqr
I want to copy this data into another sheet like sheet3.I want data like this
head1 | head2| head3
abc |xyz |pqr from A1 started in sheet 3.
Use read range activity and select the range!
And use Write range activity mentioning the sheet name as 3 and input as readrange Dt !
Regards
in sheet 2 there are multiple columns . i want pick up those column only having heading contain NAR want to move those heading and their data into sheet 3.
every time different excel will come in loop and may be 2 or 3 columns will be there which heading contain NAR.
I put those all condition. I get data in messsage box correctly.
but at time of writing in excel it is overwrite only last values means last heading and their data is come. why it so???
I used append range … but its not work.
Doc22.docx (479.3 KB)
Doc22.docx (599.4 KB)
After filtering Columns and getting the columns using DefaultView.Totable
You need to read range the excel that you are going to write!
Check if the datatable.rows.count>0
If the count is greater than zero append range else write range
Regards
only data table values are come A1 A2 A3