Stack Overflow
Stack Overflow

Questions tagged [openxlsx]

Use this tag for questions related to the openxlsx package. The openxlsx package provides functions to make it easy to read, write and edit XLSX Files in the R programming language.

The package simplifies the creation of Excel files in the programming language by providing a high level interface to writing, styling and editing worksheets. Through the use of , read/write times are comparable to the xlsx () and packages with the added benefit of removing the dependency on Java.

For more information on the package see:

Original author: Alex Walker
Current maintainer: Philipp Schauberger

410 questions
0
votes
2 answers

Linear model results written to excel file

I'm running a linear model in R and I want the entire output of my model to be written to the same excel file. Right now, I can do this only for the coefficients, which is the first example. The second example is when I try to get the entire output…
dre
  • 474
  • 5
  • 19
0
votes
0 answers

issue with Openxlsx package in r

when i export excel file in R using open xlsx package if i open excel file it's shown these message: "We found a problem with some content .xlsx. Do you want us to try and recover as much as we can?" i think this issue come from Openxlsx…
Mj___3
  • 13
  • 8
0
votes
1 answer

"Rcmdr" error load failed for ‘car’ in loadNamespace(j <- i[[1L]], c(lib.loc, .libPaths()), versionCheck = vI[[j]]):

I'm attempting to run 'Rcmdr' in R. I had it fully functional and accidentally exited the program. Now i can not get back in. I've tried a number of things; uninstall and reinstalling R uninstall and reinstalling 'Rcmdr' I tried manually…
Wkinsley
  • 1
0
votes
0 answers

How to create named range with a sheetname with Openxlsx package

Using the name= parameter in the writeData function in the openxlsx package creates a named range in Excel. This name does not seem usable because there is no worksheet associated with the name. Here is the example R code that creates the…
rmacey
  • 599
  • 3
  • 22
0
votes
1 answer

Unformatted Excel data import?

I'm trying to read an Excel file with over 30 tabs of data. The complication is that each tab actually has 2 tables in it. There is a table at the top of the sheet, then a few blank rows, then a second table below with completely different column…
Arthur
  • 1,248
  • 8
  • 14
0
votes
0 answers

Getting Different Content-type for .xlsx file

I am using IIS server to host my .net (MVC) application and we have 2 different RDPs for our two environment 1) Development and 2) Production. Code for checking Content-type : if (file.ContentType !=…
krunal patel
  • 41
  • 7
0
votes
1 answer

Is there no RTools dependency for openxlsx version 4.1.0?

I am struggling to get some nice formatted tables from RStudio in Excel. Looking for a workaround I started this topic: export excel friendly tables via HTML/CSS Hopefully it does not look too rude, but I want to split my problem in two questions.…
Peter P.
  • 51
  • 7
0
votes
1 answer

Error in excel charts when overwrite data from R

I am trying to automate some of my tests in R to produce a static report in Excel. I have created a template in Excel which has a few charts and tables(sheet 1). Now I run my R code to generate the data to fill in the same excel template file on…
R trader
  • 31
  • 1
  • 5
0
votes
0 answers

Unable to format Excel file after output with write.xlsx from library openxlsx

I am unable to format columns after exporting with the following function: write.xlsx(df, file=paste0("H:/OrderReport/Orders_", today, ".xlsx")) I am getting the following messages to the console. adding: xl/worksheets/ (164 bytes security)…
Andrew Borst
  • 338
  • 3
  • 12
0
votes
1 answer

how to apply selectively borders to an existing xlsx using openxlsx

The objective is to apply borders to parts of a table using openxlsx. Next I will show the desired output, builded in a way that is not the desired one: printing parts of the table and formating it in each…
Nicolas Molano
  • 693
  • 4
  • 15
0
votes
1 answer

openxlsx write R dataframe to XLSX with cell reference from worksheet to another

I am trying to write formulas from an R dataframe to XLSX file. I want to reference data from one worksheet in another using cell references. One worksheet is suppposed to be a "database" and then the other sheet is supposed to have the "formula"…
larnsce
  • 103
  • 8
0
votes
0 answers

Alternative to Rtools for openxlsx

I am using R on my work computer inside of our Network. Naturally, I do not have admin rights and It would be hard to convince my IT Department to make an exception for me installing Rtools on my computer. My main issue with not having Rtools is,…
Max M
  • 806
  • 14
  • 29
-1
votes
1 answer

does openxlsx offer bullet/key point functionality?

I need to output, using the openxlsx R package, some text rows in bullet point format. There doesn't appear to be a createStyle() option for doing this. Is anyone aware of a way to do this using openxlsx?
Allerious
  • 85
  • 4
-1
votes
1 answer

What is an efficient way to make excel report from python?

For the report I use this code: from openpyxl import load_workbook ReportName = "tets.xlsx" new_row_data = [ ["value", 'value2', "value3"]] wb = load_workbook(ReportName) # Select Second Worksheet ws = wb.worksheets[1] # Append 1 or 2(if…
Pren Ven
  • 177
  • 1
  • 10
-1
votes
1 answer

How To Reorder Sheet With R

I am using an excel workbook with 32 sheets. However, when I try to put sheet thirty-two at the front of sheet 1 in the workbook using worksheet order it gives an error. Please find the error attached…
nesha
  • 5
  • 4
1 2 3
…
27
28