public function excelreader()
{
$this->load->library('Spreadsheet_Excel_Reader.php');
$data = new Spreadsheet_Excel_Reader("./data/example01.xls");
// $data = json_decode('{$data}',true);
echo $data->dump(true, true);
}
public function showFormat()
{
//get the link of the file
$file = new Files($this->formatfile_id);
$path = $file->fileWithPath();
if (preg_match("/xlsx\$/", $file->originalname) != 0) {
Yii::import('application.vendors.simplexlsx.*');
$xlsx = new SimpleXLSX($excelfile);
return $xlsx->dump();
} else {
if (preg_match("/xls\$/", $file->originalname) != 0) {
Yii::import('application.vendors.php-excel-reader.*');
$xls = new Spreadsheet_Excel_Reader($excelfile);
return $xls->dump();
}
}
}
public function integrationExcel()
{
$controller = $this->config();
echo "<br />Excel Spreadsheet<br/>";
echo $spreadsheet = $controller->buildExcelTable(1, 1, 1, 1, 1, 1, array(1989, 1992));
$data = new Spreadsheet_Excel_Reader($spreadsheet);
echo $data->dump(true, true);
}
/**
* Displays the login page
*/
public function actionLogin()
{
$data = new Spreadsheet_Excel_Reader("example.xls");
echo $data->dump(true, true);
$model = new LoginForm();
// if it is ajax validation request
if (isset($_POST['ajax']) && $_POST['ajax'] === 'login-form') {
echo CActiveForm::validate($model);
Yii::app()->end();
}
// collect user input data
if (isset($_POST['LoginForm'])) {
$model->attributes = $_POST['LoginForm'];
// validate user input and redirect to the previous page if valid
if ($model->validate() && $model->login()) {
$this->redirect(Yii::app()->user->returnUrl);
}
}
// display the login form
$this->render('login', array('model' => $model));
}
// echo "<tr>";
// for($coluna=0; $coluna<=10; $coluna++){ //Navega na coluna
// if($linha == 2){
// echo "<th>".utf8_decode($dataPhp->getActiveSheet()->getCellByColumnAndRow($coluna, $linha)->getValue()); // Atualiza com caracteres especiais;
// echo "</th>";
// }else{
// echo "<td>".utf8_decode($dataPhp->getActiveSheet()->getCellByColumnAndRow($coluna, $linha)->getValue()); // Atualiza com caracteres especiais;
// echo "</td>";
// }
//// $dataPhp->getActiveSheet()->getCellByColumnAndRow($coluna, $linha)->getValue();//Chama as linhas e colunas;
// }
// echo "</tr>";
//}
//echo "</table>";
//LEITURA EXCEL 1
echo utf8_decode($data->dump(true, true));
//LEITURA CSV
//$delimitador = ',';
//$cerca = '"';
//
//// Abrir arquivo para leitura
//$f = fopen('semana421.csv', 'r');
//if ($f) {
//
// // Ler cabecalho do arquivo
// $cabecalho = fgetcsv($f, 0, $delimitador, $cerca);
//
// // Enquanto nao terminar o arquivo
// while (!feof($f)) {
//
// // Ler uma linha do arquivo
if ($_FILES['file']['error'] == 0) {
$file = explode(".", $_FILES['file']['name']);
$extension = array_pop($file);
/* echo "<script type='text/javascript'> alert('".$extension."'); </script>"; */
if (in_array($extension, $allowed_extensions)) {
$source = $_FILES['file']['tmp_name'];
$t = "Subjective" . time() . "" . date('Ymd') . ".xls";
$target = $upload_path . "/" . $t;
$tempUploadedValue = move_uploaded_file($source, $target);
if ($tempUploadedValue) {
/* echo "<script type='text/javascript'> alert('test1'); </script>"; */
if (($handle = fopen($upload_path . '/' . $t, "r")) !== false) {
$_FILES['file']['name'];
$expiryDate = $_POST['expiryDate'];
$data = new Spreadsheet_Excel_Reader($upload_path . '/' . $t);
$data->dump(true, true);
$data_array = array();
for ($i = 1; $i <= $data->rowcount(); $i++) {
$data_array[$i] = array();
for ($j = 1; $j <= $data->colcount(); $j++) {
$data_array[$i][$j] = $data->val($i, $j);
}
// inner For
}
// outer For
$myFile = $t;
$url = "./excelfiles/" . $t;
$newUploadedQuizURL = $newBaseURL . "/excelfiles/" . str_replace(' ', '%20', $myFile);
$newQuizName = $_POST['questionFileName'];
$newQuizFileName = $myFile;
$duration = $_POST['hours'] * 3600 + $_POST['minutes'] * 60;
public function actionImport()
{
$model = new A();
if (isset($_POST['A'])) {
Yii::import('ext.phpexcelreader.excel_reader2', true);
$model->attributes = $_POST['A'];
$import = CUploadedFile::getInstance($model, 'filee');
if ($import == null) {
Yii::app()->user->setFlash('error', 'File Kosong');
$this->redirect(array(''));
} else {
$import->saveAs('coba/' . $import);
}
if ($import->type == "application/ynd.ms.excel") {
$data = new Spreadsheet_Excel_Reader('/../controller/coba1.xls/');
echo $data->dump(true, true);
$id = array();
$nama = array();
for ($j = 2; $j <= $data->rowcount(); $j++) {
if (empty($data->sheets[0]['cells'][$j][1]) || empty($data->sheets[0]['cells'][$j][2])) {
Yii::app()->user->setFlash('error', 'Data Gagal di Import (File excel harus diisi semua)');
$id[$j] = null;
$nama[$j] = null;
} else {
$id[$j] = $data->sheets[0]['cells'][$j][1];
$nama[$j] = $data->sheets[0]['cells'][$j][2];
}
}
$niki = $data->rowcount(0);
for ($i = 1; $i < $niki; $i++) {
$model = new A();
$model->id = $id[$i];
$model->nama = $nama[$i];
$model2 = A::model()->findByPk($id[$i]);
if ($model2 != null) {
Yii::app()->user->setFlash('error', 'Data Gagal di Import (NIDN sudah ada sebelumnya)');
$this->redirect(array('import'));
} else {
$model->save();
}
}
$this->redirect(array('index'));
} else {
Yii::app()->user->setFlash('error', 'Format file tidak dikenali (format file harus .xls)');
$this->redirect(array('import'));
}
}
$this->render('import', array('model' => $model));
/* $model = new A();
if (isset($_POST['A'])) {
$model->attributes = $_POST['A'];
$itu = CUploadedFile::getInstance($model, 'filee');
$path = 'coba1.xls';
//$itu->saveAs($path);
$data = new Spreadsheet_Excel_Reader('coba1.xls');
}*/
}
function parse_xls_file($params)
{
$params = $params[0];
Common::inc_module_factory('ExcelReader', true);
$data = new Spreadsheet_Excel_Reader(PATH_ . $params['xls_file']);
return $data->dump(false, false, 0, $params['class']);
}
table.excel tbody td {
vertical-align:bottom;
}
table.excel tbody td {
padding: 0 3px;
border: 1px solid #EEEEEE;
}
</style>
</head>
<body>
<?php
$row = 0;
$col = 0;
echo '<table>';
for ($row = 0; $row < 5; $row++) {
echo '<tr>';
for ($col = 0; $col < 5; $col++) {
echo '<td>';
echo $data->val($row, $col);
echo '</td>';
}
echo '</tr>';
}
echo '</table>';
echo $data->dump(true, true);
echo $data->dump(true, true);
?>
</body>
</html>
}
if ($type == 'w') {
return str_replace($conv['utf'], $conv['win'], $str);
} elseif ($type == 'u') {
return str_replace($conv['win'], $conv['utf'], $str);
} else {
return $str;
}
}
if (isset($_POST["act"])) {
require_once 'excel_reader2.php';
$data = new Spreadsheet_Excel_Reader($_FILES['fname']["tmp_name"]);
if ($_POST["clearall"] == 'clearall') {
print "<script>importexcelDialog.clear()</script>";
}
print "<script>importexcelDialog.insert('<p>" . str_replace("\\'", "\\\\'", str_replace("\n", "", Encode($data->dump(false, false, 0, 'price'), 'w'))) . "</p>')</script>";
}
?>
Загрузите файл для вставки в код:
<input type="file" name="fname">
<input type="hidden" name="act" value="send"><br>
<input type="checkbox" name="clearall" checked=checked value="clearall" id="clearall"><label for="clearall">Очистить содержимое перед вставкой</label>
</br>
<div class="mceActionPanel">
<div style="float: left">
<input type="submit" id="insert" name="insert" value="Вставить" onclick="" />
</div>
<div style="float: right">
}), array('db' => '3', 'dt' => 4, 'formatter' => function ($d, $row) {
return substr(html_entity_decode(htmlspecialchars_decode($d, ENT_NOQUOTES)), 0, 15) . "...";
}), array('db' => '4', 'dt' => 5, 'formatter' => function ($d, $row) {
return substr(html_entity_decode(htmlspecialchars_decode($d, ENT_NOQUOTES)), 0, 15) . "...";
}));
$where = "id_kategori = {$id}";
$datatable->get_table($table, $primaryKey, $columns, $where);
break;
case 'view':
ini_set('memory_limit', '-1');
$filesave = $purifier->purify($_POST['filename']);
$data = new Spreadsheet_Excel_Reader($path_upload . $filesave);
echo '<html>
<head>
<title>Sistem Informasi Pelaporan | Ristek Dikti</title>
<link rel="shortcut icon" type="image/png" href="' . $url_rewrite . "static/dist/img/risetdikti.png" . '"/>
<style>
table.excel {border-style:ridge;border-width:1;border-collapse:collapse;font-family:sans-serif;font-size:12px;}
table.excel thead th, table.excel tbody th {background:#CCCCCC;border-style:ridge;border-width:1;text-align: center;vertical-align:bottom;}
table.excel tbody th {text-align:center;width:20px;}
table.excel tbody td {vertical-align:bottom;}
table.excel tbody td {padding: 0 3px;border: 1px solid #EEEEEE;}
</style>
</head>
<body>' . $data->dump(true, true, 1) . '</body>
</html>';
break;
default:
$utility->location_goto(".");
break;
}
<?php
/**
* Argumentos
* $argv[0] Archivo php actual
* $argv[1] Archivo excel
* $argv[2] Hoja
* $argv[3] Patrond e separación para hojas
*/
include "excel_reader2.php";
$data = new Spreadsheet_Excel_Reader($argv[1]);
$sheets = array();
for ($i = 0; $i < count($data->sheets); $i++) {
$sheets[] = $data->boundsheets[$i]['name'];
}
echo json_encode($sheets);
echo $argv[3];
echo $data->dump(true, true, $argv[2]);
private function buildExcelHTML($spreadsheetFile)
{
$data = new Spreadsheet_Excel_Reader($spreadsheetFile);
return $data->dump(true, true);
}
