Writexl

R writexl package for writing Excel files. Use for creating .xlsx files without Java dependency.

LeoLin990405 Updated 6 repo stars
r-analytics-skill banner

File contents

writexl Package

Write Excel files without Java dependency.

Basic Usage

library(writexl)

# Single sheet
write_xlsx(df, "output.xlsx")

# Multiple sheets
write_xlsx(
  list(
    Sheet1 = df1,
    Sheet2 = df2,
    Results = df3
  ),
  "output.xlsx"
)

Options

write_xlsx(
  df,
  path = "output.xlsx",
  col_names = TRUE,    # Include headers
  format_headers = TRUE # Bold headers
)

With Pipes

library(dplyr)

mtcars %>%
  filter(mpg > 20) %>%
  write_xlsx("filtered.xlsx")

LeoLin990405/r-analytics-skill commit f8321dd32b

Frequently asked questions

npx get-skill add leolin990405/writexl