I am exporting some code to excel using your very helpful package, and trying to do it to 1 workbook over 3 sheets. However to do this I have repeated each command thrice, this can't be a good way to do it? Where am I going wrong? In addition, while the reprex below shows very short numerical observations, in reality the first column of my table needs to be much wider than the others, as it has a lot of text (while the rest don't). Is there a way to set this, or do i need to drag it across when I open the excel file? Thanks so much!

library(r2excel)
#> Loading required package: xlsx

 sample_prime1 <- 1:4
 sample_prime2 <- 10:14
 sample_prime3 <- 22:26
# Create an Excel workbook. 
filename <- "validitycheck.xlsx" #The name of the file that will be saved
wb <- createWorkbook(type="xlsx") #Creating an excel workbook

# Create a sheet in that workbook to contain the data table
sheet1 <- createSheet(wb, sheetName = "prime1")
sheet2 <- createSheet(wb, sheetName = "prime2")
sheet3 <- createSheet(wb, sheetName = "prime3")
 

# Add table : add a data frame for sheet 1
xlsx.addHeader(wb, sheet1, value="Validty for prime 1")
xlsx.addLineBreak(sheet1, 1)
xlsx.addTable(wb, sheet1, sample_prime1,
               fontColor="darkblue", fontSize=14,
              rowFill=c("white", "lightblue"),
              startCol=2, 
              row.names=FALSE, 
              col.names = FALSE)

# Add table : add a data frame for sheet 2
xlsx.addHeader(wb, sheet2, value="Validty for prime 2")
xlsx.addLineBreak(sheet2, 1)
xlsx.addTable(wb, sheet2, sample_prime2,
               fontColor="darkblue", fontSize=14,
              rowFill=c("white", "lightblue"),
              startCol=2, 
              row.names=FALSE, 
              col.names = FALSE)


# Add table : add a data frame for sheet 3
xlsx.addHeader(wb, sheet3, value="Validty for prime 3")
xlsx.addLineBreak(sheet3, 1)
xlsx.addTable(wb, sheet3, sample_prime3,
               fontColor="darkblue", fontSize=14,
              rowFill=c("white", "lightblue"),
              startCol=2, 
              row.names=FALSE, 
              col.names = FALSE)

Hello.

I'm trying to create an excel sheet using r2excel package.

But when I try to add a paragraph at the end of the sheet, after adding a table, it doesn't shows up.

The lines and columns set to merge appears correctly but none value is shown.

Could you fix it. please?

Thanks

Hi,

I copied and pasted your code in order to test it out on my instance of RStudio but continue to get a "could not find function "xlsx.addHeader"". Is there something wrong with the code or R? I'm fairly new to R so perhaps the answer is fairly simple, but thought I'd check in.

At first thanks a lot for this amazing package.
library("r2excel")
filename <- "r2excel-example1.xlsx"
wb <- createWorkbook(type="xlsx")
sheet <- createSheet(wb, sheetName = "example1")
xlsx.addHeader(wb, sheet, "Add paragraph", level=2)
paragraph="Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged."
xlsx.addParagraph(wb, sheet, paragraph, fontSize=14, isItalic=TRUE, fontColor="darkred", backGroundColor="gray")
saveWorkbook(wb, filename)

bachGroundColor doesn't work. Maybe this information is necessary: I'm running on linux mint 18 and use libreoffice.

I have been trying to install this package to R and have been getting the following error:
`devtools::install_github("kassambara/r2excel")
Downloading GitHub repo kassambara/r2excel@master
from URL https://api.github.com/repos/kassambara/r2excel/zipball/master
Installing r2excel
"C:/PROGRA1/R/R-341.4/bin/x64/R" --no-site-file --no-environ --no-save --no-restore --quiet CMD INSTALL
"C:/Users/rawlingsD/AppData/Local/Temp/Rtmpikoahr/devtools34bc39bb1506/kassambara-r2excel-4144fc5"
--library="C:/Users/rawlingsD/Documents/R/win-library/3.4" --install-tests

• installing source package 'r2excel' ...
  ** R
  ** preparing package for lazy loading
  ** help
  *** installing help indices
  converting help for package 'r2excel'
  finding HTML links ... done
  getOS html
  r2excel-package html
  xlsx.addHeader html
  xlsx.addHyperlink html
  xlsx.addLineBreak html
  xlsx.addParagraph html
  xlsx.addPlot html
  xlsx.addTable html
  xlsx.openFile html
  xlsx.readFile html
  xlsx.writeFile html
  xlsx.writeMultipleData html
  ** building package indices
  ** testing if installed package can be loaded
  *** arch - i386
  Error: package or namespace load failed for 'rJava':
  .onLoad failed in loadNamespace() for 'rJava', details:
  call: inDL(x, as.logical(local), as.logical(now), ...)
  error: unable to load shared object 'C:/Users/rawlingsD/Documents/R/win-library/3.4/rJava/libs/i386/rJava.dll':
  LoadLibrary failure: %1 is not a valid Win32 application.

Error : package 'rJava' could not be loaded
Error: loading failed
Execution halted
*** arch - x64
ERROR: loading failed for 'i386'

• removing 'C:/Users/rawlingsD/Documents/R/win-library/3.4/r2excel'
  In R CMD INSTALL
  Installation failed: Command failed (1)`

However, I have rJava being used for package xlsx, so I am unsure what the real issue is, just wanted to flag it to see if you know the way to get around this error?

Thanks in advance

Hi

Can someone help me for the installation errors? I have window 10 and just installed the new JAVA but still cannot install this package. Thanks!

library(devtools)
install_github("kassambara/r2excel")
Downloading GitHub repo kassambara/r2excel@HEAD
√ checking for file 'C:\Users\Ake\AppData\Local\Temp\Rtmps3rXmw\remotes60206955698e\kassambara-r2excel-4144fc5/DESCRIPTION' ...

• preparing 'r2excel':
  √ checking DESCRIPTION meta-information ...
• checking for LF line-endings in source and make files and shell scripts
• checking for empty or unneeded directories
• building 'r2excel_1.0.0.tar.gz'

Installing package into ‘C:/Users/Ake/Documents/R/win-library/3.6’
(as ‘lib’ is unspecified)

• installing source package 'r2excel' ...
  ** using staged installation
  ** R
  ** byte-compile and prepare package for lazy loading
  Error: (converted from warning) package 'xlsx' was built under R version 3.6.3
  Execution halted
  ERROR: lazy loading failed for package 'r2excel'
• removing 'C:/Users/Ake/Documents/R/win-library/3.6/r2excel'
  Error: Failed to install 'r2excel' from GitHub:
  (converted from warning) installation of package ‘C:/Users/Ake/AppData/Local/Temp/Rtmps3rXmw/file60207f9360fa/r2excel_1.0.0.tar.gz’ had non-zero exit status