Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function excelkegiatan()
- {
- $kegiatan = DB::table('kegiatan')->get();
- $kegData = "";
- if(count($kegiatan) >0 ){
- $kegData .= '<table>
- <tr>
- <th style="border:1px solid #000; background-color:#255255255;">No</th>
- <th style="border:1px solid #000; background-color:#255255255;">Kegiatan</th>
- <th style="border:1px solid #000; background-color:#255255255;">Tahun</th>
- </tr>';
- foreach ($kegiatan as $kegiatan) {
- $kegData .= '
- <tr>
- <td style="border:1px solid #000; background-color:#255255255">'.$kegiatan->id_kegiatan.'</td>
- <td style="border:1px solid #000; background-color:#255255255">'.$kegiatan->nama_kegiatan.'</td>
- <td style="border:1px solid #000; background-color:#255255255">'.$kegiatan->tahun_kegiatan.'</td>
- </tr>';
- }
- $kegData .='</table>';
- }
- header('Content-Type: application/xls');
- header('Content-Disposition: attachment; filename=kegiatan.xls');
- echo $kegData;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement