I am working a project in which I use Write Range activity of Workbook to write data in excel file but it takes more time. One day before it takes 45 mins for 381 records to filter and write in excel file. But today it takes 2 hours and 30 mins for 381 records. Now i use write range activity of excel now it takes 38 mins for 435 records.
Can anyone tell me why write range activity of workbook takes more time than excel?