mahavirvataliya / excelheader
Get ExcelHeader in Json Format By file path and Row number For First Sheet of file
Requires
- php: ^5.6|^7.0
- ext-ctype: *
- ext-dom: *
- ext-gd: *
- ext-iconv: *
- ext-libxml: *
- ext-mbstring: *
- ext-simplexml: *
- ext-xml: *
- ext-xmlreader: *
- ext-xmlwriter: *
- ext-zip: *
- ext-zlib: *
- psr/simple-cache: ^1.0
Requires (Dev)
- dompdf/dompdf: ^0.8.0
- friendsofphp/php-cs-fixer: @stable
- jpgraph/jpgraph: ^4.0
- mpdf/mpdf: ^7.0.0
- phpunit/phpunit: ^5.7
- squizlabs/php_codesniffer: ^2.7
- tecnickcom/tcpdf: ^6.2
Suggests
- dompdf/dompdf: Option for rendering PDF with PDF Writer
- jpgraph/jpgraph: Option for rendering charts, or including charts with PDF or HTML Writers
- mpdf/mpdf: Option for rendering PDF with PDF Writer
- tecnick.com/tcpdf: Option for rendering PDF with PDF Writer
This package is not auto-updated.
Last update: 2025-03-02 08:14:24 UTC
README
For getting ExcelHeader# mahavirvataliya/excelheader Welcome to the excelheader wiki! If U want to Use This Package in your Project Then Use
composer require mahavirvataliya/excelheader
There are Two methods
getExcelHeader($filepath,$rowno=1)
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
getAllSheetExcelHeader($filepath,$rowno=1)
get all headers means get header from all sheet given by row number as same to all mean return that row as json object
I Have Used https://github.com/PHPOffice/phpspreadsheet as read excel files please go for it if you want to develop go for it.
Add at Import Section
use mahavirvataliya\ExcelHeader\ExcelHeader;
use it where you want to
For Example For Uploading Excel file And getting headers or any row we use like this where xls is name parameter in file upload
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'));
}
}