I have more than ten thousand records in my excel column ,i need to copy entire column perform sub string and copy to other column in same excel sheet.
iam using
1)excel application scope
2)for each
3)get row item
3)writing range
But it taking more than 1 hour to complete 500 records …There is any alternative way to perform this operation in lesss time without using macro or vb code?
Use Excel application scope
Use select range
Use send hot key as Ctrl+c and use select range as empty and paste it into another column
Try this
Thanks
Ashwin.S
Assuming you just want the first 8 characters, it would look something like this:
Excel application scope (check box so excel is NOT visible)
Read range --> save as dt1
Assign NewDT (this is a datatable variable) = dt1.clone
For each row in dt1
Add Data row activity
Datatable: NewDT
Value: Strings.Left(row.item("YourColumnName").ToString,8)
Next row
Write Range → put it in a new sheet, or overwrite the existing one, your choice