bulkreadr (version 1.2.0)

write_excel_sheets_to_csv: Export Excel Sheets to CSV Files

Description

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/")

Value

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

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/".

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)