ploosh.

Documentation

Excel

This connector is used to read local Excel files (.xlsx, .xls).

Connection configuration

No connection is required by this connector.

Test case configuration

NameMandatoryDefaultDescription
pathyesPath to the Excel file
sheet_nameyesSheet name or sheet index (0-based)
skiprowsno0Number of rows to skip at the start of the sheet

Example

Example Excel:
  source:
    type: excel
    path: ./data/employees.xlsx
    sheet_name: Sheet1
  expected:
    type: csv
    path: ./data/expected_employees.csv

Example with sheet index

Example Excel by index:
  source:
    type: excel
    path: ./data/report.xlsx
    sheet_name: 0
    skiprows: 2
  expected:
    type: empty

Requirements

  • openpyxl (included in ploosh installation)