Name (case-insensitive) or zero-based index of sheet to export. Negative indices start from the end (-1 = last sheet). If the sheet cannot be found, qsv will read the first sheet.

Outputs workbook metadata in CSV or JSON format: index, sheet_name, headers, num_columns, num_rows, safe_headers, safe_headers_count, unsafe_headers, unsafe_headers_count and duplicate_headers_count. headers is a list of the first row which is presumed to be the header row. num_rows includes all rows, including the first row. safe_headers is a list of header with 'safe'(database-ready) names. unsafe_headers is a list of headers with 'unsafe' names. duplicate_headers_count is a count of duplicate header names. In CSV(c) mode, the output is in CSV format. In JSON(j) mode, the output is minified JSON. In Pretty JSON(J) mode, the output is pretty-printed JSON. For both JSON modes, the filename and spreadsheet format are also included. All other Excel options are ignored.

Continue even if the number of columns is different from the previous record.

Trim all fields so that leading & trailing whitespaces are removed. Also removes embedded linebreaks.

Optional date format to use when formatting dates. See https://docs.rs/chrono/latest/chrono/format/strftime/index.html for the full list of supported formats. Note that if a date format is invalid, qsv will fall back and return the date as if no date-format was specified.

An Excel format range, like C:T or C3:T25, to extract to the CSV.

The delimiter to use when writing CSV data. Must be a single character.