Converts xls(x) to csv using VB

Share:

Description

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

Usage

1
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: http://stackoverflow.com/questions/1858195/convert-xls-to-csv-on-command-line

Examples

1
2
3
4
5
6
## Not run: 

xlsx2csv("c:/some_file.xlsx")


## End(Not run)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.