[Solved] File Excel Corrupt ketika Generate Menggunakan JPhpExcel

Halooo master2 Yii. Newbie mau nanya nih.

saya mau generate dari CGridView ke Excel.

di Controller saya punya action kyk gini.




public function actionGenerate()

        {

                $model=new Skdata('search');

				$dataProvider= $model->search();

				$data = $dataProvider->data;

				$data = array($model);

				

				foreach ($data as $model)

				{

					$datask = array($model);

				}

			Yii::import('application.extensions.phpexcel.JPhpExcel');

				$xls = new JPhpExcel('UTF-8', false, 'sk_data');

				$xls->addArray($datask);

				$xls->generateXML('skdata_excel');

        }



nah pas ane generate, file excelnya gak bisa dibuka.

Maklum newbie, ane buka tuh file excel yang corrupt pake notepad++.

Lah ternyata kok cell-nya kosong ya gan ( Menurut ane yang newbie) :(

Ini penggalan file excel yang corrupt




<?xml version="1.0" encoding="UTF-8"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">

<Worksheet ss:Name="sk_data">

<Table>

<Row>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

<Cell><Data ss:Type="String"></Data></Cell>

</Row>

</Table>

</Worksheet>

</Workbook>



Tolong di bantu ya gan :D

Alhamdulillah sudah berhasil. :D

gimana gan caranya, ane juga newbie nich :D

kesalahan ane disini gan


  

foreach ($data as $model)

{

$datask = array($model);

}



Harusnya kyk gini


foreach ($data as $model)

{

$datask[] = $model;

}

Abis itu jalan deh… :D

gan blh minta contoh controller, model ma view untuk export ga ?

ane blm paham cara export