OPERATOR / VERSION 1.0

piflow_excel_write_sort

PiFlow · Excel

Sort records on the selected columns and emit an XLSX byte stream with data written at the requested cell.

View manifest JSON ↗

Use this operator

operator: piflow_excel_write_sort@1.0

Configure remote_operator_library_urls with this repository’s origin. XStream verifies and caches artifacts by digest, sharing them across operators.

Named ports

  • sourceInputrecords

    Arrow records. The example uses sensor, value.

    Formats: Any compatible format
  • resultOutputbytes

    Bytes stream. Sort records on the selected columns and emit an XLSX byte stream with data written at the requested cell.

Output structure and samples are provided by operator inference.

Parameters

  • sortFieldstringRequired

    Comma-separated sort columns, in priority order.

    How to fill
    Comma-separated sort columns, in priority order.
    Example value
    sensor
  • sortOrderstringRequired

    Sort direction.

    How to fill
    Sort direction. · Allowed values: asc, desc
    Example value
    asc
  • headerbooleanRequired

    Write field names above the data.

    How to fill
    Write field names above the data.
    Example value
    true
  • dataAddressstringRequired

    Worksheet and starting cell.

    How to fill
    Worksheet and starting cell.
    Example value
    Readings!A1

Operator usage example

Connect the input ports to upstream steps and adjust the parameters for your data.

id: process
operator: piflow_excel_write_sort@1.0
inputs:
  source: read_source
params:
  sortField: sensor
  sortOrder: asc
  header: true
  dataAddress: Readings!A1

Manual download

curl -fLo 'operator.zip' 'https://repo.conox.cn/v1/blobs/sha256/0b6565aadaafe459b1d363957ca65462e6fc3a27bf2f42fc81ad724c4de34a0d/operator.zip'
sha256sum -- 'operator.zip'
curl -fLo 'LICENSE.txt' 'https://repo.conox.cn/v1/blobs/sha256/c71d239df91726fc519c6eb72d318ec65820627232b2f796219e87dcf35d0ab4/LICENSE.txt'
sha256sum -- 'LICENSE.txt'

Compare checksums with the manifest. Download execution and build environments from the runtime catalog ↗.

Source and licensing

See Source archive under Artifact details

Source repository
https://github.com/cas-bigdatalab/piflow
Source revision
db177aa6d9b84d91078caa9a591574b1fe3cf20c
License (publisher declared)
Apache-2.0
License text
Available below
Dependency SBOM
Dependency SBOM not provided

Build instructions

Build the Python SDK adapter in src/ with python-arrow@2.0. See job.yaml for an example using the supplied fixtures.

Publisher-provided source, licenses and dependency information support your review. Availability and checksums do not certify safety, legal clearance, or that the executable matches the source.