How can i format report generated with excel file using jquery or laravel framework?

538 views Asked by At

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

1

There are 1 answers

2
Waqas Altaf On

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.