I'm getting this error while calling the export function of laravel Excel. Can anyone help me solve this error or why am I getting it???
Laravel Version: 8.10.1
Laravel Excel Package Version: 3.1
My Code in Controller:
namespace App\Http\Controllers;
use App\Exports\ProductInventoryExport;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Routing\Controller as BaseController;
use Maatwebsite\Excel\Facades\Excel;
class Controller extends BaseController
{
use AuthorizesRequests, DispatchesJobs, ValidatesRequests;
public function ProductInventory()
{
return Excel::download(new \App\Exports\ProductInventoryExport, 'ProductInventory.xlsx');
}
}
My Code in Export Class File:
namespace App\Exports;
use App\Models\Product;
use App\Models\AttributeValue;
use App\Models\Category;
use App\Models\Subcategory;
use App\Models\User;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Excel;
use Illuminate\Support\Facades\Schema;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use Maatwebsite\Excel\Concerns\WithHeadings;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use \Maatwebsite\Excel\Writer;
use \Maatwebsite\Excel\Sheet;
use Carbon\Carbon;
Writer::macro('setCreator', function (Writer $writer, string $creator) {
$writer->getDelegate()->getProperties()->setCreator($creator);
});
Sheet::macro('styleCells', function (Sheet $sheet, string $cellRange, array $style) {
$sheet->getDelegate()->getStyle($cellRange)->applyFromArray($style);
});
Sheet::macro('setOrientation', function (Sheet $sheet, $orientation) {
$sheet->getDelegate()->getPageSetup()->setOrientation($orientation);
});
class ProductInventoryExport implements FromArray, ShouldAutoSize, WithHeadings, WithStyles
{
/**
* @return \Illuminate\Support\collection
*/
// STYLES
public $columns = [id, image, name, slug, product_type, size, colour, tax_percent, cost_price, regular_price, sale_price, SKU, quantity, stock_status, sold, purchase_limit, featured, short_description, description, category_id, subcategory_id, created_at, updated_at];
public $HeadingStyle = [
'borders' => [
'allBorders' => [
'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUM,
],
],
'alignment' => [
'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT,
'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
],
'font' => [
'bold' => true,
'size' => 12,
],
];
public $ColumnStyle = [
'borders' => [
'allBorders' => [
'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUM,
],
],
'alignment' => [
'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
],
'font' => [
'bold' => true,
'size' => 8,
],
];
public $CellStyle = [
'borders' => [
'allBorders' => [
'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
],
],
'alignment' => [
'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
],
'font' => [
'bold' => false,
'size' => 8,
],
];
// FUNCTIONS
public function headings(): array
{
// $columns = Schema::getColumnListing('products');
// $ar = [];
// foreach($columns as $column)
// {
// array_push($ar, ucwords(trans(preg_replace('/__*/', ' ', $column))));
// }
return [
['Rojanic Bangladesh'],
['In Stock Products - '.Carbon::now()->month.' '.Carbon::now()->year],
['ID', 'Image', 'Name', 'Slug', 'Type', 'Size', 'Colour', 'Vat Percent', 'Cost Price', 'Regular Price', 'Sale Price', 'Barcode', 'Left Quantity', 'Stock', 'Sold', 'Purchase Limit', 'Featured', 'Short Description', 'Description', 'Category', 'Sub Category', 'Created At', 'Last Updated'],
// $ar
];
}
public function styles(Worksheet $sheet)
{
$columnTill = 'a';
foreach(Schema::getColumnListing('products') as $colum)
{
$columnTill++;
}
--$columnTill;
$productCount = Product::all()->count();
$sheet->mergeCells('A1:'.$columnTill.'1', Worksheet::MERGE_CELL_CONTENT_MERGE);
$sheet->mergeCells('A2:'.$columnTill.'2', Worksheet::MERGE_CELL_CONTENT_MERGE);
$sheet->getStyle('A1:'.$columnTill.'1')->applyFromArray($this->HeadingStyle);
$sheet->getStyle('A2:'.$columnTill.'2')->applyFromArray($this->HeadingStyle);
$sheet->getStyle('A3:'.$columnTill.'3')->applyFromArray($this->ColumnStyle);
$sheet->getStyle('A4:'.$columnTill.Product::all()->count()+3)->applyFromArray($this->CellStyle);
}
public function array(): array
{
$ready = [];
foreach(Product::all() as $product)
{
$part = [];
$attributes = AttributeValue::where('product_id',$product->id)->get();
$productCategory = null;
$productSubCategory = null;
if($product->category_id)
{
$productCategory = Category::find($product->category_id);
}
if($product->subcategory_id)
{
$productCategory = Subcategory::find($product->subcategory_id);
}
if($attributes->count() > 0)
{
foreach($attributes as $attribute)
{
array_push($part,
$product->id,
$attribute->image ? $attribute->image : $product->image,
$product->name,
$product->slug,
$product->product_type,
$attribute->size,
$attribute->colour,
$product->tax_percent,
$attribute->cost_price ? $attribute->cost_price : $product->cost_price,
$attribute->regular_price ? $attribute->regular_price : $product->regular_price,
$attribute->sale_price ? $attribute->sale_price : $product->sale_price,
$product->SKU,
$attribute->quantity,
$attribute->quantity > 0 ? 'In Stock' : 'Out Of Stock',
OrderItem::where('product_id',$product->id)->where('attribute_id',$attribute->id)->count(),
$product->purchase_limit,
$product->featured,
$product->short_description,
$product->description,
$productCategory,
$productSubCategory,
$attribute->created_at,
$attribute->updated_at
);
}
}
else
{
array_push($part,
$product->id,
$product->image,
$product->name,
$product->slug,
$product->product_type,
'N/A',
'N/A',
$product->tax_percent,
$product->cost_price,
$product->regular_price,
$product->sale_price,
$product->SKU,
$product->quantity,
$product->quantity > 0 ? 'In Stock' : 'Out Of Stock',
OrderItem::where('product_id',$product->id)->count(),
$product->purchase_limit,
$product->featured,
$product->short_description,
$product->description,
$productCategory,
$productSubCategory,
$product->created_at,
$product->updated_at
);
}
array_push($ready, $part);
}
return
$ready
;
}
}
