Yii Framework Excel Download using extension.

In this tutorial, we are going to show you how to download database table data in excel file using Yii excel export extenstion. it's an easy tips to add this feature into your Yii project. This is the Live project code and 100% secure & working that we used for our Custo Web Application. for using this feature, First of all we have to download excel extenstion from the given link.

http://www.yiiframework.com/extension/exportasxls/

If you face the following problem while running this extension: -
Undefined variable Build;
Then open extension file named ExportXLS and define variable in function.

Now open view page where you want to show Download Excel Button then add following code written below.

 array('mRetailer/Excel')));

?>

Open your controller page and paste the following code and change accordinglly. In this code we are importing Yii extenstion page. calling model function for getting value from database. In this code we are calling model function using its object and getting value from database communication.

exceldata();
            
   
  // Xls File Name
  $your_file_Name = 'your_file_Name.xls';
      $xlsfile      = new ExportXLS($your_file_Name);
      $header = '';
      $xlsfile->addHeader($headercolums);
      $xlsfile->addRow($row);
      $xlsfile->sendFile();
    }
?>

Now here we are going to make its model for fetching value from database fields. In this example we have taken an example m_retailer table name. That is fetching values from various fields named like: -
1). isd_code
2). password
3). location
4). distributor_name
5). retailer_name

These values will make an array and return response to controllers function. After that automatically you will see one file for downloadable. from there you can save this file into your desktop or directly open it.

isd_code
password
location
distributor_name
retailer_name

db->createCommand('SELECT * FROM m_retailer')->queryAll();
     $mainarray = array();
     foreach($rawData as $row)
     {
            //$row=array(array('Sachin','35'),array('sehwag',30));
             $subarray = array();
             $subarray[] = $row['isd_code'];
             $subarray[] = $row['password'];
             $subarray[] = $row['location'];
             $subarray[] = $row['distributor_name'];
             $subarray[] = $row['retailer_name'];
            
             $mainarray[]=$subarray;
     }
   
          return $mainarray; // will return a list of arrays.
 }
?>

In Between if you face any problem the feel free to contact us or send your query with the help of below contact form. Surely we will contact you as soon as possible. this is the live code from my project.

Thanks and Happy Coding!!