Create_Rows

When Create_Rows is selected in the General tab, the input for the activity is as follows.

Input Item Data Type Mode Description
FilePath String Basic and Advanced Enter the absolute path for the Excel file with double quotation marks, where the newly created rows are added.
Note: The FilePath is not displayed when Use Process Data check box is selected on the General tab.
processData Binary Basic and Advanced Get binary data on the Input tab when Use Process Data check box is selected on the General tab.

Available only when Use Process Data check box is selected on General tab.

SheetName String Basic and Advanced Enter the name of the sheet with double quotation marks, where the newly created rows are added.
Note: If the maximum length of the sheet name is more than 31 characters, the process can run successfully, and only the first 31 characters of the sheet name are used.
StartingRowPointer positive integer Advanced Enter the starting row index number, where one row or multiple rows start to be created.
Row None Basic and Advanced This node supports duplication.

You can right-click the SheetName node and click Duplicate to create multiple rows.

Cells None Basic and Advanced Set attributes for one or multiple cells under this node. This node supports duplication.

You can right-click the Cells node and click Duplicate to set attributes for multiple cells.

Value String Basic and Advanced Enter a value for the cell with double quotation marks.
IsFormulaCell Boolean Basic and Advanced Enter true() into this field if the cell contains Excel formula. Otherwise, enter false() into this field or leave this field blank.
TagName String Basic and Advanced Enter a tag name for the cell with double quotation marks. This tag name can be used for further operations, such as drawing charts or setting conditional formatting rules.
CellComments None Advanced Set attributes for cell comments under this node.
Value String Advanced Enter a value for the cell comment with double quotation marks.
FontStyle None Advanced Set font style for cell comments under this node.
FontName String Advanced Enter a font name for the cell comment with double quotation marks.
Note: The font name entered in this field must be supported by the Excel file.
StandardColor|RGBValues None Advanced Select StandardColor or RGBValues for cell comments.
Note: Before selecting StandardColor or RGBValues, complete the following steps:
  1. Drag SheetName|SheetPointer under the Sheet node in the XPath Expression view to the Data Source view. The Drop window opens.
  2. In the Drop window, select StandardColor or RGBValues from the list. Click Finish.
StandardColor String Advanced Enter the name of the color with double quotation marks, such as "GREEN". Select a standard color from the following list:
  • BLACK
  • BLUE
  • GRAY
  • GREEN
  • ORANGE
  • PINK
  • RED
  • WHITE
  • YELLOW
Note: The name of the color entered in this field must be supported by the Excel file.
RGBValues None Advanced Enter RGB values under this node. In the Red, Green, and Blue fields, enter an integer value within the range of 0 - 255 for each field.
FontSize Positive integer Advanced Enter a value for the font size of the cell comment.
Bold Boolean Advanced Enter true() into this field if the cell comment must be in bold. Otherwise, enter false() into this field or leave this field blank.
Italic Boolean Advanced Enter true() into this field if the cell comment must be in italic. Otherwise, enter false() into this field or leave this field blank.
StrikeThrough Boolean Advanced Enter true() into this field if the cell comment must be struck through. Otherwise, enter false() into this field or leave this field blank.
Underline String Advanced Enter an underline type with quotation marks, such as "U_SINGLE". Select an underline type from the following list:
  • U_DOUBLE
  • U_DOUBLEACCOUNTING
  • U_NONE
  • U_SINGLE
  • U_SINGLEACCOUNTING
Note: The underline type entered in this field must be supported by the Excel file.
CellStyle None Advanced Set attributes for cell style under this node. Refer to attributes setting in the fields under the CellComments node.
Alignment String Advanced Enter an alignment type with double quotation marks, such as "ALIGN_LEFT". Select an alignment type from the following list:
  • ALIGN_CENTER
  • ALIGN_CENTER_SELECTION
  • ALIGN_FILL
  • ALIGN_GENERAL
  • ALIGN_JUSTIFY
  • ALIGN_LEFT
  • ALIGN_RIGHT
Note: The alignment type entered in this field must be supported by the Excel file.
BackgroundColor None Advanced Set background color for cells under this node.
FillPattern String Advanced Enter a fill pattern type with double quotation marks, such as "FINE_DOTS". Select a fill pattern type from the following list:
  • BIG_SPOTS
  • BRICKS
  • DIAMONDS
  • FINE_DOTS
  • NO_FILL
  • SOLID_FOREGROUND
  • SPARSE_DOTS
  • SQUARES
  • THICK_BACKWARD_DIAG
  • THICK_FORWARD_DIAG
  • THICK_HORZ_BANDS
  • THICK_VERT_BANDS
  • THIN_BACKWARD_DIAG
  • THIN_FORWARD_DIAG
  • THIN_HORZ_BANDS
  • THIN_VERT_BANDS
