%csv2xlsx(1) user manual | version 1.2.12 03b4ff7 % R. S. Doiel % 2024-11-14

NAME

csv2xlsx

SYNOPSIS

csv2xlsx [OPTIONS] WORKBOOK_NAME SHEET_NAME

csv2xlsx will take CSV input and create a new sheet in an Excel Workbook. If the Workbook does not exist then it is created.

-help : display help

-license : display license

-version : display version

-d, -delimiter : set delimiter character (input)

-i, -input : input filename (CSV content)

-o, -output : output filename

-quiet : suppress error messages

-sheet : Sheet name to create/replace

-trim-leading-space : trim leading space in field(s) for CSV input

-use-lazy-quotes : use lazy quotes for CSV input

-workbook : Workbook name

Converting a csv to a workbook.

	csv2xlsx -i data.csv MyWorkbook.xlsx 'My worksheet 1'

This creates a new 'My worksheet 1' in the Excel Workbook called 'MyWorkbook.xlsx' with the contents of data.csv.

	cat data.csv | csv2xlsx MyWorkbook.xlsx 'My worksheet 2'

This does the same but the contents of data.csv are piped into the workbook's 'My worksheet 2' sheet.

csv2xlsx 1.2.12