piflow_excel_write_sort
PiFlow · ExcelSort records on the selected columns and emit an XLSX byte stream with data written at the requested cell.
Use this operator
operator: piflow_excel_write_sort@1.0Configure 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.