openxlsx | R package for .xlsx file reading and writing | Development Tools library

I am looping to load multiple xlsx files. This I am doing well. But when I want to add the name of the columns of the documents (the same names for all files) I have not managed to do it.

i want to write into multiple sheets of excel using loop. code is mentioned below.

I have been trying to obtain the time at which the content of an .xlsx file was created without any success so far. I can track the much-desired information on Windows either through File Properties -> Details -> Origin -> Content created, or by opening the Excel file and navigating to File -> Info -> Related Dates -> Created.

I was hoping that I would be able to obtain this information through openxlsx but while I am able to track down the creators by using the getCreators() function there does not appear to exist a similar function for the time.

I have also tried the file.info() function but it won't cut it as mtime, ctime, and atime all point to the time of the download.

Any help would be much appreciated!

All, Thanks in advance. I have this school dataset. Each category (in Category column) has a range number of students (e.g., from 30 to 60 students), so I need to calculate:

1. the total number of classrooms that fall in each category (from category 1 to category 4), and
2. the percentage of classrooms that fall in the category. For example, how many classrooms (NumOfClassrooms column) fall in Category_4, and what's the percentage of those classrooms to the total classrooms? Here is an illustrative example for my question:

I have used the below code to write data from R to excel. Style is implemented only for the header but not for the corresponding value. How to change the style as needed including the indentation, bold, and font size, etc;

In my Shiny app, I can upload an xlsx file and select sheet by typing the sheet's name:

I'm quite new to R and I want to plot a fancy correlation matrix in a word document.

here a little example of my data:

Lets say I create the following Excel file:

I used grid.draw() function of ggnewscale package to get the plot

But it seems the way of download is not the same to ggplot2 type.

I used pdf() to save my plot result in shinyapp.

But when I click the download button the plot result is not picture type or not pdf

It confused me and I viewed several methods(here) but it doesn't work

I also get some advice Here

Here is my reproducible code and data: