EN documentation | 中文文档

EXECELspliter is a tool for excelees to make a split of document easily . if you are interested in source code , you can build one and modify it for features add-on you want it to be , then read build from source underlying.

typical scenario : you have a '.xlsx' file with 1 million lines and you want it to be split to ones limited to 250 lines , and each sheet into a single file , moreover , each one owns the same header line whitch usually been a type definition ,then , choose EXCELspliter is a simple solution.

build from source:

build execution file:

cd EXCELspliter
go get
go build

run from source:

ls
LICENSE  README.md  spliter.exe*  spliter.go  writer_test.go

there is an execution file spliter.exe , remember do not run it directly , you should open console (win + X) or cmd.exe then cd to EXCELspliter and make a command like underlying

an example for you to tap'in CLI :

spliter.exe -p=./lzy.xlsx -head -l=10 -s=1

params to control splitting:

-head : (optional) Whether to keep head for this file when processing splitting.

-p : path for given xlsx file to split from.

-l : length for a splitting.

-s : what sheet you want to split at.

-t : where the output files targeting at.

for more details with CLI params:

-h : for help with command line params

get executable file:

release

advanced usage & config file:

for advanced usage and versatile functions , you may get it from -h console print helper , which shows a series functions that should be configured in yaml file.