Filter:
Submit Search

Write Specified Cell

Operation name

Write Specified Cell

Function overview

Writes input data to specified cells of an Excel file.

Data model

The data model of this component is table model type.

If Specify format/comment in Mapper to write is selected, it's XML type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name

Required/Optional

Use of variables

Description

Remarks

Name

Required

Not available

Enter a name that is used on the script canvas.

 

Input data

Required

Not available

Select a component on the script canvas.

 

Required settings

Item name

Required/Optional

Use of variables

Description

Remarks

File

Required

Available

Enter the Excel file path.

The Browse button launches a file chooser that allows you to select a file.

  • A file with ".xlsx" or ".xlsm" extension is processed as an Excel workbook, and a file with other extensions is processed as an Excel 2003 workbook.

Note

Cell settings

Optional

-

Specify cells to be written to.

Each row can be operated with the following buttons:

Up

Moves the selected row upward by one row.

Down

Moves the selected row downward by one row.

Add

Adds a row.

Delete

Deletes the row.

 

Cell settings/Sheet name

Required

Available

Select or enter a sheet of the Excel file specified in File.

  • When a sheet name that doesn't exist is entered, the sheet will be created at the beginning of the workbook.

  • Case-insensitive.

Cell settings/Cell address

Required

Available

Enter the cell address to be written to.

Example: A1

 

Cell settings/Cell name

Optional

Available

Enter a cell name for each cell.

  • Values set in Cell name will be displayed in Mapper schema. It won't be used when writing data.

Cell settings/Style

Required

Not available

Select whether or not to write type/format information.

Specify format

Write the specified type/format information.

Use format of target cell

(Default)

Write data using the type/format information of the cell to be written.

  • When Use format of target cell is selected, the type/format information set in Cell settings/Type and Cell settings/Format won't be used.

Cell settings/Type

Required

Not available

Select a type of cell to be written to.

General

(Default)

Text
Number
Date

 

Cell settings/Format

Optional

Available

Select or enter a format for each type.

Symbol

Meaning

Available type

Example

yyyy

1900-9999 (A.D.)

Date

2005

yy

00-99 (A.D.)

Date

05

m

1-12 (numeric representation of month)

Date

1

mm

01-12 (numeric representation of month)

Date

01

mmm

Jan-Dec (abbreviated month)

Date

Jan

mmmm

January-December (month)

Date

January

mmmmm

J-D (the first letter of month)

Date

J

d

1-31 (date)

Date

1

dd

01-31 (date)

Date

01

ddd

Sun-Sat (abbreviated day of week)

Date

Mon

dddd

Sunday-Saturday (day of week)

Date

Monday

h

Hour (1-12)

Date

1

hh

Hour (0-23)

Date

01

h:m

Minutes

Date

1:1

h:mm

Minutes

Date

1:01

h:mm:s

Seconds

Date

1:01:1

h:mm:ss

Seconds

Date

1:01:01

#,##0

Currency

Number

123,0

0%

Percentage

Number

50%

#

Display only the significant digits

Number
Format

##.##

Input value

12.345

Output value

12.35

0

Display only the specified number of digits, and if the value has fewer than the specified number of digits, fill the remainder with 0

Number
Format

000.00

Input value

12.345

Output value

012.35

 

Specify format/comment in Mapper to write

Optional

Not available

Select whether or not to set elements for writing format/comment in the input schema.

Selected

Elements to write format/comment are set in the input schema.

Not selected

(Default)

Elements to write format/comment aren't set in the input schema.

  • When this field is selected, the input schema will be in XML type.

  • For details, refer to Input schema.

Transaction

Item name

Required/Optional

Use of variables

Description

Remarks

Execute transaction processing

Optional

Not available

Select whether or not to execute transaction processing.

Selected

Transaction processing will be executed.

Not selected

(Default)

Transaction processing won't be executed.

= Remarks =

For details, refer to Transactions for the connectors in the File category.

Comment

Item name

Required/Optional

Use of variables

Description

Remarks

Comment

Optional

Not available

You can write a short description of this connector.

 

Schemas

Input schema

  • When Specify format/comment in Mapper to write isn't selected

    It's table model type.

    The number of columns varies depending on the settings for Cell settings.

    = Remarks =

    For schema structure, refer to Table model type .

  • When Specify format/comment in Mapper to write is selected

    It's XML type.

    The schema structure is as follows:

    <?xml version="1.0" encoding="UTF-8"?>
<table>
  <row>
    <column>
      <format></format>
    </column>
    <column>
      <format></format>
    </column>
       :
  </row>
</table>

    Element name

    Attribute name

    Description

    Remarks

    table

    -

     

     

    row

    -

     

     

    column

    -

    Represents the value to be written in the cell.

    • Appears once for each row set in Cell settings.

    format

    -

    Represents the format/comment to be written in the cell.

    • In this element, enter a string that is output from "Generate Excel Format" logic in Mapper.

      • The format selected in Cell settings/Style is overwritten with the format/comment output from "Generate Excel Format" logic.

      • Only the format/comment that is output from "Generate Excel Format" logic will be written. When format isn't written, the format selected in Cell settings/Style will be used as is.

      • When nothing is input, format/comment won't be written. The format selected in Cell settings/Style will be used as is.

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Transaction

Transaction is supported.

 

Transaction is enabled only when Execute transaction processing of Transaction is selected.

Parallel Stream Processing

PSP isn't supported.

Available component variables

Component variable name

Description

Remarks

message_category

When an error occurs, the category of the message code corresponding to the error is stored.

  • The default value is null.

message_code

When an error occurs, the code of the message code corresponding to the error is stored.

  • The default value is null.

message_level

When an error occurs, the severity of the message code corresponding to the error is stored.

  • The default value is null.

error_type

When an error occurs, the error type is stored.

  • The default value is null.

  • The format of the error type is as follows.

    Example: java.io.FileNotFoundException

error_message

When an error occurs, the error message is stored.

  • The default value is null.

error_trace

When an error occurs, the trace information for the error is stored.

  • The default value is null.

Message codes, exception messages, and limitations

Connector

Message code

Exception message

Limitations

Messages and limitations of the Excel connector

check

check

check

Policies     (c) Saison Technology Co.,Ltd. 2021

TOP