Apache POI Excel formatter plugin for Embulk
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
gradle/wrapper
lib/embulk/formatter
src
.gitignore
LICENSE.txt
README.md
build.gradle
gradlew
gradlew.bat

README.md

Apache POI Excel formatter plugin for Embulk

Formats Excel files(xls, xlsx) for other file output plugins.
This plugin uses Apache POI.

Overview

  • Plugin type: formatter

Configuration

  • spread_sheet_version: Excel file version. EXCEL97 or EXCEL2007. (string, default: EXCEL2007)
  • sheet_name: sheet name. (string, default: Sheet1)
  • column_options: see bellow. (hash, default: {})

column_options

  • data_format: data format of Cell. (string, default: null)

Example

in:
  type: any input plugin type
...
    columns:
    - {name: time,     type: timestamp}
    - {name: purchase, type: timestamp}

out:
  type: file	# any file output plugin type
  path_prefix: /tmp/embulk-example/excel-out/sample_
  file_ext: xls
  formatter:
    type: poi_excel
    spread_sheet_version: EXCEL97
    sheet_name: Sheet1
    column_options:
      time:     {data_format: "yyyy/mm/dd hh:mm:ss"}
      purchase: {data_format: "yyyy/mm/dd"}

Note

The file name, file split or data order are decided by input/output plugin.
If you'd like to process data and output Excel format, I think it's also one way to use Asakusa Framework (Excel Exporter).

Install

$ embulk gem install embulk-formatter-poi_excel

Build

$ ./gradlew package