Bulk Google Sheets Export

I have a collection of Google Sheets sitting together in one Google Drive folder and I need each of them converted into its own standalone Excel workbook (.xlsx). The end files should carry over only the visible values and the existing formatting—no formulas, charts, or images.

Please create a repeatable, error-free workflow (Apps Script, Drive API, or another method you prefer) that:

• Scrapes every Google Sheet in the folder
• Generates a separate Excel file for each one, preserving the original file name
• Pastes values + formatting only
• Drops the finished .xlsx files back into a destination folder I’ll specify

I’ll consider the task complete once I can run the process, watch the exports finish without manual tweaks, and open any resulting Excel file to see the exact numbers and formatting from the source Sheet.