Support for phpoffice/phpspreadsheet 2.x

I don't particularly see an explicit dependency from Views Data Export to phpoffice/phpspreadsheet, where is that?

I can see that we are indeed calling some phpoffice/phpspreadsheet code, are you saying that the API has changed upstream and we need to sort VDE out?

Can you outline what changes you'd like to see VDE make or outline the errors you're seeing please?

Not OP, but I was looking into this recently.

Here is what I got for module dependencies on phpoffice/phpspreadsheet.

Notice views_data_export says conflicts < 1.23.0. This actually means it conflicts with versions under 1.23.0, so anything over that is allowed.

$ ddev composer why phpoffice/phpspreadsheet
drupal/complete_webform_exporter        1.0.4   requires  phpoffice/phpspreadsheet (^1.1 || ^2.1)   
drupal/feeds_xlsx                       1.0.1   requires  phpoffice/phpspreadsheet (^2.0)           
drupal/permission_spreadsheet           2.1.1   requires  phpoffice/phpspreadsheet (^1 || ^2 || ^3) 
drupal/phpexcel                         4.0.2   requires  phpoffice/phpspreadsheet (^1 || ^2)       
drupal/trucie                           1.2.0   requires  phpoffice/phpspreadsheet (^2.0)           
drupal/vbo_export                       4.x-dev requires  phpoffice/phpspreadsheet (^2.2)           
drupal/views_data_export                1.5.0   conflicts phpoffice/phpspreadsheet (<1.23.0)        
drupal/views_data_export_phpspreadsheet 2.0.6   requires  phpoffice/phpspreadsheet (^1 || ^2 || ^3) 

@mortona2k Thanks for your dependency resolution example. Good pickup on the conflicts.
@steven jones I'll see if I can outline what I'm thinking along with a patch. I might have to dig into it a bit deeper to see why it's not using 2.x for the particular site I'm looking at.

@geoffreyr - use the composer why command (see the example above).

Or try why-not <package> <version>.