[ASK] require_once di Controller

julian123 · July 12, 2011, 5:55am

Hlo para Master… tanya lagi ,

klo mau include / require_once di controller gimana yach…

klo yang sy buat di bawah benar ga ?

public function excel($name, $Field1, $Field2, $Field3, $Field4, $Field5, $Field6) {

    Yii::import('application.extensions.excel.class.writeexcel_workbook.inc');


    Yii::import('application.extensions.excel.class.writeexcel_worksheet.inc');





    // excel start





    &#036;fname = (Yii::getPathOfAlias('webroot') . Yii::app()-&gt;params-&gt;uploadExcels . &#036;name . '.xls');





    &#036;workbook = new writeexcel_workbook(&#036;fname);


    &#036;worksheet = &#036;workbook-&gt;addworksheet();





    # Set the column width for columns 1, 2, 3 and 4


    &#036;worksheet-&gt;set_column(0, 3, 15);





    # Create a format for the column headings


    &#036;header = &#036;workbook-&gt;addformat();


    &#036;header-&gt;set_bold();


    &#036;header-&gt;set_size(12);


    &#036;header-&gt;set_color('blue');





    # Write out the data


    &#036;worksheet-&gt;write(0, 0, 'Field', &#036;header);


    &#036;worksheet-&gt;write(0, 1, 'Value', &#036;header);





    &#036;worksheet-&gt;write(1, 0, 'Nama Lengkap');


    &#036;worksheet-&gt;write(1, 1, &#036;Field1);





    &#036;worksheet-&gt;write(2, 0, 'Nomor Telepon');


    &#036;worksheet-&gt;write(2, 1, &#036;Field2);





    &#036;worksheet-&gt;write(3, 0, 'Nomor Handphone');


    &#036;worksheet-&gt;write(3, 1, &#036;Field3);





    &#036;worksheet-&gt;write(4, 0, 'Email');


    &#036;worksheet-&gt;write(4, 1, &#036;Field4);





    &#036;worksheet-&gt;write(5, 0, 'Kode Produk');


    &#036;worksheet-&gt;write(5, 1, &#036;Field5);





    &#036;worksheet-&gt;write(6, 0, 'Jenis Produk');


    &#036;worksheet-&gt;write(6, 1, &#036;Field6);





    &#036;workbook-&gt;close();


}

tapi ada error seperrti ini:

mohon bantuan nya

putrilangit · July 12, 2011, 7:20am

baris ini cek lagi gan




<?php

Yii::import('application.extensions.excel.class.writeexcel_workbook.inc');

Yii::import('application.extensions.excel.class.writeexcel_worksheet.inc');

?>

artinya apakah benar file writeexcel_worksheet

ada di directori

webpunyaku\protected\extensions\excel\class

terus coba ilangin .inc nya jadi

ahmadroni · July 12, 2011, 7:27am

Sebaiknya class Excelnya di letakan /protected/extension

kemudian di /protected/config/main.php




'import'=>array(

		'application.models.*',

		'application.components.*',

		'application.extension.*',

	),

saat manggil di codenya kayak gini.




// contoh untuk memanggil mbmenu....

$this->widget('application.extensions.mbmenu.MbMenu',array(

// sesuai properti yang ada di modul

 )

ahmadroni · July 12, 2011, 7:31am

mungkin ini bisa jadi referensi juga

Excel discusi

julian123 · July 18, 2011, 7:44am

Terima kasih banyak gan… dah bisa