Project

xlstocsv

0.0
Low commit activity in last 3 years
No release in over a year
Convert XLS files to CSV files
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 13.0.6

Runtime

~> 1.3.0
 Project Readme

xlstocsv

xlstocsv is a simple Ruby script which converts a given xls File to a set of csv files.

Usage

Usage: ruby xlstocsv.rb -f <inputfile> [options]
Reads an XLS file and converts every worksheet to a csv file

    -f filename                      Path to the XLS file
    -c col_sep                       Column separator. Defaults to ','
    -e encoding                      Output file encoding. Defaults to UTF-8
    -q quote_char                    Quote char. Defaults to an empty string
    -R, --remove-empty-rows          Removes empty rows
    -N, --remove-first-n-rows count  Removes the first N rows. Empty rows are included here
    -W sheet_index1,sheet_index2,    Only transforms the worksheets with the specific indexes starting at 0
        --only-specific-worksheets
    -h, --help                       Show this message

License

LICENSE