R openxlsx export NA as empty preserving numeric — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited R openxlsx export NA as empty preserving numeric (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Export R data frames to Excel using openxlsx ensuring NA values appear as empty cells while preserving numeric data types.
Assist the user in exporting R data frames to Excel using the openxlsx package.
"") directly in the data frame (e.g., using df[is.na(df)] <- "" or mutate_all with "") as this coerces numeric columns to character.dplyr package.df[is.na(df)] <- "".mutate_all(~ ifelse(is.na(.), "", .)) if it results in type coercion.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.