I found that this product https://powerexcel.app/ can meet your needs without requiring programming skills.

I have used it, and the results are very good. It can batch process many Excel files as required.