Stack Overflow
Stack Overflow

Questions tagged [writexl]

An R package for convert dataframes to Excel files

45 questions
7
votes
7 answers

Using write_xlsx in R

I'm using the write_xlsx command to export data from R to excel, Here is the data frame that I have, >df X1 A 76 B 78 C 10 Using , write_xlsx(df, "../mydata.xlsx") gives the following output in excel, >df 1 76 2 78 3 10 The…
Natasha
  • 1,111
  • 5
  • 28
  • 66
5
votes
2 answers

Write file xlsx in R without using Java

wight now I'having an issue with R. I could not use library openxlsx in my PC. When I try to import, these errors show me that: Error: package or namespace load failed for ‘openxlsx’: object ‘zipr’ is not exported by 'namespace:zip' Any one…
Long_NgV
  • 453
  • 1
  • 3
  • 16
4
votes
1 answer

write_xlsx(all_trips, "trips.xlsx") Error: Error in libxlsxwriter: 'Worksheet row or column index out of range.'

Does anyone know how to fix this error? Language: R I want to export the file to xlsx to used at Tableau Public but encounter the error write_xlsx(all_trips, "trips.xlsx") Error: Error in libxlsxwriter: 'Worksheet row or column index out…
user14517612
  • 43
  • 1
  • 3
3
votes
1 answer

Export a grouped dataframe to excel and creating a separate tab for each group (R, dplyr)

I have a large dataframe in R that I want to export to Excel. To make the understanding easier; I will use the mtcars dataset as an example. The dataframe has a grouping variable (cyl) and I would want the data for each group to be in a different…
Roberta
  • 37
  • 4
2
votes
1 answer

How can i write systematic data into excel sheet with systematicly?

I have been working with big though systematic data. Therefore I have wrote only shape of my data frame to below. I need to write every 3 column into different excel sheet. I tried some code and functions but i didnt achieve due to my lack of…
Enes
  • 33
  • 3
2
votes
1 answer

Rename excel sheets in R studio

I have one spreadsheet with 4 sheets in it, and I want to rename the sheets when I export the file from R. How can I do it- I can't download XLConnect library. This is what I have so far: sheets <- list(sheet1 = Top_Balances, sheet2 = Over_60,…
jennyro
  • 77
  • 7
2
votes
1 answer

Transfering network data from R to Gephi

I have generated a microbial network based on microbial abundance correlation in R using igraph, hmisc and matrix packages. Now i want to work on it in Gephi. For that, I have to transfer my data to Gephi. I tried to prepare CSV file form this data…
Khashi
  • 47
  • 1
  • 7
2
votes
2 answers

R: how to use writexl when data frame contains strings and numbers

I'm new to R, and I'm trying to save data to an xlsx file. I'm using writexl (xlsx was causing trouble). It seems that having strings and integers in my data frame causes problems when I try to use write_xlsx. I've recreated the issue…
mkn
  • 65
  • 1
  • 1
  • 7
2
votes
1 answer

Write xlsx files from list in current working directory with purrr:map

I am trying to write excel files from a list in my current working R space using purrr::map. I would like to use the name of each list as the excel file name (ex: name_1.xlsx, name_2.xlsx). How do I get purrr:map to do it?…
Leonardo Ribeiro
  • 105
  • 9
2
votes
1 answer

R: Append a worksheet to an excel workbook without reading the entire workbook

I have a 26 mb excel workbook to which I am trying to add a 42 kb worksheet. Using the openxlsx package, I have the following code: wb_object <- loadWorkbook(to_name2) addWorksheet(wb_object, "New Data") writeData(wb_object, sheet = "New Data",…
Rahul Nallappa
  • 181
  • 2
  • 9
2
votes
2 answers

What is the correct date format for writexl

What is the correct date format for the new writexl package? I tried it on lubridate dates, and the resulting Excel spreadsheet contains strings of the form yyyy-mm-dd (i.e. not Excel dates).
lebelinoz
  • 4,890
  • 10
  • 33
  • 56
1
vote
2 answers

R export data to excel with spanner header delimiter

I have a data.frame that looks something like this: data <- data.frame(X = c("A", "B", "C", "D", "E"), Y = c(1,1,2,2,3), Choice1.a = c(2,2,2,3,3), Choice1.b = c(5,6,5,5,6), …
melmo
  • 757
  • 3
  • 15
1
vote
1 answer

Writing multiple data frames from a list into excel, split 1 factor across different sheets and order by another factor

Here is some data. a<-rnorm(1000, 1,1) b<-rep(letters[1:10], each = 100) d<-rep(c("x","y","z","q"),250) abd<-cbind.data.frame(a,b,d) I would like to split this data frame into list of data frames based on a factor (b in this case) and than write…
procerus
  • 194
  • 8
1
vote
0 answers

Writing Excel file to Sharepoint using R Script

I'm fairly new to all of this but I have a really basic R script designed to export data from Power BI as an Excel file. Unfortunately right now I can only save it locally and would like to be able to save it to a Sharepoint location instead. I've…
BooksLM
  • 11
  • 1
1
vote
1 answer

writexl 1.4.1 bug: empty date entry becomes nan(snan)

After reading (readxl) and writing (writexl) a xlsx file with R, an empty entry changes to "nan(snan)". See attachment: Change from before reading and writing to after reading and writing I believe that I hadn't this problem before I updated to…
LKSari_2006
  • 11
  • 3
1
2 3