[Variable Mapper]Generate Excel format

Logic Name

Generate Excel format

Function

Generates and outputs Excel format/comment.

Data Types

Location	Type
Logic output	String

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
font	font name	Outputs selected string as font name. If blank, font name will not be output.
font	style	outputs selected style.
font	size	Outputs size set. Valid values are whole numbers from 1 to 409.
font	underline	outputs selected underline.
font	struck-through	Outputs selected struck-through.
font	Wword decoration	Outputs word decoration selected.
font	color	Outputs selected color
border	left	Outputs selected border at the left of the cell.
border	right	Outputs selected border at the right of the cell.
border	top	Outputs selected border at the top of the cell.
border	bottom	Outputs selected border at the bottom of the cell.
fill	background color	Outputs selected background color.
Alignment	Horizontal	Outputs the selected horizontal alignment.
Alignment	Indent	Outputs the indent. An integer of 0-250 is available. However, values of 1- is available only if [Left (Indent)] or [Right (Indent)] is selected in [Horizontal].
Alignment	Vertical	Outputs the selected vertical alignment.
cell comment	Cell comment	Outputs selected string as cell comment. If blank, cell comment will not be output.
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Specification Limits

On Studio for Web you can enter an invalid value ouf of 1-409 in [Size] and save it.
Also if you use script variables you can set an invalid value consequently, because the system cannot check the values input at execution time when you save the property.
In that case the default value 10 is output at execution time.

When you select "None" in [Background color] nothing is output. "No Color" as background color in Fill is not output.

When you write data to an Excel 2003 workbook with Excel adapter, "15" is the maximum value available for [Indent].
If you specify a value greater than or equal to 16, runtime error occurs.

If you use a script variable at [Indent] you can set an invalid value consequently, because the system cannot check the values input at execution time when you save the property.
In that case the default value 0 is output at execution time.

Logic Sample

Mapping Definition

Place Write operation or Write Specified Cell operaion as [Output Target], check [Specify format/comment in Mapper to write] and map to a format element of the input schema.

Logic Settings and Processing Result

Outputs data for mapping to format elements of Excel adapter.

Even though you can see the output data is string type, the format of data is internal specification and not published. Please map it as is, without modification, to format elements as described.

Property Settings

Property	Setting
Font/Font	Arial Black
Font/Style	Italic
Font/Size	16
Font/Underline	Double Underline
Font/Strikethrough	Exists
Font/Effect	None
Font/Color	OCEAN_BLUE
Border/Left
Border/Right
Border/Top
Border/Bottom
Fill/Background color	IVORY
Cell comment/Cell comment	example of comment