PHPExcel

Dear Members,

Could anyone tell me the step by step procedure how could I’ll be able to use PhpExcel functions in Ajax Events of a Text control in a Form Application in ScriptCase 7.1009

Thanks
Rajibul

would also be intersted in this, I did ad this a feature request some time ago, same as phpword as both would be a great addition to the tool.

PHPExcel is included in SC … (see scriptcase/prod/third/phpexcel).

nice to know where the files are, now be nice to know how to use in the dev environment/…

Look at the samples / documentation at http://phpexcel.codeplex.com/

One sample (I have used a blank application):


require_once $this->Ini->path_third . '/phpexcel/PHPExcel.php';
require_once $this->Ini->path_third . '/phpexcel/PHPExcel/Writer/Excel2007.php';


// Create new PHPExcel object
$objPHPExcel = new PHPExcel();


// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");




// Add some data
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'Scriptcase!');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('D2', 'Scriptcase!');


// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');


        
// Save Excel 2007 file
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));



1 Like

Thank you very much Reinhard.

Where exactly in documentation can we read about it?

http://lmgtfy.com/?q=phpexcel

Thank RHS. But I ment where in SC documentation.
If this is included in SC should be in SC documentation.
This is SO annoying that SC documentation is so bad.

No … the SC documentation (webhelp) is not so bad … you can already work with this. But SC uses open source supplements and the documentation for this can be found at the respective open source products.

SC is considered by many users as “click and ready”, but contribute to proper web applications you have already even still a lot to do …