ScriptCase v8.0.044 (05-07-2015 20:52)

Scriptcase 8 Changelog
#1

New functionalities

  • Added PHPExcel (Need to update production environment)
    (For users that use the separate production environment for the publications, you need to update it. Through our website you can download. For the rest, just leave marked the “Update production environment” during automatic update ScriptCase.)
  • Added new project theme.
  • Added support for border radius in content of project themes.

Specific correction

  • Fixed problem in generating XLSX files in the Grid application.
  • Fixed problem in the project version history view.

Bug

  • Fixed problem in the conversion of Access databases using ADO connection.
  • Fixed problem in the lookup preview at charts.
  • Fixed problem in the conversion of Access databases to SQL Server.
  • Fixed problem in the application navigation when it has a multiple line field.
  • Fixed the CHARSET problem when using macro sc_exec_sql with specific connection.
  • Fixed problem in the changes validation in the Report PDF events.
  • Fixed problem when importing files named with special characters in document fields (File Name) in the form editable grid with Oracle.
#2

- Added PHPExcel

And how to use it? or is added just for exportation?

#3

http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/05/07/4606.aspx has some nice info…
Of course you could (if running windows) instead of using phpexcel simply use an odbc connection to your spreadsheet with your excel spreadsheet or use COM (only if excel is installed). But those are the simple alternatives.

#4

Hi,

This class PHPExcel is great, there is any way to update also third party class for swiftmailer, i found many features on their changelog.

Great work!

#5

how to update “update production environment”

is the _lib folder?

#6

Hi,

After deploy is finished you must click on “Click to Download the common libraries” and there is a zip with all libraries updated.

#7

[QUOTE=Giu;36389]- Added PHPExcel

And how to use it? or is added just for exportation?[/QUOTE]

Hello,

Unfortunately it is just for export. We had to upgrade our library in export EXCEL to fix some problems with images export images in XLSX files.
As you have seen the documentation, feel at ease to the report as a suggestion and we will examine the case for implementations.

It is also worth remembering that you can use the sc_include_lib macro.
http://www.scriptcase.net/docs/en_us/v8/scriptcase-macros/scriptcase-macros#sc_include_lib

Example in the Blank application:


// Using ScriptCase's Macro
sc_include_lib ("excel");

// Create new PHPExcel object
echo date('H:i:s') . " - Create new PHPExcel object<br />";
$objPHPExcel = new PHPExcel();

// Set properties
echo date('H:i:s') . " - Set properties<br />";
$objPHPExcel->getProperties()->setCreator("ScriptCase");
$objPHPExcel->getProperties()->setLastModifiedBy("ScriptCase");
$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
echo date('H:i:s') . " - Add some data<br />";
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'ScriptCase');
$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Example');
$objPHPExcel->getActiveSheet()->SetCellValue('A2', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'World!');

// Rename sheet
echo date('H:i:s') . " - Rename sheet<br />";
$objPHPExcel->getActiveSheet()->setTitle('Simple');

        
// Save Excel 2007 file
echo date('H:i:s') . " - Write to Excel 2007 format<br />";
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));

// Echo done
echo date('H:i:s') . " - Done writing file.<br />";
echo "<a href='index.xlsx'>Download file</a>";