want to wrap text

Topics: Developer Forum, User Forum
Sep 27, 2012 at 9:53 AM

Haii....

i want ask  :D

if i want to wrap text in cell column, how to do?

// Add some data
$object->getActiveSheet()->getColumnDimension('A')->setWidth(14);
$object->getActiveSheet()->getColumnDimension('B')->setWidth(17);
$object->getActiveSheet()->getColumnDimension('C')->setWidth(17);
$object->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$object->getActiveSheet()->getColumnDimension('E')->setWidth(10);
$object->getActiveSheet()->getColumnDimension('F')->setWidth(50);
$object->getActiveSheet()->getColumnDimension('G')->setWidth(50);

$object->getActiveSheet()->mergeCells('A1:F1');
$object->setActiveSheetIndex(0)
            ->setCellValue('A1', 'REGISTRASI SS KMI 2012')
            ->setCellValue('A4', 'NO REGISTRASI')
            ->setCellValue('B4', 'POIN REGISTRASI')
            ->setCellValue('C4', 'TANGGAL USULAN')
            ->setCellValue('D4', 'NAMA KARYAWAN')
            ->setCellValue('E4', 'TEMA')
            ->setCellValue('F4', 'USULAN PERBAIKAN')
            ->setCellValue('G4', 'LATAR BELAKANG'); -->Example in G4
           

Thanks a lot :D