Adventures with Power Platform: Power Automate, Excel and Office Scripts! Oh My!

I have been playing around with Office Scripts lately, specifically Office Scripts for Excel. I wanted to create a Power Automate Flow that populated an Excel spreadsheet and then have the pivot table and chart based on the sales data. The spreadsheet consisted of two worksheets, one for car sales data, and another for a…