How to convert a array value one column to multiple columns in laravel excel?

Question

Here I attached my recent Laravel-excel image. Here I mark $items_name column. Which I want to need in multiple columns. For that reason I use foreach loop, and implode and also array_map. [1]: https://i.sstatic.net/PaMM3.jpg

I want to show $item_name values in different columns not in a single column.

if($customer_type == 2)
    {
        $excel_data_attribute = array(
            array('Distributor Customer')
        );

        if ($show_type == 0)
        {
            $excel_data_attribute_array = array(
                array('Sales Sheet - Quanty Wise')
            );
        }elseif($show_type == 1)
        {
            $excel_data_attribute_array = array(
                array('Sales Sheet - Price Wise')
            );
        }else
        {
            $excel_data_attribute_array = array(
                array('Sales Sheet - Cartoon Quanty Wise')
            );
        }
        $excel_dynamic_data_array = array();
        $index=0;
        foreach ($productGroup as $gKey => $group )
        {
            $col_[$gKey] = false;
            foreach($all_product as $pkey => $product)
            {
                if($productGroup[$gKey]["id"] == $product->product_group_id)
                {
                    $col_[$gKey] = true;
                }
            }
            if($col_[$gKey])
            {
                $product_Names_with_keys = $productGroup[$gKey]["t_product"].$productGroup[$gKey]['gorupName'];

                $excel_dynamic_data_array[$index][] = $productGroup[$gKey]['gorupName'];
                $index++;
            }
        }
        $item  = $excel_dynamic_data_array;

        $item_name = implode(', ', array_map(function ($entry) {
                                                return ($entry[key($entry)]);
                                            }, $item));
        if($summery == 1)
        {
            $excel_data_attribute_array_column = array(
                array('SL','Region & Rsm',$item_name,'Total')
            );
        }else
        {
            if ($customer_type == 2)
            {
                $excel_data_attribute_array_column = array(
                    array('SL','Order No','Order Date','Challan No','Challan Date','Bill No','Party Name','Area',$item_name,'Total')
                );

            }else
            {
                $excel_data_attribute_array_column = array(
                    array('SL','Order No','Order Date','Bill No','Party Name','Area',$item_name,'Total')
                );
            }
        }
        $total_final_array = array_merge($excel_data_attribute,$excel_data_attribute_array,$excel_data_attribute_array_column);
    }
   return collect($total_final_array);

Kmg Kumar · Accepted Answer · 2022-10-12 11:07:07Z

1

Try this,

array_merge(array('SL','Order No','Order Date','Challan No','Challan Date','Bill No','Party Name','Area','Total'),explode(',',$item_name));

answered Oct 12, 2022 at 11:07

Kmg Kumar

6263 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anika Tabassum Over a year ago

Got this error after using this.... TypeError Return value of Maatwebsite\Excel\Sheet::mapArraybleRow() must be of the type array, string returned

Anika Tabassum Over a year ago

Then I write this- $excel_data_attribute_array_column = array( array_merge(array('SL','Order No','Order Date','Challan No','Challan Date','Bill No','Party Name','Area'),explode(',',$item_name),array('Total')) );

Jignesh Joisar · Accepted Answer · 2022-10-20 06:00:07Z

0

$excel_data_attribute_array_column = array(
      array_merge(
        array('SL','Order No','Order Date','Challan No','Challan Date','Bill No','Party Name','Area'),
        explode(',',$item_name),
        array('Total')
      )
 );

Correct ans is-

edited Oct 20, 2022 at 6:00

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Oct 13, 2022 at 4:43

Anika Tabassum

216 bronze badges

2 Comments

Mátyás Grőger Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Anika Tabassum Over a year ago

I just explode which column I want to separate.

Collectives™ on Stack Overflow

How to convert a array value one column to multiple columns in laravel excel?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related