@ Vijay Butani
Thank you guys for the solution but I am running into an issue where when trying to open the excel sheet I get the below error. I am using Vijay Bhutani solution.
"The file format and extension of {filename} don't match the file could be corrupted or unsafe Unless you trust its source don't open it. Do you want to open it anyway?"
Please help.