Note: The fill pattern type entered in this field must be supported by the Excel file.
WrapText Boolean Advanced Enter true() into this field if the cell value must be text wrapped. Otherwise, enter false() into this field or leave this field blank.
Chart None Advanced This node supports duplication.

You can right-click the Chart node and click Duplicate to create charts.

ChartLocation None Advanced Specify the location for the chart under this node.
FirstCellColumn Positive integer Advanced Enter a numeral that indicates the column location for the first cell that the chart is drawn upon.
FirstCellRow Positive integer Advanced Enter a numeral that indicates the row location for the first cell that the chart is drawn upon.
SecondCellColumn Positive integer Advanced Enter a numeral that indicates the column location for the second cell that the chart is drawn upon.
SecondCellRow Positive integer Advanced Enter a numeral that indicates the row location for the second cell that the chart is drawn upon.
ChartDataSourceCellRangeAddress None Advanced Specify the start and end cell addresses of the required data for drawing the chart under this node.
Note:
  • The horizontal axis is plotted by the cell values in the first column of the required data area.
  • The cell values in the first row of the required data area serve as the legend names, which are displayed in the legend area of the chart.
  • If each cell in the selected data area is filled with a value, the first cell value is not taken when you draw a chart.
StartTag String Advanced Enter the start tag name of the required data source for drawing the chart, or enter the start cell address of the required data source for drawing the chart with double quotation marks, such as "A1".
EndTag String Advanced Enter the end tag name of the required data source for drawing the chart, or enter the end cell address of the required data source for drawing the chart with double quotation marks, such as "D5".
ConditionalFormattingRules None Advanced Set conditional formatting rules for cells under this node. This node supports duplication.

You can right-click the ConditionalFormattingRules node and click Duplicate to set conditional formatting rules for cells in multiple areas.

Condition None Advanced Set conditions for cells that are applied with conditional formatting rules under this node.
Comparator String Advanced Enter a comparator value with double quotation marks, such as "LT", which means less than. Select a comparator type from the following list:
  • BETWEEN
  • EQUAL
  • GE
  • GT
  • LE
  • LT
  • NO_COMPARISON
  • NOT_BETWEEN
  • NOT_EQUAL
Note: The comparator value entered in this field decides the values in the Operand1 and Operand2 fields.
Operand1 String Advanced Enter a proper operand value in this field.
Operand2 String Advanced Enter a proper operand value in this field.
FontFormat None Advanced Set font format for the cells within the specified cell range under this node.
Italic Boolean Advanced Enter true() into this field if the cell comment must be in italic. Otherwise, enter false() into this field.
Bold Boolean Advanced Enter true() into this field if the cell comment must be in bold. Otherwise, enter false() into this field.
StandardColor String Advanced Enter the name of the color with double quotation marks, such as "GREEN". Select a standard color from the following list:
  • BLACK
  • BLUE
  • GRAY
  • GREEN
  • ORANGE
  • PINK
  • RED
  • WHITE
  • YELLOW
Note: The name of the color entered in this field must be supported by the Excel file.
Underline String Advanced Enter an underline type with double quotation marks, such as "U_SINGLE". Select an underline type from the following list:
  • U_DOUBLE
  • U_NONE
  • U_SINGLE
Note: The underline type entered in this field must be supported by the Excel file.
PatternFormat None Advanced Set pattern format for the cells within the specified cell range under this node.
BackgroundColor String Advanced Enter the name of the color with double quotation marks, such as "GREEN". Select a background color from the following list:
  • BLACK
  • BLUE
  • GRAY
  • GREEN
  • ORANGE
  • PINK
  • RED
  • WHITE
  • YELLOW
Note: The name of the color entered in this field must be supported by the Excel file.
FillPattern String Advanced Enter a fill pattern type with double quotation marks, such as "FINE_DOTS".
  • BIG_SPOTS
  • BRICKS
  • DIAMONDS
  • FINE_DOTS
  • SOLID_FOREGROUND
  • SPARSE_DOTS
  • SQUARES
  • THICK_BACKWARD_DIAG
  • THICK_FORWARD_DIAG
  • THICK_HORZ_BANDS
  • THICK_VERT_BANDS
  • THIN_BACKWARD_DIAG
  • THIN_FORWARD_DIAG
  • THIN_HORZ_BANDS
  • THIN_VERT_BANDS
Note: The fill pattern type entered in this field must be supported by the Excel file.
CellRange None Advanced Set the cell range that the conditional formatting rules applies to. This node supports duplication.

You can right-click the CellRange node and click Duplicate to set conditional formatting rules in multiple areas.

StartTag String Advanced Enter the start tag name for the specified cell range, or enter the start cell address for the specified cell range with double quotation marks, such as "A1".
EndTag String Advanced Enter the end tag name for the specified cell range, or enter the end cell address for the specified cell range with quotation marks, such as "D5".