How will we page dynamic data to sheets?

[natarajan405]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1

What version of Laravel are you using?

9

What version of PHP are you using?

8.1

Describe your issue

https://docs.laravel-excel.com/3.1/imports/multiple-sheets.html#multiple-sheets

we need to create multiple dynamic sheets

public function sheets(): array
{
$sheets1 = [];
$i=0;
foreach ($testdata as $key => $data) {
$sheets1[$i] = [
new GanttWithMultipleExport( $data)
];
$i++;
}

$sheets=$sheets1;
return $sheets;
}

How can the issue be reproduced?

no idea

What should be the expected behaviour?

multiple sheet with dynamic

[patrickbrouwers]

Your question is not really clear to me. Please try to explain the expected behaviour a bit more.

[natarajan405]

public function sheets(): array
{
return [
new FirstSheetImport(),
new SecondSheetImport()
];
}
how can we change inside to for loop with same class

we need dynamic multiple sheets
public function sheets(): array
{
foreach ($data as $key => $data1) {
return [
new SecondSheetImport(data1)
];
}
}

[natarajan405]

public function sheets(): array
{
$sheets1 = [];
$i = 0;
foreach ($tmpdata as $key => $data) {
$sheets[$i] = [
new GanttWithMultipleExport( $projectDisp)
];
$i++;
}
$sheets= $sheets1;
return $sheets;
}

[patrickbrouwers]

Sounds like you found your solution

[natarajan405]

From the logic above, we obtain multiple pages, but they are all empty sheets.
GanttWithMultipleExport.php
public function __construct($data) {
$this->data = $data;
}
public function view(): View
{
return view('pdf.report', [ 'report' => $this->data ]);
}

[natarajan405]

Thank you; we received the desired result. once more, I appreciate all of your help.