With the new version 2.0.2 i get the following Error:
The website encountered an unexpected error. Try again later.
Drupal\Component\Serialization\Exception\InvalidDataTypeException: Invalid cell coordinate J in Drupal\views_data_export_phpspreadsheet\Encoder\XlsEncoder->encode() (line 316 of modules/contrib/views_data_export_phpspreadsheet/src/Encoder/XlsEncoder.php).PhpOffice\PhpSpreadsheet\Cell\Coordinate::indexesFromString('J') (Line: 1262) PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->createNewCell('J') (Line: 1175) PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->getCell('J') (Line: 1116) PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setCellValue('J', 'Number') (Line: 268) Drupal\views_data_export_phpspreadsheet\Encoder\XlsEncoder->encode(Array, 'xlsx', Array) (Line: 43) Symfony\Component\Serializer\Encoder\ChainEncoder->encode(Array, 'xlsx', Array) (Line: 416) Symfony\Component\Serializer\Serializer->encode(Array, 'xlsx', Array) (Line: 141) Symfony\Component\Serializer\Serializer->serialize(Array, 'xlsx', Array) (Line: 263) Drupal\views_data_export\Plugin\views\style\DataExport->render() (Line: 433) Drupal\rest\Plugin\views\display\RestExport->Drupal\rest\Plugin\views\display\{closure}() (Line: 627) Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 432) Drupal\rest\Plugin\views\display\RestExport->render() (Line: 1548) Drupal\views\ViewExecutable->render() (Line: 424) Drupal\rest\Plugin\views\display\RestExport->execute() (Line: 1645) Drupal\views\ViewExecutable->executeDisplay('data_export_items_xlsx', Array) (Line: 81) Drupal\views\Element\View::preRenderViewElement(Array) call_user_func_array(Array, Array) (Line: 111) Drupal\Core\Render\Renderer->doTrustedCallback(Array, Array, 'Render #pre_render callbacks must be methods of a class that implements \Drupal\Core\Security\TrustedCallbackInterface or be an anonymous function. The callback was %s. See https://www.drupal.org/node/2966725', 'exception', 'Drupal\Core\Render\Element\RenderCallbackInterface') (Line: 859) Drupal\Core\Render\Renderer->doCallback('#pre_render', Array, Array) (Line: 421) Drupal\Core\Render\Renderer->doRender(Array, 1) (Line: 240) Drupal\Core\Render\Renderer->render(Array, 1) (Line: 153) Drupal\Core\Render\Renderer->Drupal\Core\Render\{closure}() (Line: 627) Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 152) Drupal\Core\Render\Renderer->renderRoot(Array) (Line: 178) Drupal\views_data_export\Plugin\views\display\DataExport::buildStandard(Object) (Line: 55) Drupal\views_data_export\Plugin\views\display\DataExport::buildResponse('my_items', 'data_export_items_xlsx', Array) (Line: 56) Drupal\views\Routing\ViewPageController->handle('my_items', 'data_exportitems_xlsx', Object) call_user_func_array(Array, Array) (Line: 123) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 627) Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 121) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97) Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 181) Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 76) Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 54) Drupal\simple_oauth\HttpMiddleware\BasicAuthSwap->handle(Object, 1, 1) (Line: 80) Drupal\my_module\ForceUserToSetEmailMiddleware->handle(Object, 1, 1) (Line: 58) Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 48) Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 28) Drupal\Core\StackMiddleware\ContentLength->handle(Object, 1, 1) (Line: 32) Drupal\big_pipe\StackMiddleware\ContentLength->handle(Object, 1, 1) (Line: 106) Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 85) Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 43) Drupal\my_module\StackMiddleware\ProductPrefetch->handle(Object, 1, 1) (Line: 48) Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 51) Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 36) Drupal\Core\StackMiddleware\AjaxPageState->handle(Object, 1, 1) (Line: 51) Drupal\Core\StackMiddleware\StackedHttpKernel->handle(Object, 1, 1) (Line: 714) Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
The only thing that led to this error was the update from version 2.0.1 to the new version 2.0.2
Fixed
2.0
Code
in version 2.0.2 it uses newsest version PHPOffice/PhpSpreadsheet(2.0.0) make sure your PHPOffice is updated in vendor, because there is deprecated function. If you don't want to use PHPOffice/PhpSpreadsheet 2.0.0 don't update module
Automatically closed - issue fixed for 2 weeks with no activity.