xlsx2csv: Converts xls(x) to csv using VB

In installr: Using R to Install Stuff on Windows OS (Such As: R, 'Rtools', 'RStudio', 'Git', and More!)

Converts xls(x) to csv using VB

Description

Converts xls(x) to csv using VB script. Not that important now that we have the readxl package.

Usage

xlsx2csv(xlsx, csv, path, ...)

Arguments

xlsx	the (character) name of the xlsx (or xls) file to convert. if xlsx has a full path, it will override the path parameter.
csv	the (character) name of the csv file to convert to (default will be the name of the xlsx file)
path	the path for the files (default is the working directory).
...	ignored.

Source

This is based on the code from plang's answer here: https://stackoverflow.com/questions/1858195/convert-xls-to-csv-on-command-line

Examples

## Not run: 

xlsx2csv("c:/some_file.xlsx")


## End(Not run)

installr documentation built on Nov. 13, 2022, 1:06 a.m.