0

I have written a R code to create excel workbook and added the data to it using XLConnect package.

wb <- XLConnect::loadWorkbook(Name,create = TRUE)

and added some data frame to this file. Now, I want to access this XLConnect object wb from xlsx package and do some formatting like adding a border, font, wraptext and alignment on the dataframe inside the file. Is this possible?

Kindly let me know if anything is unclear or need more clarification.

alistaire
  • 42,459
  • 4
  • 77
  • 117
Raj
  • 1
  • 1

1 Answers1

0

It seems that it is not possible to use XLConnect and xlsx packages in the same R session or at least not in single package. I am using openxlsx package for formatting the excel file.

Raj
  • 1
  • 1