📄 File: dump_rows.php

Path: /home2/outerorb/emp.outerorbittech.in/scripts/dump_rows.php

Size: 484 B

Permissions: 0666

<?php
require __DIR__ . '/../vendor/autoload.php';
$file = __DIR__ . '/../uploads/att/18-MAR-2026.xls';
$ss = \PhpOffice\PhpSpreadsheet\IOFactory::load($file);
$sheet = $ss->getActiveSheet();
$rows = array_values($sheet->toArray(null,true,true,true));
$out = [];
$limit = min(80, count($rows));
for ($i=0;$i<$limit;$i++){
    $r = array_values($rows[$i]);
    $out[] = ['index'=>$i+1,'row'=>$r];
}
echo json_encode($out, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);

← Back to Directory Edit File 🔒 Chmod