Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/anjal_vaathi/post/admin255

Free Space:

10.25 TB

🔧 Quick Actions

✏️ Editing: SimpleExcelReader.php

<?php
// SimpleExcelReader.php - Lightweight Excel reader for XLSX files (no external libraries needed)
class SimpleExcelReader {
    
    /**
     * Read XLSX file and return as array
     */
    public static function readXLSX($filePath) {
        $data = [];
        
        try {
            // Open the XLSX file as a ZIP archive
            $zip = new ZipArchive();
            if ($zip->open($filePath) === true) {
                // Read the shared strings file (for text values)
                $sharedStrings = [];
                $stringsXml = $zip->getFromName('xl/sharedStrings.xml');
                if ($stringsXml) {
                    $xml = simplexml_load_string($stringsXml);
                    if ($xml) {
                        foreach ($xml->si as $si) {
                            $sharedStrings[] = (string)$si->t;
                        }
                    }
                }
                
                // Read the worksheet
                $sheetXml = $zip->getFromName('xl/worksheets/sheet1.xml');
                if ($sheetXml) {
                    $xml = simplexml_load_string($sheetXml);
                    if ($xml) {
                        $rows = [];
                        $currentRow = [];
                        
                        foreach ($xml->sheetData->row as $row) {
                            $rowData = [];
                            foreach ($row->c as $cell) {
                                $value = (string)$cell->v;
                                $type = (string)$cell['t'];
                                
                                // Handle different cell types
                                if ($type == 's' && isset($sharedStrings[$value])) {
                                    $value = $sharedStrings[$value];
                                } elseif ($type == 'str') {
                                    $value = (string)$cell->v;
                                } elseif ($type == 'inlineStr') {
                                    $value = (string)$cell->is->t;
                                }
                                
                                $rowData[] = $value;
                            }
                            if (!empty($rowData)) {
                                $data[] = $rowData;
                            }
                        }
                    }
                }
                $zip->close();
            }
        } catch (Exception $e) {
            error_log("Excel read error: " . $e->getMessage());
        }
        
        return $data;
    }
    
    /**
     * Read XLS file (older format) - convert to array
     * Note: For XLS files, you'll need to use the CSV approach or advise users to convert
     */
    public static function readXLS($filePath) {
        // XLS files are binary and require external libraries
        // Return false to indicate we need CSV conversion
        return false;
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: SimpleExcelReader.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation