General

In the General tab, you can select different actions to complete different tasks.

The following table describes the items in the General tab of the ExcelData activity.
Item Description
Name The name of the activity displayed in the process. The default value is ExcelData.
Actions You can select the following actions:
  • Create_Sheets
  • Delete_Sheets
  • Create_Rows
  • Delete_Rows
  • Read_Rows
  • Update_Rows
Use Process Data Select to accept the binary data on the Input tab.
Modes You can select the following modes:
  • Basic

    You can use Basic mode to complete basic functions of the ExcelData activity.

  • Advanced

    You can use Advanced mode to complete basic and advanced functions of the ExcelData activity.

Available only when the Create_Rows, Read_Rows, or Update_Rows action is selected.
Create New File Select the check box if you want to create a new Excel file. Available only when the Create_Sheets, or Create_Rows action is selected.
Choose Output Directory Choose the output directory for the newly created Excel file by clicking the Choose a resource icon. Available only when the Create New File check box is selected.
Output File Name Prefix Enter a prefix name for the output Excel file. Available only when the Create New File check box is selected.
Formula You can select the following methods:
  • An empty cell represents the default value to read the evaluated value of the formula.
  • Evaluate

    You can use the Evaluate method to read the evaluated value of the formula.

  • Keep

    You can use the Keep method to read the formula string.

Available only when the Read_Rows action is selected.