mahavirvataliya/excelheader

Get ExcelHeader in Json Format By file path and Row number For First Sheet of file

excelheader

For getting ExcelHeader# mahavirvataliya/excelheader Welcome to the excelheader wiki! If U want to Use This Package in your Project Then Use, _(*1)

composer require mahavirvataliya/excelheader, _(*2)

There are Two methods, _(*3)

getExcelHeader($filepath,$rowno=1), _(*4)

It will return json object of header of first sheet given as file path and if you give row no of header then it will return that row, _(*5)

getAllSheetExcelHeader($filepath,$rowno=1), _(*6)

get all headers means get header from all sheet given by row number as same to all mean return that row as json object, _(*7)

I Have Used https://github.com/PHPOffice/phpspreadsheet as read excel files please go for it if you want to develop go for it., _(*8)

Add at Import Section, _(*9)

use mahavirvataliya\ExcelHeader\ExcelHeader;, _(*10)

use it where you want to, _(*11)

For Example For Uploading Excel file And getting headers or any row we use like this where xls is name parameter in file upload, _(*12)

public function upload(Request $request)
{
    $request->xls;
    if($request->hasFile('xls')) {

        $file = $request->file('xls') ;

        $fileName = $file->getClientOriginalName() ;
        $destinationPath = public_path() ;
        $file->move($destinationPath,$fileName);

        $rownno = $request->rowno==null?1:$request->rowno;
        $rows =  ExcelHeader::getExcelHeader(public_path().'/'.$fileName,$rownno);
        return view('excelfile',compact('rows'));
    }
    else
    {
        $rows=[];
        return view('excelfile',compact('rows'));
    }
}