In R you can rename columns multiple ways. You can stick with Base R, use Tidyverse’s dplyr, utilize GREP, and even use data.tables.
Tidyverse
Creating Excel Workbooks with multiple sheets in R
Example r script to create an Excel workbook with multiple sheets and how to read in Excel workbooks with multiple sheets.