The ExcelFileMultiSheetReceiver morphs generated data into an Excel formatted file in multiple sheets. The file can be exported in two types:
Note: Test data generation of Excel files is generally slower than the Delimited (e.g. CSV) file format.
In This Article
The following parameters can be defined for the ExcelFileMultiSheetReceiver. Items with an asterisk (*) are required.
- path* - The location to store the generated output file.
- fileName* - The name of the file data will be written to by the Receiver.
- uniqueAttribute - Defines a Domain Attribute the Receiver will use to identify a unique value that has already been inserted into the file and prevents it.
- quoteTextData* - Defines the character to use when quoting text data.
- booleanValue* - Format a Boolean object with the selected mask.
- nullValue* - Represens NULL value.
- sheetName* - Name of the sheet to write to. If sheetName exists, then the data will overwrite; otherwise, a new sheet will be created the given sheetName.
- type* - Defines the format in which the file may be saved: xlsx or xls.
- appendInSheet- Defines whether the appending within the sheet is on or off.
Receiver Attribute Property Keys
The Receiver defines two property keys that can be modified on any of its associated Domain Attributes:
- columnName - Defines the column name as it will be in the file header.
- include - Defines if the Attribute will be included as a column in the output file.
Use Case 1 - Generate Excel File with a Sheet for Each Domain
For this example, five Domains will be used to generate a multi-sheet Excel file. The data generated for each Domain will be an individual sheet within the Excel file.
The following Scenario Chain Set will be used to generate the output data. This Scenario Chain Set will run each Domain Scenario and generate data for all five Domains.
The ExcelFileMultiSheetReceiver has been added to each Domain. For each Domain, "Test" has been entered for the fileName Parameter.
The sheetName Parameter for each Domain's ExcelFileMultiSheetReceiver contains the Domain Name. The User Domain configuration is shown below:
An Excel file has been created and contains five sheets titled: customer, account, organization, department, and user. The number of records per sheet in this example is determined by each Domain's loopCount.