Styjun

A vector is defined to have a magnitude and *a* direction, but the zero vector has no *single* direction. So, how is the zero vector a vector?

Why does the U.S. military maintain their own weather satellites?

How to run a command 1 out of N times in Bash

Does the Freedom of Movement spell prevent petrification by the Flesh to Stone spell?

Why do presidential pardons exist in a country having a clear separation of powers?

Can I leave a large suitcase at TPE during a 4-hour layover, and pick it up 4.5 days later when I come back to TPE on my way to Taipei downtown?

German equivalent to "going down the rabbit hole"

How do I get my neighbour to stop disturbing with loud music?

Doubt about a particular point of view on how to do character creation

Is this statement about a motion being simple harmonic in nature strong?

How were US credit cards verified in-store in the 1980's?

What checks exist against overuse of presidential pardons in the USA?

apt-file regex: find multiple packages at once using or

Understanding data transmission rates over copper wire

Tikz: Draw simplified BLE-Stack

Why haven't the British protested Brexit as ardently as the Hong Kong protesters?

In what language did Túrin converse with Mím?

The correct way of compute indicator function in Mathematica

How is the anglicism "jackpot" commonly expressed in French?

Is it good practice to speed up and slow down where not written in a song?

New coworker has strange workplace requirements - how should I deal with them?

What is the chance of getting a Red Cabbage in year 1?

Don't look at what I did there

Can a system of three stars exist?

How to output multiple excel files with conditional formatting in R

How to sort a dataframe by multiple column(s)Grouping functions (tapply, by, aggregate) and the *apply familyUsing lapply to apply a function over list of data frames and saving output to files with different namesWays to iterate over a list in JavaReading multiple worksheets into data frame(s) in RCreate conditional variable in multiple data.tables (or data.frames)Use R and Openxlsx to output a list of dataframes as worksheets in a single Excel fileUpdating / exporting to an excel file from R without saving a new workbook (corrupting graphs and other objects)Saving Excel files in loop in r

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

1

Let's say there is a data.frame with a grouping column to split by. I want to loop through that list of data frames, apply conditional formatting rules to each, and save.

Using the "openxlsx" package, the function conditionalFormatting() takes a wb object. As of now, the write.xlsx function does not support the option to include conditional formatting. So I have to do things the old fashioned way, but I don't want to create X amount of workbook objects in my global environment nor do I want to clutter my script with repetitive lines of code.

So this question is actually multiple questions in one. In order to conditional format a list of data frames, we must first create a list of workbook objects. IS that even possible?

Then with my list of workbook objects loop through and add: a worksheet, each data frame in the list, apply multiple conditional format rules, and finally save.

r loops openxlsx

share|improve this question

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've pretty much done something similar if I'm not wrong, and I don't think you need to create many workbook one is enough and you can loop through your data.frame and create many sheet depending on your needs. Can you provide an example of your data.frame so I can help you ?
  
  – Arkning
  May 24 at 7:49
  

  
  
  
  

add a comment | 

0

1

Let's say there is a data.frame with a grouping column to split by. I want to loop through that list of data frames, apply conditional formatting rules to each, and save.

Using the "openxlsx" package, the function conditionalFormatting() takes a wb object. As of now, the write.xlsx function does not support the option to include conditional formatting. So I have to do things the old fashioned way, but I don't want to create X amount of workbook objects in my global environment nor do I want to clutter my script with repetitive lines of code.

So this question is actually multiple questions in one. In order to conditional format a list of data frames, we must first create a list of workbook objects. IS that even possible?

Then with my list of workbook objects loop through and add: a worksheet, each data frame in the list, apply multiple conditional format rules, and finally save.

r loops openxlsx

share|improve this question

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've pretty much done something similar if I'm not wrong, and I don't think you need to create many workbook one is enough and you can loop through your data.frame and create many sheet depending on your needs. Can you provide an example of your data.frame so I can help you ?
  
  – Arkning
  May 24 at 7:49
  

  
  
  
  

add a comment | 

Let's say there is a data.frame with a grouping column to split by. I want to loop through that list of data frames, apply conditional formatting rules to each, and save.

Using the "openxlsx" package, the function conditionalFormatting() takes a wb object. As of now, the write.xlsx function does not support the option to include conditional formatting. So I have to do things the old fashioned way, but I don't want to create X amount of workbook objects in my global environment nor do I want to clutter my script with repetitive lines of code.

So this question is actually multiple questions in one. In order to conditional format a list of data frames, we must first create a list of workbook objects. IS that even possible?

Then with my list of workbook objects loop through and add: a worksheet, each data frame in the list, apply multiple conditional format rules, and finally save.

r loops openxlsx

share|improve this question

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

share|improve this question

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

share|improve this question

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges

asked Mar 27 at 23:19

Jack SernaJack Serna

2699 bronze badges