I have generated this report in excel using jquery but I want to format this report also Is there any Laravel package or any jquery plugin which I can use to convert this file formating into this
<script>
$(".btn-create-now").click(function(e) {
$html = $(".table-holding-data").html();
$("#div_convert_table_into_file table").html($html);
$("#div_convert_table_into_file table").find("*").removeAttr('class');
$("#div_convert_table_into_file table").find("*").removeAttr('style');
window.open('data:application/vnd.ms-excel,' + $('#div_convert_table_into_file').html());
e.preventDefault();
});
</script>
Here is my code of jquery to generate report
Mattwebsite/excel is a laravel package used to create excel files. Read documentation of maatwebsite/excel
public function downloadExcel()
{
$data = Post::get()->toArray();
return Excel::create('laravelcode', function($excel) use ($data) {
$excel->sheet('mySheet', function($sheet) use ($data)
{
$sheet->fromArray($data);
});
})->download('name.xlsx');
}
Javascript/JQuery
TableExport The simple, easy-to-implement library to export HTML tables to xlsx, xls, csv, and txt files.