fadeace / excelspliter Goto Github PK

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

release

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.