[ASK] require_once di Controller

[julian123 (Putranto Jul)]

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





    $fname = (Yii::getPathOfAlias('webroot') . Yii::app()->params->uploadExcels . $name . '.xls');





    $workbook = new writeexcel_workbook($fname);


    $worksheet = $workbook->addworksheet();





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


    $worksheet->set_column(0, 3, 15);





    # Create a format for the column headings


    $header = $workbook->addformat();


    $header->set_bold();


    $header->set_size(12);


    $header->set_color('blue');





    # Write out the data


    $worksheet->write(0, 0, 'Field', $header);


    $worksheet->write(0, 1, 'Value', $header);





    $worksheet->write(1, 0, 'Nama Lengkap');


    $worksheet->write(1, 1, $Field1);





    $worksheet->write(2, 0, 'Nomor Telepon');


    $worksheet->write(2, 1, $Field2);





    $worksheet->write(3, 0, 'Nomor Handphone');


    $worksheet->write(3, 1, $Field3);





    $worksheet->write(4, 0, 'Email');


    $worksheet->write(4, 1, $Field4);





    $worksheet->write(5, 0, 'Kode Produk');


    $worksheet->write(5, 1, $Field5);





    $worksheet->write(6, 0, 'Jenis Produk');


    $worksheet->write(6, 1, $Field6);





    $workbook->close();


}

tapi ada error seperrti ini:

include(writeexcel_workbook.php) [<a href=‘function.include’>function.include</a>]: failed to open stream: No such file or directory

mohon bantuan nya

[putrilangit (Mrasad257)]

tapi ada error seperrti ini:

include(writeexcel_workbook.php) [<a href=‘function.include’>function.include</a>]: failed to open stream: No such file or directory

mohon bantuan nya

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

Yii::import(‘application.extensions.excel.class.writeexcel_worksheet’);

[ahmadroni]

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]

mungkin ini bisa jadi referensi juga

Excel discusi

[julian123 (Putranto Jul)]

Terima kasih banyak gan… dah bisa