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.
cd EXCELspliter
go get
go build
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
-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.
-h : for help with command line params
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.