Level 9
You just need to set the correct headers to tell the browser how to handle the response, you can save yourself a lot of work with the package http://csv.thephpleague.com/examples/ or just copy hoe it creates the response.
Dec 6, 2016
5
Level 2
How to Get the Records of the table downloadable and exported in xls or csv format?
I created a table user and display the records as follows:
Date Project TicketNumber Ticketsubject Timein Timeout
2016-11-23 first 654321 My first project 09:00:00 09:10:00
2016-11-25 second 154326 My second project 09:30:00 09:40:00
2016-11-27 php 456789 Registration 10:00:00 10:20:00
2016-11-27 laravel 456789 login 11:20:00 11:30:00
2016-11-30 Third 789111 loginlaravel 11:50:00 12:00:00
2016-11-30 timesheet 567839 Records in table 12:20:00 12:35:00
2016-12-01 file 564326 file uploading 12:50:00 01:10:00
2016-12-04 database 8439123 Github 01:23:00 01:34:00
2016-12-04 Database retrieval 765893 Retreived the data 02:30:00 02:30:00
2016-12-09 Query 391750 Query Builder 03:12:00 03:23:00
« 1 2 »
Now I need to download these file as .csv or .xls .How to do it
Level 2
But I clearly did not understand what to do because i am beginner of laravel?
Level 1
Dear @jhansi ,
Take a look at this package: http://www.maatwebsite.nl/laravel-excel/docs
I have used it in some projects, works perfrectly!
Level 2
I actually installed csv by using command "composer require league/csv" My usercontroller.php
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\User;
class UserController extends Controller
{
public function index(){
$users = DB::table('users')->Paginate(10);
return view('index', ['users' => $users]);
}
public function export()
{
$users=User::all();
$csv = \League\Csv\Writer::createFromFileObject(new \SplTempFileObject());
$csv->insertOne(\Schema::getColumnListing('users'));
foreach ($users as $user) {
$csv->insertOne($user->toArray());
}
$csv->output('users.csv');
}
}
But it is redirecting the same table page:not export or import the table did i need to set route
Level 2
1 like
Please or to participate in this conversation.