Write Specified Cell

Operation Name

Function Overview

Data Model

Properties

Basic settings

Required settings

Transaction

Item name	Required/Optional	Use of variables	Description	Remarks
Execute transaction processing	Optional	Not available	Select whether or not to execute transaction processing. [Checked]: Transaction processing will be executed. [Not checked]: (default) Transaction processing will not be executed. Refer to “Transaction of file category adapters” for more details.

Comment

Schema

Input schema

• When [Specify format/comment in Mapper to write] is not checked
  
  • It is table model type.
  • The number of columns vary depending on [Cell settings].
  • Refer to “Schema of table model type” for more details.
• When [Specify format/comment in Mapper to write] is checked
  
  • It is 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	-	Shows the value to be written in the cell.	Appears for each column set in [Cell settings].
    format	-	Shows the format/comment to be written in the cell.	In this element, input a string output from "Generate Excel Format" logic in Mapper. Overwriting the format selected in [Cell settings/Style], the format/comment output from “Generate Excel Format” logic will be written. The format/comment that is not output from “Generate Excel Format” logic will not be written. As for format that will be written, the format selected in [Cell settings/Style] will be used as is. When nothing is input, format/comment will not be written. The format selected in [Cell settings/Style] will be used as is.

Output schema

Loading schema in Mapper

Transaction

PSP Usage

Available Component Variables

Specification Limits

• When null is input in column element of input schema, the operation is as follows.
  • When [Specify format/comment in Mapper to write] is not checked
    • It will not be written.
  • When [Specify format/comment in Mapper to write] is checked
    • As the input schema is XML type, an empty string will be written to the cell.
• When input data has multiple rows, the data in the first row will be written.


• When writing a string type input data to a cell with “Date” format, use data formatted with the following date format or one specified in “xmlfw.daterenderingformat” property of system.properties.
  Refer to “Property Reference” for more details.
  
  

  Format	Example
  yyyy-MM-dd'T'HH:mm:ss.SSSZZ	2007-05-10T15:32:12.708+0900
  yyyy-MM-dd'T'HH:mm:ss.SSS	2007-05-10T15:32:12.708
  yyyy-MM-dd'T'HH:mm:ssZZ	2007-05-10T15:32:12+0900
  yyyy-MM-dd'T'HH:mm:ss	2007-05-10T15:32:12
  yyyy-MM-dd'T'HH:mm	2007-05-10T15:32
  yyyy-MM	2007-05
  yyyy/M/d K:m a	2007/5/10 3:32 PM
  yyyy/M/d H:m:s	2007/05/10 15:32:12
  yyyy/M/d H:m	2007/05/10 15:32
  yyyy/M/d	2007/05/10



• When [Use format of target cell] is selected in [Cell settings/Style] and the date format of destination cell is one of the following, the format will not be “Date” even if the data is written in date type.

  Type of date format	Example	Remarks
  [$-411]ge.m.d;@	h13.3.14
  [$-409]yyyy/m/d h:mm AM/PM;@	13/3/14 1:30 PM	When the destination cell contains any data, it can be written as date.

  Custom formats are not tested.


• Input data formatted in hours:minutes:seconds will be written as not “Date” but “General” format.


• After writing, cell format may be indeterminate.


• You cannot write data to an Excel file that is encrypted with a password.


• Writing to an Excel file with digital signature added is not supported.


• When writing to an Excel file with sheet protection set, data will be written, and if a password is set, the password will be maintained.


• When specifying [Background color] in "Generate Excel Format" logic, items in Fill tab other than background color will be set as default value.


• In an Excel 2003 workbook, when writing a number to a cell of “General” format, that number will be written as string and an error check will be displayed.
  Even in a cell of “Number” format, if the cell contains no value, an error check may be displayed.


• In an Excel 2003 workbook, when writing to a cell which contains no value, a value may be written with “Arial” font and “10” font size as the cell's font information cannot be acquired.
  In that case, you can write it using the font information of the destination cell by putting a value in the cell in advance.


• In an Excel 2003 workbook, when all of the following four conditions are satisfied, even if a format is specified with “Generate Excel Format” logic, it will not be reflected in the destination cell.
  • [Use format of target cell] is selected in [Cell settings/Style]
  • Comment is inserted to the destination cell
  • No value is contained in the destination cell
  • No format is set to the destination cell
• When writing to an Excel 2003 workbook, if a password to modify is set to the workbook, writing will be performed and the password will be deleted.


• When writing to an Excel 2003 workbook, the following formats of all cells in the file specified in [File] will be changed to the format of whole cell.
  • Font name
  • Font style
  • Font size
  • Underline
  • Font color
  • Effects


• When writing to an Excel 2003 workbook, the following settings of the file specified in [File] disappear.
  • Text box
  • Auto shape
  • Pivot table
  • Label
  • Group box
  • Check box
  • Option box
  • List box
  • Scroll bar
  • Spin button
  • Word art
  • Auto filter
  • Diagonal border specified in cell format
  • Tab color
  • Allow users to edit ranges
• When writing to an Excel 2003 workbook, when “Center across selection” is set to a cell in the file specified in [File], the format will be changed to “General”.


• When writing to an Excel workbook, if a password to modify is set to the workbook, writing will be performed and the password will be retained.


• When writing to an Excel workbook and if a number starting with “+” (plus symbol), it will be written as string and the workbook will be corrupted.

Major Exceptions

Notes

• When placing inside loop processing, refer to Notes of Loop by Number of Data.