'Formating View in maatwebsite Excel Export

I am new to maatwebsite Excel Export i am using view Excel Export in laravel and would like to know how one can specify the cell number where the data should go like a h1 tag like below snippet

<h5>PURCHASE ORDER</h5>



<hr>
<div class="container-flow">
<table id="table" class="table table-hover table-bordered table-sm text-center">
<thead>
<tr>
<th  scope="col">No.</th>
<th  scope="col">Product_Code</th>
<th  scope="col"> Item_Description </th>
<th scope="col">Qty</th>
<th scope="col">Unit Price</th>
<th scope="col" >Value</th>
<th scope="col">Stock Less 90 Days</th>
<th scope="col">Stock More 90 Days</th>

when i export i get this enter image description here

i would like to specify the cell where that tag should go like say cell B3 instead of current position cell A1

laravellaravel-excel


Solution 1:[1]

You can put some empty tags / cells before. Try

   <table>
     <tr></tr>
     <tr></tr>
     <tr>
       <td></td>
       <td></td>
       <td><h5>PURCHASE ORDER</h5></td>
    </tr>
   </table>

<hr>
<div class="container-flow">
<table id="table" class="table table-hover table-bordered table-sm text-center">
<thead>
<tr>
<th  scope="col">No.</th>
<th  scope="col">Product_Code</th>
<th  scope="col"> Item_Description </th>
<th scope="col">Qty</th>
<th scope="col">Unit Price</th>
<th scope="col" >Value</th>
<th scope="col">Stock Less 90 Days</th>
<th scope="col">Stock More 90 Days</th>

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions