Optional Configurations in the Excel Workload
Configuring the Excel Run script
Uploading the Excel scripts to an Appliance
Linking the Excel scripts to a Test
Running a Test with Excel scripts
Overview
The Excel workload measures modern, realistic application performance by driving both GPU, CPU, and memory–intensive tasks and humanlike interactions. Chart re‑formatting operations stress the system through heavy computational and rendering work, while the natural scroll functionality simulates realistic, humanlike load. These workloads are ready to use as provided.
The Excel Start script launches Excel with a predefined workbook and handles tasks such as timing and dialog dismissal.
The Excel Run script simulates workbook operations, including file‑open, natural scrolling, chart insertion/re‑formatting, and save workflows.
Metrics captured include launch duration, dialog handling time, chart insertion time, and save‑as performance.
✅ This workload is ready to use as provided.
The download files for the workload are attached at the bottom of this page.
Excel Start script
Launches Excel with a specified workbook and dismisses any initial setup dialogs.
Features
- File Download: Ensures the predefined workbook exists by copying from the appliance.
- Application Launch: Starts Excel, targeting the window, and measures launch time.
- Dialog Handling: Closes first‑run dialogs automatically.
- Window Preparation: Maximizes and focuses the main Excel window for subsequent interactions.
Excel Run script
Drives Excel through common user workflows, validating file‑open, scrolling, chart insertion, and save operations.
Features
- Blank Workbook Launch: Opens a new workbook and closes any extra windows.
- File‑Open Dialog: Automates file open, navigates the file dialog, and loads the workbook.
- Scroll Simulation: Scrolls down and up through the sheet to stress rendering performance.
- Chart Insertion: Inserts a clustered column chart, toggles full‑screen, and cycles through quick layouts.
- Save‑As Workflow: Opens the Save As dialog, saves the edited file, and records save duration.
Optional Configurations in the Excel Workload
Each variable is editable at the top of the workload files. To edit the workloads, such as the variables, use the Login Enterprise Script Editor.
Configuring the Excel Run script
All configurable variables are defined at the top of each script. You can adjust:
- Timeouts: globalTimeoutInSeconds for window and dialog searches.
- Delays: globalWaitInSeconds, waitAfterScrolling for pacing.
- Typing Speeds: keyboardShortcutsCPM, charactersPerMinuteToType.
- Scroll Parameters: scrollCount, notches, and waitTime in Scroll().
- Chart Timers: waitForGraphToShow, waitAfterQuickLayoutPreviews, etc.
Uploading the Excel scripts to an Appliance
For details on uploading the workloads to an Appliance, consult Uploading scripts.
For instructions on adding these workloads to a Group, refer to Application Groups.
The Excel Start script needs the 'Leave Application Running' and 'Run Once' settings configured, such as:
For more information, see Application configurations: Run Once and Leave Application Running.
Linking the Excel scripts to a Test
To add application workloads or application workload groups to a Load Test, see Adding Applications to a Load Test.
Running a Test with Excel scripts
To run the Test with workloads linked to it, see Starting a Load Test.
- KW25 Excel Run.cs10 KB
- KW25 Excel Start.cs3 KB