Excel Write Problem

Hi Guys,

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 ??

Can you send me your workflow on my mail: sg2070156@gmail.com?
I think that their is very little mistake in your workflow.

or else you can send screenshots of code(workflow) here if you will not share your workflow on my mail.

Have a good day!

Happy automation!

SQL.xaml (10.1 KB)

@Sagar_Gupta1 this is my workflow bro actually this is a sample one doing in my pc

Its not open in my pc, I don’t know why So we can do one thing.
Ping me on my mail then I will send to you zoom meeting link So, on Zoom I will check.
I hope its Ok for you.