Announcement

Collapse
No announcement yet.

PHPExcel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    __________________
    S. M. Rajibul Huda
    CEO & Founder
    www.efficienterp.com

  • #2
    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.

    Comment


    • #3
      PHPExcel is included in SC ... (see scriptcase/prod/third/phpexcel).
      Best regards: - Reinhard -

      I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

      Comment


      • #4
        Originally posted by RHS View Post
        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/...

        Comment


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

          One sample (I have used a blank application):

          Code:
          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__));
          Best regards: - Reinhard -

          I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

          Comment


          • #6
            Thank you very much Reinhard.
            __________________
            S. M. Rajibul Huda
            CEO & Founder
            www.efficienterp.com

            Comment


            • #7
              Originally posted by RHS View Post
              PHPExcel is included in SC ... (see scriptcase/prod/third/phpexcel).
              Where exactly in documentation can we read about it?
              Using Ubuntu Linux 13.04 and SC Professional MySQL 7.1.last
              We need: good and complete documentation written in proper English

              Comment


              • #8
                http://lmgtfy.com/?q=phpexcel
                Best regards: - Reinhard -

                I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                Comment


                • #9
                  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.
                  Using Ubuntu Linux 13.04 and SC Professional MySQL 7.1.last
                  We need: good and complete documentation written in proper English

                  Comment


                  • #10
                    Originally posted by kornelkornecki View Post
                    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 ...
                    Best regards: - Reinhard -

                    I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                    Comment

                    Working...
                    X