No release in over 3 years
Low commit activity in last 3 years
Formats Excel files(xls, xlsx) for other file output plugins.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

~> 1.0
>= 10.0
 Project Readme

Apache POI Excel formatter plugin for Embulk

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

Overview

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