I have been saving Excel files using openxlsx package and I really like it. However, saved files are in unclean version (not sure the right word), but it looks like this:
This is how I save my file currently:
writeDataTable(wb, "ABC", x = df, startCol = 1, startRow = 1, colNames = TRUE, tableStyle = "None", tableName = "abc", withFilter = FALSE)
But every time, I have to open each excel file manually and set the columns so that each column is seen easily. With increasing number of files, its becoming a time consuming task. Is there a way to save file directly in clean version or in other words, I can see all columns clearly and do not need to do anything.