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
In This Article
- Receiver Parameters
- Receiver Attribute Property Keys
- Permission Denied Error - Linux Users
- Use Case 1 - Generate an Excel File with a Sheet for Each Domain
Permission Denied Error - Linux Users
During test data generation, a "profiles" folder will be created within a temporary directory to generate the Excel output file. The full path for each operating system is shown below:
- Linux - /tmp/profiles
- Windows - /temp/profiles
Linux users may receive the following error during test data generation if they lack folder permissions. Verify access to the /tmp and /profiles folders.
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. Each Domain's loopCount determines the number of records per sheet in this example. "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.