Antuanett

"asassak jsnksknm4m kfklmdf <sfd5llkjkj>  jsdjsdihgbwjbfbw"

/<([^а-яё>]){6,}>/i

<?php
 
class actionPricelisterUploadprice extends cmsAction {
 
    public function run(){
        cmsCore::includeFile('system/libs/PHPExcel/Classes/PHPExcel/IOFactory.php');
        $form = $this->getForm('priceupload');
        $is_submitted = $this->request->has('submit');
        if ($is_submitted){
             $errors = false;
            //
            // Парсим и валидируем форму
            //
            if (!$errors){
                $data = $form->parse($this->request, $is_submitted);
                $errors = $form->validate($this,  $data);
            }
 
            if (!$errors){
                $config = cmsConfig::getInstance();
                $file_path = $config->upload_path . $data['file']['path'];
                $inputFileType = PHPExcel_IOFactory::identify($file_path);
                $objReader = PHPExcel_IOFactory::createReader($inputFileType);
                $objReader->setReadDataOnly(true);
                $xls = $objReader->load($file_path);
                $xls = PHPExcel_IOFactory::load($file_path);
                $xls->setActiveSheetIndex(0);
                $sheet = $xls->getActiveSheet();
                echo "<table>";
                    for ($i = 1; $i <= $sheet->getHighestRow(); $i++) {  
                        echo "<tr>";
                        $nColumn = PHPExcel_Cell::columnIndexFromString(
                            $sheet->getHighestColumn());
                        for ($j = 0; $j < $nColumn; $j++) {
                            $value = $sheet->getCellByColumnAndRow($j, $i)->getValue();
                            echo "<td>$value</td>";
                        }
                        echo "</tr>";
                    }
                echo "</table>";
                dump($file_path);
            }
 
            if (!$errors){
                if ($result['success']){
 
                    if ($back_url){
                        $this->redirect($back_url);
                    } else {
                        $this->redirectToHome();
                    }
 
                } else {
                    $errors = $result['errors'];
                }
 
            }
 
        }
 
        return cmsTemplate::getInstance()->render('uploadprice', array(
            'data' => $data,
            'form' => $form,
            'errors' => isset($errors) ? $errors : false
        ));
 
    }
}

 
$fileinc='/var/www/html/system/libs/PHPExcel/Classes/PHPExcel/IOFactory.php';
include($fileinc);
 

 
class MyReadFilter implements PHPExcel_Reader_IReadFilter 
{ 
    private $_startRow = 0; 
    private $_endRow   = 0; 
    private $_columns  = array(); 
 
    /**  Get the list of rows and columns to read  */ 
    public function __construct($startRow, $endRow, $columns) { 
        $this->_startRow = $startRow; 
        $this->_endRow   = $endRow; 
        $this->_columns  = $columns; 
    } 
 
    public function readCell($column, $row, $worksheetName = '') { 
        //  Only read the rows and columns that were configured 
        if ($row >= $this->_startRow && $row <= $this->_endRow) { 
            if (in_array($column,$this->_columns)) { 
                return true; 
            } 
        } 
        return false; 
    } 
}
 

    // Если форма была отправлена
    if ($is_submitted) {
        // Получаем (request) и парсим (parse) данные из формы
        $data = $form->parse($this->request, $is_submitted);
    }