SharePoint On-Prem

Worth a direct correction before anything else: neither the classic on-premises COM-automation script nor the “PnP PowerShell” example commonly shown for this actually produces a real Excel file without a caveat. The COM approach genuinely needs Excel installed on the machine running it, and the PnP example usually exports to CSV, not a true `.xlsx`,