Skip to content

A simple Ruby script which allows converting XLS files to CSV files

License

Notifications You must be signed in to change notification settings

viafintech/xlstocsv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

A simple Ruby script which allows converting XLS files to CSV files

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages