Automation lab Aú File Handling (FILE_HANDLING)

Lab 069: Import Excel and map to table data

Practice import excel and map to table data in a real web app context as part of the File Handling module.

intermediate intermediate
intermediate

Objectives

Use for test scripts
  • Understand the purpose and business flow of import excel and map to table data.
  • Design stable locators for key UI elements.
  • Automate user interactions and verify the resulting UI state.

Sandbox

File Handling / file / intermediate / active

Import Excel and map to table data

Upload a mock Excel file (.xlsx) and map rows into a table.

Reading and understanding requirements Choosing stable locators Designing assertions based on business rules

Learning objectives

  • Accept .xlsx file uploads.
  • Simulate parsed rows into UI.
  • Show status and row count.

Steps

  1. Select a mock Excel file.
  2. Import and render rows.
  3. Verify status shows count.
Item Owner

No data imported

Assertions to practice

  • Only .xlsx accepted.
  • Three rows rendered from mock parse.
  • Status shows row count.