Mac系统下用R的openxlsx生成的xlsx文件无法用Numbers打开求助

Hey there! Let's troubleshoot why your Numbers app is throwing that "invalid format" error for the xlsx file your R code creates. I've got a few targeted fixes to try, starting with the most likely culprit:

1. Fix the Quotation Marks in Your Code #

First, I noticed you're using Chinese curly quotation marks (“”) around your filename instead of English straight quotes (""). R doesn't recognize these non-standard quotes, which can corrupt the file save process or create a file with an invalid name that Numbers can't parse.

Update your code to use English quotes:

rm(list=ls())
library(openxlsx)
fn <- "RTest.xlsx"  # Changed to straight quotes
wb <- createWorkbook()
HomeSheet = addWorksheet(wb, "Home")  # Ensured quotes here are standard too
writeData(wb, HomeSheet, "R Test", startCol = 2, startRow = 2)
saveWorkbook(wb, fn, overwrite = TRUE)

2. Save to a Fully Specified Path #

Sometimes Mac's file permissions or default working directory can cause hidden access issues. Try saving the file to a location you know Numbers can access (like your Desktop) with a full, explicit path:

# Replace [Your Mac Username] with your actual username (e.g., "johnsmith")
fn <- "/Users/[Your Mac Username]/Desktop/RTest.xlsx"

3. Try the xlsx Package Instead #

While openxlsx is lightweight and fast, Numbers can be picky about certain xlsx formatting nuances. The xlsx package uses Java-based Excel generation, which sometimes has better compatibility with Apple's apps. Here's a modified version of your code using xlsx:

rm(list=ls())
install.packages("xlsx")  # Run this once if you haven't installed the package
library(xlsx)
fn <- "RTest.xlsx"
wb <- createWorkbook()
sheet <- createSheet(wb, sheetName = "Home")
# Write "R Test" to row 2, column 2
target_row <- createRow(sheet, rowIndex = 2)
target_cell <- createCell(target_row, colIndex = 2)[[1,1]]
setCellValue(target_cell, "R Test")
saveWorkbook(wb, fn)

4. Verify the File Isn't Corrupted #

If the above steps don't work, check if the file is actually valid:

• Try opening it in Microsoft Excel (if you have access) — if Excel can open it, the issue is likely Numbers-specific compatibility.
• In Terminal, run the command file RTest.xlsx — a valid xlsx file should show output like Excel 2007+. If it shows something generic like "data", the file was corrupted during saving.

Give these steps a try, starting with fixing the quotation marks — that's the most common issue here!

内容的提问来源于stack exchange，提问作者Prince Modi