openxlsx | openxlsx - a fast way to read and write complex xslx files | Development Tools library

I created an R Markdown to check for errors in a series of datasets (e.g., are there any blanks in a given column? If so, then print a statement that there are NAs and which rows have the NAs). I have setup the R Markdown to output a bookdown::word_document2. I have about 100 datasets that I need to run this same R Markdown on and get a word document output for each separately.

Is there a way to run this same R Markdown across all of the datasets and get a new word document for each (and so they are not overwritten)? All the datasets are in the same directory. I know that the output is overwritten each time you knit the document; thus, I need to be able to save each word document according to the dataset/file name.

Minimal Example

Create a Directory with 3 .xlsx Files

...

Consider the following code block from the r package openxlsx.

I'm trying to fill certain cells in the excel spreadsheet with a particular color.

This is the code I used in order to do this.

...

I created an error alert for when a file of format other than ".xlsx" is loaded in fileInput. For that I created sendSweetAlert. This is working. What I would like now is the following: Whenever I load a ".xlsx" file, apparently the code does not give any error, however I would like to accept only ".xlsx" files, which are actually usable by my function.

The file I use can be downloaded from this link: encurtador.com.br/dqsOQ

...

Objective

I wish to add subheader and subtotal/margin rows within a table. Ultimately, I am looking for a structure shown below, which I will export to Excel with openxlsx and writeData.

2019 2020 2021 A A1 1001 1157 911 A2 1005 803 1110 A3 1125 897 1190 Total A 3131 2857 3211 B B1 806 982 1098 B2 1106 945 1080 B3 1057 1123 867 Total B 2969 3050 3045 C C1 847 1087 1140 C2 1146 966 1176 C3 1071 915 892 Total C 3064 2968 3208 Total All 9164 8875 9464

I suspect the subheaders and subtotals are completely different questions, but I am asking both here in case there is a common method related to each.

Reproducible Code So Far

Create the Sample Data (long format):

...

I want to be able to update the selection available in the pickerInput based upon the selection made in the radio button input. In the example below, I want the radio button "A", to give a pickerInput list of mtcars$cyl, whilst a picker input of "B" to give a picker input of mtcars$mpg

I have tried doing this using if statements, but I haven't got anywhere so far. Reproducible example below:

...

I have a large dataset with time stamps. The original data contained the time format like this:

...

I have several cities with stats stored into dataframes lists (each list have one dataframe for each city). I want to create an excel sheet with all the dataframes for each city. Each dataframe will be stored in a different tab.

This is my code :

...

I am trying to create function for formatting every tables in xlsx file.

I want to save N numbers of Tables in xlsx and formatting all the tables in xlsx file. but its formatting the first table only.

...

I'm using openxlsx to write data from a data frame to an excel file. I need the data to be coloured given some rules (eg if the value of a cell is A1 & B1 colour the cell with red). The problem is that this doesn't seem to work when the string representing the rule contains the following characters: &, *. I assume that there might be more characters having an unusual behaviour, but for these two I've experienced the following:

• &: if & is in the rule then the Excel file gets corrupt and it doesn't even open properly
• *: if * is in the rule then all the cells are getting coloured regardless of their content, which is not the expected outcome

Here's the code I'm using:

...