Migrate source XLS

Component ID

2798639

Component name

Migrate source XLS

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

1634

Component created

Component changed

Component body

A source migrate plugin, to allow us to use XLS and XLSX files as a migration source.

Requirements:

  • Drupal 8
  • PHPExcel library(>=1.8.1)
  • Migrate module (>= 8.1)

Usage:

To use this plugin you have to:

  • install PHPExcel library via Composer
  • install this module via default installation process

Next point it's specifying a source plugin in your migration
and all it's params:

source:
  # Specify the plugin ID.
  plugin: xls
  # Define the path to the XLS source file.
  path: public://mySources/source.xls
  # Define unique key(s).
  keys:
    - id
  # Header row(to figure out which row is should be parsed as a column titles/headers).
  header_row: 1
  # Columns mapping:
  columns:
    -  My column name: my_column_name