Importing multiple worksheets

PHPMaker Feature Requests (PHPMaker)
1

have to option to read from multiple worksheets when importing. This would be usefull when you are wanting to import data into another tabel

2

Advanced users may use Page_Importing server event, the first argument &$builder is workflow builder, you may change everything. If you are willing to write your own code, you may try:

  1. Create your own reader, there is a AppendReader which can read data from multiple readers (e.g. you may add one reader for each active sheet),
  2. Create a workflow from your reader,
  3. Replace the workflow by your own, e.g. (pseudocode)
$builder = function($workflow) {
    $readers = [];
 // ...Set up your readers...
    $myReader = new \Port\Reader\AppendReader($readers);
    $myWorkflow = new ...($myReader);
// ...Set up your workflow...
    return $myWorkflow;
};

You may refer to:

  1. Generated code of the original import() method about how to create a reader for an active sheet from a file,
  2. Workflow - PortPHP Documentation.