Stack Overflow
Stack Overflow

Questions tagged [writexl]

An R package for convert dataframes to Excel files

45 questions
0
votes
0 answers

Renaming excel file created in R with variable name using write.xlsx

I have a data frame which I want to store in an excel file. Additionally, I have a variable with name dateofentry which has a value. I want the excel file which will be saved to have this variable name in it along with word report. I have written…
Manu
  • 29
  • 6
0
votes
1 answer

Missing values when I export my data frame from R to excel

When I export my dataframe from R to excel the last column ends up with no values in excel. Any suggestions please? I exported through this code: write_xlsx(X,"/Users/MT/Desktop/Analysis v2/Frequency_aez.xlsx") The structure of my…
Myr TH
  • 175
  • 1
  • 9
0
votes
1 answer

Export a data in R with changing rows colour

I want to export a dataset similar to the one below, into an excel file with colouring the rows , and changing the colnames+rownames format to…
Ruser-lab9
  • 193
  • 1
  • 12
0
votes
1 answer

Saving XLSX with special characters (UTF-8 encoding) using Cronjob in R

Using the writexl package I can write a data.frame into an xlsx file, while keeping special characters in the xlsx file, because the data is saved in UTF-8 encoding (on Mac). This works when I run my R script from the R console. However, when I…
Stephan vd Zwaard
  • 43
  • 6
0
votes
1 answer

How to have users download pre-loaded, formatted excel document in R Shiny?

I'm building a Shiny App where users complete a survey, and based on their responses, it suggests different templates for them to use. The templates are all excel files that are heavily formatted (e.g., have pictures on them, misaligned headings,…
J.Sabree
  • 2,280
  • 19
  • 48
0
votes
2 answers

Using write_xlsx in a for loop to export dataframes into multiple sheets

I want to export some dataframes that I create through a for loop. These should be exported to different Excel sheets in the same file. While exporting, I want each sheet to have a different name. For instance, the sheet names in my following…
Anup
  • 239
  • 2
  • 11
0
votes
1 answer

R error message for unused argument (writexl)

I have simple code library(writexl) write_xlsx(dataset, "C:/adhoc/my_data.xlsx") The above works, however when I try library(writexl) write_xlsx(dataset, "C:/adhoc/my_data.xlsx", append=TRUE) I get an unused argument error. How can I fix?
user8876747
  • 35
  • 8
0
votes
1 answer

Write an R data frame to an Excel file maintaining Excel's default date format

If you open up a new instance of Excel 2016 and enter a date in the following format 8/15 it will output in Excel like this: Excel's format menu identifies this as Custom > d-mmm. Now let's move on to the R part of this question. I'll create a…
Display name
  • 4,153
  • 5
  • 27
  • 75
0
votes
2 answers

Can't open exported Excel file due to problematic text string

I have the following data: structure(list(QB5B_2 = structure("Car les GAFA sont des sociétés Américaines et de plus les gouvernements qui composent l'Union Européenne ne sont pas d'accord entre elles sur la stratégie à adopter en ce qui les concerne…
deschen
  • 10,012
  • 3
  • 27
  • 50
0
votes
1 answer

How to update a value at specific position in cell data

I have an excel sheet. Where I have data like this Sample_d sample_normal 1 (0.234,0.889) I want to remove the '()' brackets from the first and last positions in the 'sample_normal' column.
Qasim Ali
  • 66
  • 9
0
votes
1 answer

How to automatically populate the values of a column into a new data frame?

This is a kind of problem of problem that is generally solved using Microsoft Excel. Since I am not familiarized with VBA and Macros I need to take the help of R. The data frame looks like this. df <- data.frame(player_no = c(1,2,3,4,5,6), player =…
Sri Sreshtan
  • 41
  • 7
0
votes
0 answers

How do I convert characters to numbers (where there are actually numbers) in R?

When importing data using readxl into R (i don't have the other version requiring java as it won't install), using col_names = false, the data will import as characters instead of numbers - which means I can't actually do any functions on them.…
codingnewbie
  • 33
  • 6
0
votes
1 answer

Writing .xlsx files, with conditional filepaths

I want to manipulate different .csv files through a loop and a list. Works fine, but I for the output, I have to create many .xlsx files and the files have to be named according to the value of a certain variable. I've already tried piping the…
Tobias Esser
  • 11
  • 2
0
votes
2 answers

Can write.xlsx write multiple tabs into a file?

Within R, I am trying to print a series of dataframes into an Excel file using openxlsx. Specifically in this case, I'm using list.files, read.xlsx and write.xlsx. I'm still unable to write multiple tabs into one Excel file. Please see my code…
Grygger
  • 83
  • 6
0
votes
2 answers

Import Multiple txt Files and Write Individual xlsx Files With Same Name For Each

I have a folder that includes hundreds of txt files with specific financial data for each company code/year/month combination (for specific companies that are designated by the four digit number in the front of the file). I need a way to loop…
rgh_dsa
  • 107
  • 8
1 2
3