I got a project where i have to read a excel file that contains 6+ lakhs records and insert into sql and do some works and then write it in a new excel.
i get problem while wrtting the records in the excel. When i use write range in few mins the job gets stopped and bot throws the error.
when i openthe excel file where i write the records its been corrupted. can u guys help me into this .Need to know y its getting stopped and corrupted ??