Generate Excel Format

Logic name

Generate Excel Format (Document Mapper/Variable Mapper)

Function

This logic generates and outputs Excel format/comment.

Data types

Location	Type
Logic output	String

= Hint =

For details, refer to Logic specifications (Document Mapper/Variable Mapper).

Properties

Category	Property	Description
font	font name	Outputs the specified strings as a font name. If this item is blank, a font name isn't output.
font	style	Outputs the selected style.
font	size	Outputs the specified size. An integer of 1 to 409 is available.
font	underline	Outputs the selected underline.
font	Strikethrough	Outputs the selected struck-through.
font	Effect	Outputs the selected word decoration.
font	color	Outputs the selected color.
border	left	Outputs the selected border at the left of the cell.
border	right	Outputs the selected border at the right of the cell.
border	top	Outputs the selected border at the top of the cell.
border	bottom	Outputs the selected border at the bottom of the cell.
fill	background color	Outputs the selected background color.
Alignment	Horizontal	Outputs the selected horizontal alignment.
Alignment	Indent	Outputs the specified indent. An integer of 0-250 is available. However, a value of 1 or larger 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 strings as a cell comment. If this item is blank, a cell comment isn't output.
Comment	Comment	You can write a description of the logic. It doesn't affect the conversion process.

Specification limits

You can enter an invalid value other than an integer 1 to 409 in Size and save it.

Also if you use a script variable, you can set an invalid value consequently, because the system can't check the value assigned at execution time when you save the property.

In that case the default value 10 is output at execution time.
When you select "(Not output)" in Background color, nothing is output. "No Color" isn't output as a background color for filling.
When you write data to an Excel 2003 workbook with Excel Connector, "15" is the maximum value available for Indent.

If you specify a value of 16 or higher, a runtime error occurs.
If you use a script variable at Indent you can set an invalid value consequently, because the system can't check the value assigned 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 the Write operation or the Write Specified Cell operation of Excel Connector as Output Target, check Specify format/comment in Mapper to write and map it to a format element of the input schema.

Logic settings and processing result

This logic outputs data for mapping to the format element of Excel Connector.

Note

Although the output data is the string type, the format of data is an internal specification and not published. Map it as is, without modification, to the format element 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
Alignment/Horizontal	Right (Indent)
Alignment/Indent	1
Alignment/Vertical	Center
Cell comment/Cell comment	example of comment

Output data (in the case of writing to an Excel 2010/2007 workbook and viewing with Excel 2010)

= Hint =

For a list of logics, refer to Mapper Logic Guide.