ConvertJengJeng

public function downloadExcel(Request $request, $type)
	{
		$data = $request->session()->get('postdata');
		view()->share('infogempas',$data->toArray());
		return Excel::create('SIBMKG', function($excel) {
			$excel->setTitle('Data Gempa BMKG');
			$excel->sheet('mySheet', function($sheet)
	        {
	        	$sheet->setAllBorders('thin');
	        	$sheet->setAutoSize(true);
				$sheet->loadView('pdfview');
				$sheet->mergeCells('A2:J2');
				$sheet->setSize('A1', 2, 15)->setSize('B1', 5, 15)->setSize('J1', 50, 15)->setSize('C1', 12, 15)->setSize('D1', 12, 15)->setSize('E1', 12, 15)->setSize('F1', 12, 15)->setSize('G1', 14, 15)->setSize('H1', 14, 15)->setSize('I1', 12, 15);
				$sheet->setSize('A3', 2, 15)->setSize('B3', 5, 15)->setSize('J3', 50, 15)->setSize('C3', 12, 15)->setSize('D3', 12, 15)->setSize('E3', 12, 15)->setSize('F3', 12, 15)->setSize('G3', 14, 15)->setSize('H3', 14, 15)->setSize('I3', 12, 15);
	        	$sheet->cells('A2:J2', function($cells) {
							$cells->setFontWeight('bold');
							$cells->setFontSize(14);
							$cells->setAlignment('center');
						});
	        	$sheet->cells('A1:J200', function($cells) {
						$cells->setAlignment('center');
						$cells->setValignment('center');
						});
	        });
				$lastrow= $excel->getActiveSheet()->getHighestRow();
				$excel->getActiveSheet()->getStyle('A1:J'.$lastrow)->getAlignment()->setWrapText(true);
		})->download($type);
	}