Learn R Programming

installr (version 0.17.5)

xlsx2csv: 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 diractory).
...
ignored.

source

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

Examples

Run this code
xlsx2csv("c:/some_file.xlsx")

Run the code above in your browser using DataLab