Skip to contents

Export Excel Sheets to CSV Files

Source: R/write_excel_sheets_to_csv.R
write_excel_sheets_to_csv.Rd

This function reads an Excel file, converts each sheet into a data frame, and writes each sheet to a CSV file in the specified output directory.

Usage

write_excel_sheets_to_csv(excel_path, output_dir = "data/")

Arguments

excel_path

A character string specifying the path to the Excel file.

output_dir

A character string specifying the directory where CSV files will be saved. Defaults to "data/".

Value

A list of file paths corresponding to the exported CSV files.

Examples

# Path to the example Excel file shipped with the package
excel_file <- system.file("extdata", "Diamonds.xlsx", package = "bulkreadr")

# Export each sheet to its own CSV in a temporary directory
output_dir <- tempdir()
write_excel_sheets_to_csv(excel_file, output_dir)
#> Exported CSV file paths are:
#>   /tmp/RtmpojSkW1/Fair.csv
#>   /tmp/RtmpojSkW1/Good.csv
#>   /tmp/RtmpojSkW1/Very Good.csv
#>   /tmp/RtmpojSkW1/Premium.csv
#>   /tmp/RtmpojSkW1/Ideal.csv