Export very large data to Excel file

Question

I have a dataset,it contains four tables,i have used closedxml.I want to write four tables into four different spread sheets in single excel file.But I am getting out of memory exception,as my dataset cotains more than 40000 records.Kindly provide a solution for this.