Skip to content

Latest commit

 

History

History
34 lines (25 loc) · 891 Bytes

readme.md

File metadata and controls

34 lines (25 loc) · 891 Bytes
Raw

Excel-Extraction

CircleCI

How to build

./gradlew build

Features

  • ExtractBySheet - create csv files by each sheets
  • ExcelQuery - prints cell data with like SQL
  • DumpData - prints all cell texts

How to execute

ExtractBySheet

./gradlew run -Pargs="-sheets 新宿,東京 -in ./data/sample1.xlsx -out ./out/data -divide 3"
or
java -cp build/libs/excel_extraction-1.0-SNAPSHOT.jar ExtractBySheet -sheets 新宿,東京 -in ./data/sample1.xlsx -out ./out/data -divide 3

ExcelQuery

java -cp build/libs/excel_extraction-1.0-SNAPSHOT.jar ExcelQuery "select 日付 from `./data/sample1.xlsx`.東京"

DumpData

java -cp build/libs/excel_extraction-1.0-SNAPSHOT.jar DumpData ./data/sample1.xlsx