The R community is fantastic and very helpful for getting started. There is so much peace of mind to be gained by doing everything in R and then using R’s write.xlsx to output the excel sheet for your users.

Python+pandas is an ok alternative. The ergonomics are weird, but if you’re familiar with Python, it works enough.