Write file xlsx in R without using Java
Can you use the WriteXLS
package?
WriteXLS(x, ExcelFileName = paste0(tempfile, ".xlsx"), SheetNames = NULL, row.names = FALSE, col.names = TRUE)
Edit:
If you're trying to save data to different sheets, turn your data into a list:
mySheets = c("data1", "data2")
BadZipFile: File is not a zip file - Error popped up all of a sudden
It is a very common issue and many people are trying to solve.It is related to excel file and openpyxl. Like @Barmar said in his comments xlsx, xlsm, etc are indeed zip. It was working fine until python 2.7 .
Try reading and writing to a csv instead, it won't be a problem.
Related Topics
Ggplot Aes_String Does Not Work Inside a Function
Clustering List for Hclust Function
More Efficient Means of Creating a Corpus and Dtm with 4M Rows
Select Unique Values with 'Select' Function in 'Dplyr' Library
Change the Index Number of a Dataframe
How to Convert Ensembl Id to Gene Symbol in R
How Does the Removesparseterms in R Work
Warning: Non-Integer #Successes in a Binomial Glm! (Survey Packages)
Dplyr::Select One Column and Output as Vector
Hyperlinking Text in a Ggplot2 Visualization
R Cmd Check Note: Found No Calls To: 'R_Registerroutines', 'R_Usedynamicsymbols'
Writings Functions (Procedures) for Data.Table Objects
Assign Headers Based on Existing Row in Dataframe in R
How to Install Multiple Packages