search

zeehio / condformat

R package to apply conditional formatting rules to a data.frame
Other
25 stars 6 forks source link

Render multiple sheets #11

Closed danielmcintosh1 closed 7 years ago

danielmcintosh1 commented 7 years ago

Current render2excel function only accepts a parameter for workbook name.

Can you add a parameter for sheetname as the current default of sheet1 is not accessible and therefore I am not able to loop through a series of tables that I need to export.

zeehio commented 7 years ago

I haven't done extensive testing, but feel free to try it:

devtools::install_github("zeehio/condformat")

And then do something like:

library(condformat)
data(iris)
x <- condformat(iris)
condformat2excel(x, "an_excel_file", "sheet1")
condformat2excel(x, "an_excel_file", "sheet2")

I don't have much time to work on this right now, I hope this is useful :+1:

danielmcintosh1 commented 7 years ago

This worked on my dataset! Much appreciated!