Dear KoolReport team,

I am working on Excel Export feature. I got the Table data. My Excel file is also downloaded. But the data in the Excel file is corrupted. Why it happens, I can't understand. Please help me. I am working with Codeigniter3 and SqlServer

Here is my code.

Controller

class Enquiry extends CI_Controller
{
    public function export()
    {      
      include APPPATH."reports\EnquiryReport.php";
      $report = new EnquiryReport;
      $report->run();
      $report->exportToExcel('EnquiryExcel')->toBrowser("EnquiryReport.xls");
    }
}

If I given extension as "xls", then the corrupted data is displaying in Excel. else for the extension "xlsx", it opens the empty file.

Hello David, I done as you specified. But no use. Here is my code.

EnquiryReport.php

class EnquiryReport extends \koolreport\KoolReport
{
	use \koolreport\codeigniter\Friendship;
	use \koolreport\export\Exportable;
        use \koolreport\excel\ExcelExportable;

    public function settings()
	{
		return array(
			
            "dataSources"=>array(
                "excelTemplate"=>array(
                   ....
                   .....
                )
            )
        );
	}

	public function setup()
    {
        $this->src('excelTemplate')
        ->query("SELECT EnqRefNo, CustomerName, Email, city, state, country, ContactNumber, salesManger from EnquiryDataView")
        ->pipe($this->dataStore('enquiry'));
    }

EnquiryReport.view.php

<div class='box-container'>
    <div>
      <?php
        Table::create(array(
            "dataSource" => $this->dataStore('enquiry'),
            "columns"=>array(
              'EnqRefNo',
              'CustomerName',
              'Email',
              'city',
              'state',
              'country',
              'ContactNumber',
              'salesManger'
            ),
             "paging"=>array(
                "pageSize"=>5
              )


        ));
      ?>

    </div>
  </div>

EnquiryReportExcel.view.php

<div cell="A1" range="A1:H1" excelstyle='<?php echo json_encode($styleArray); ?>' >
        Enquiry Report
    </div>

    <div>
    	<?php
    	Table::create(array(
            "dataSource" => $this->dataStore('enquiry'),
            "columns"=>array(
              'EnqRefNo',
              'CustomerName',
              'Email',
              'city',
              'state',
              'country',
              'ContactNumber',
              'salesManger'
            ),
            ));
    	?>
    </div>

Yes Sir, I also done like this only.

<div sheet-name="<?php echo $sheet1; ?>">

<?php
    $styleArray =[
        -------
        -------]
?>
<div cell="A1" range="A1:H1" excelstyle='<?php echo json_encode($styleArray); ?>' >
        Enquiry Report
    </div>

    <div>
    	<?php
    	Table::create(array(
            "dataSource" => $this->dataStore('enquiry'),
            "columns"=>array(
              'EnqRefNo',
              'CustomerName',
              'Email',
              'city',
              'state',
              'country',
              'ContactNumber',
              'salesManger'
            ),
            ));
    	?>
    </div>

Dear Sir, I sent the mail to "support@koolreport.com" from my mail id "sowmya.g@icsoft.co.in". In that mail I attached my coding files and output files too.

Please check and give me the solution as early as possible...

Yes Sir, I closed the <div> tag. But still same error.

No sir, same Error message as above.

public function export()
    {      
      //$this->load->helper('url');
      //$this->load->database('MainiDM');
      ob_start();
      include APPPATH."reports\EnquiryReport.php";
      $report = new EnquiryReport;
      $report->run();
      ob_end_clean();
      $report->exportToExcel('EnquiryReportExcel')->toBrowser("EnquiryReport.xlsx");
    }

But Same Error sir.

Is there any Excel version problem?

Yes sir I sent the mail from sowmya.g@icsoft.co.in. Please check the attached files.

Thank you....