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 to perform transaction processing. [Checked]: Perform Transaction processing. [Not Checked]: (default) Do not perform transaction processing. Refer "File Type adapter transaction" for more information.

Comment

Schema

Input Schema

• If [Specify format/comment in Mapper to write] has not been checked
  
  • Will be table model type.
  • Depending on [Cell settings] setting, number of columns differs.
  • For schema structure, refer to "Table Model Type Schema".
• If [Specify format/comment in Mapper to write] is checked
  
  • Will be XML type.
  • For schema structure, it 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 write to the cell.	Appears per columns which is set at [Cell settings].
    format	-	Shows the formats/comments writing to the cell.	For this element, input the string which was output from "Generate Excel Format" logic in Mapper. In the form of overwriting the formats selected in [Cell settings / Format], the formats/comments output from "Generate Excel Format" logic will be written. The formats/comments that are not output from "Generate Excel Format" logic will not be written. For the unwritten formats, the formats selected at [Cell settings / Format] will be used as they are. If nothing is input, the format selected at[Cell settings / Format] will be used as it is.

Output Schema

Loading schema in Mapper

Transaction

PSP Usage

Available Component variables

Specification Limits

• The operations when null is input to the column elements of input schema are as follows.
  • If [Specify format/comment in Mapper to write] is not checked
    
    • Will not operate writing.
  • If [Specify format/comment in Mapper to write] is checked
    
    • Since input schema is the XML type, will operate writing with writing an empty string to the cell.
• If there are multiple rows to be input, only the first row is written to the target.


• When entering data in cell date format string, or following the date format, [xmlfw.daterenderingformat] system.properties only data that is formatted with the specified date format property.
  For system.properties information, refer to "Property reference"
  
  

  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



• [Cell settings / Style] menu to [Use format to the cell for writing] When that is selected, if the following format of the cells to be written will be written as a date format of the data type of date can.

  The 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	If the cell contains data to be written can be written as a date.

  The user-defined formats and unverified.


• HMS if the input value is written in the General be set at a Date column list.


• After the write operation may be written without the final format of the cells.


• Numeric data written to the cells with their display types set to standard becomes string irrespectively and error check is displayed.
  Error check is also displayed when there is no value found in the target cell whose display type is set to numeric.


• When writing is not in the cell, the cell can not get the font information, font "Arial" , font size "10" may be written.
  In this case, can you put a value to be written to a cell, can be written using the font information to be written to cells.


• If fulfills all following conditions at Excel 2003 book, no formats will be reflected to target cell even if it is specified at "Generate Excel Format" logic.
  • [Use format of the cell for writing] is selected at [Cell settings / Format]
  • Comment is inserted to the writing cell
  • Value is not set to the writing cell
  • No format is set to the writing cell


• You cannot write data to Excel file which is encrypted with password.


• Password set for the workbook will be removed.


• Writing data to an Excel file with digital signatures is not supported.


• If you write to an Excel file to which sheet protection is set, the writing will be done. Then, if password is set the password will be retained.


• If you specify [Background color] in "Generate Excel format" logic, items in Fill other than background color will be set to default value.


• Excel 2003 When writing a book, workbook and write operation to write the password is set, the password is written will be deleted.


• If you write to an Excel 2003 book, the following formats will be set to the formats of the whole cells for all cells of the file entered in [File].
  • Font Name
  • Font Style
  • Font Size
  • Underline
  • Font Color
  • Effects
• The followings items in [File] will be removed from the Excel 2003 workbook to which data is written by this operation.
  • TextBox
  • AutoShape
  • PivotTable
  • Label
  • GroupBox
  • CheckBox
  • OptionButton
  • ListBox
  • ScrollBar
  • SpinButton
  • WordArt
  • AutoFilter
  • Slash specified in the formatting
  • Tab Color
  • Allow Users to Edit Ranges
• When writing into Excel 2003 book, if "center in selected range" is setup to the cell in the file specified in [File], view format upon writing will change to "standard".


• When writing into Excel book, if you execute wite process to a book with write password setup, write will be executed and the password will be saved.


• When executing write process to Excel book, if writing numeric value with "+" in the front, the book witten as character string will be damaged

Main exceptions

Notes

• Refer to "Notes of Loop by Number of Data" for the case of placed in loop.