Skip to content

mentax/csv2xlsx

Repository files navigation

goreleaser test GoDoc codebeat badge Go Report Card GitHub release

csv 2 xlsx

HELP

An actual version always available by run csv2xlsx -h or csv2xlsx help

NAME:

csv2xlsx - Convert CSV data to xlsx - especially the big one.

Speed:

csv with 50k rows, 5 MB, with xlsx template - 5s

(On MacBook Pro 2016)

Benchmark:

To compare speed between builds you can use:

go test -bench=. -tags=benchmark

Example:

csv2xlsx --template example/template.xlsx --sheet Sheet_1 --sheet Sheet_2 --row 2 --output result.xlsx data.csv data2.csv
csv2xlsx.exe -t example/template.xlsx -s Sheet_1 -s Sheet_2 -r 2 -o result.xlsx data.csv data2.csv

USAGE:

csv2xlsx [global options] command [command options] [file of file's list with csv data]

GLOBAL OPTIONS:

 --sheets names, -s names [ --sheets names, -s names ]  sheet names in the same order like csv files. If sheet with that name exists, data is inserted to this sheet. Usage: -s AA -s BB
 --template path, -t path                               path to xlsx file with template file
 --delimiter letter, -d letter                          one letter delimiter used in csv file (default: ",")
 --exampleRow number, -r number                         exampleRow number to use for create rows format. When '0' - not used. This exampleRow will be overwrite in result file. (default: 0)
 --startFrom number, --sf number                        startFrom number decide which row is used as first row from csv file. Counting from 0. (default: 0)
 --output xlsx file, -o xlsx file                       path to result xlsx file (default: "./output.xlsx")
 --use-cache                                            enable disk-based storage for large files to limit memory usage
 --help, -h                                             show help
 --version, -v                                          print the version

Download

Download from releases section on GitHub

About

Fast and simple opensource command line tool to convert CSV do XLSX

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Contributors 5