About Excel POI Adapter

Excel POI Adapter is an adapter that uses Apache POI to process Excel files.

Compare Function

The following table compares the functions of the Excel POI Adapter with the functions of the existing Excel Adapter.

Excel Adapter Excel POI Adapter
Write
  • The adapter can write to xls files
  • The adapter can use Excel wizards
 Write Sheet
  • Columns can be specified in R1C1 format
  • "Time" and "Boolean" can be specified as types
  • The write start condition can be specified in detail
  • The position where you would like to add a sheet can be specified
  • If this operation is placed within a loop operation, you can prevent performance deterioration and allow high speed processing by enclosing the operation in a transaction
Write Specified Cell
  • The adapter can write to xls files
 Write Specified Cell
  • Cell addresses can be specified in R1C1 format
  • "Time" and "Boolean" can be specified as types
  • The position where you would like to add a sheet can be specified
  • If this operation is placed within a loop operation, you can prevent performance deterioration and allow high speed processing by enclosing the operation in a transaction