MarkBaker on Minor-Documentation-Updates
MarkBaker on PhpStan-Cleanups
MarkBaker on master
Declare a few return datatypes Merge pull request #2857 from P… (compare)
MarkBaker on master
Declare a few return datatypes Merge pull request #2858 from P… (compare)
MarkBaker on PhpStan-Cleanups
MarkBaker on Minor-Documentation-Updates
Declare a few return datatypes Declare a few return datatypes (compare)
Hey, guys! I have a big problem with an corrupted xls file. And I could not understand why.
Code is as simple as i sent earlier
$nombreDelDocumento = "Descarga_paqar.xlsx";
$writer = new Xlsx($documento);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $nombreDelDocumento . '"');
header('Cache-Control: max-age=0');
$writer = IOFactory::createWriter($documento, 'Xlsx');
ob_end_clean();
$writer->save('php://output');
exit;
Hi,
I have found that the useful Excel tables feature is missing in the PHPSpreadsheet library. Issue PHPOffice/PhpSpreadsheet#1816.
After some research on how the feature is implemented in exceljs, I'm planning to contribute on adding this feature to PHPSpreadsheet.
I'm here seeking any advice from the team before start working. If I file a pull request, will it merge?
any idea what causes this error? Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Reader\Exception: Parameter pos=-12 is invalid
$inputFileName = "excel.xls"; $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xls'); $spreadsheet = $reader->load($inputFileName);
file: https://filebin.net/sle19tm0kdgduyne/excel.xls?t=u0itbeue
Hi Alex, I am not sure if you can remember how you resolved this issue? Parameter pos=-12 is invalid
Hello,
How can I display a formatted time range in an Excel worksheet?
I have a range of 25:30 hours that I would like to show using HH:MM:SS format, but if I use the code below it shows as 01:30:00.
$seconds = 91800;
$spreadsheet->getActiveSheet()->setCellValueExplicit('L' . $row, (seconds / 86400) , PHPExcel_Cell_DataType::TYPE_NUMERIC);
$spreadsheet->getActiveSheet()->getStyle('L'.$row)->getNumberFormat()->setFormatCode('HH:MM:SS');
hello guys,how to set limit to output data when i try to read excel data ,i need to set pagination,cant set limits ,how to resolve that?and i need to display the data as html in browser.,without null values.
Why don't u save the data in other place from excel, so u can paginate it easily.
Hi i need to show dropdown of country,state,city
based upon dropdown values should reflect,also address,streeet input box should show and hide can anyone tell me how to do using spreadsheet?
https://phpspreadsheet.readthedocs.io/en/latest/topics/recipes/#setting-data-validation-on-a-cell
Here is the doc above
how to export existing template without losing style?
Do u refer to the documention here?
Hi Everyone
I am having some issues when using getCalculatedValue. Some cells work okay in retrieving the value, but some other simply copies the formula.
Here's what I am trying to do
I want to copy the values in sheet "kirim SAP" (hidden sheet), to a separate new file. So formula containing sheet references need to be calculated before set in the new file.
Here's the source file.
https://docs.google.com/spreadsheets/d/1ShijpIDOXZhSNeUqaOh61WvRT2r7VZC5/edit?usp=sharing&ouid=109095039939818888420&rtpof=true&sd=true
Here's the output on the new file. Please mind that I expect new rows in this file for each trigger.
https://docs.google.com/spreadsheets/d/1ObN4Fnso6zigIjan1XXRV-zYC-CQFKyo/edit?usp=sharing&ouid=109095039939818888420&rtpof=true&sd=true
is there something i need to do to make it work? I checked the doc for supported formulas https://phpspreadsheet.readthedocs.io/en/latest/references/function-list-by-name/, but all that we used seem to be supported
Here's a snippet of my code to achieve this.
$lastColumn='A';
$row=1;
$spreadsheet->setActiveSheetIndex($spreadsheet->getSheetCount()-1);
$sheet = $spreadsheet->getActiveSheet();
$highestColumn = $sheet->getHighestColumn();
$highestRow = $sheet->getHighestRow();
$arr=array();
try{
for($row=1;$row<=$highestRow;$row++){
for($lastColumn='A';$lastColumn!=$highestColumn;$lastColumn++){
$arr[$lastColumn.$row]=$sheet->getCell($lastColumn.$row)->getCalculatedValue();
}
}
$stInsertData = $connection->prepare("insert into asmt_report_result values(DEFAULT, :template, :participant, :fields);");
$successInsertData=$stInsertData->execute(array(':template'=>$_GET['template'], ':participant'=>$_GET['participant'],':fields'=>json_encode($arr)));
}catch(Exception $e){
throw $e;
}
$sheet->setSheetState(Spreadsheet::VISIBILITY_HIDDEN);
$randomName=date("Ymd");
if(empty($arr['A2'])||$arr['A2']==0){
$randomName="candidate_".date("Ymd");
}else{
$randomName="internal_".date("Ymd");
}
$spreadsheet2 = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
if(file_exists("../my_tmp/scpuserhris/".$randomName.".xlsx")){
//echo "file exists";
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$spreadsheet2 = $reader->load("../my_tmp/scpuserhris/".$randomName.".xlsx");
}else{
//echo "file not exist";
}
$sheet2 = $spreadsheet2->getActiveSheet();
$highestRow = $sheet2->getHighestRow();
$highestRow+=1;
for($lastColumn='A';$lastColumn!=$highestColumn;$lastColumn++){
$sheet2->setCellValue($lastColumn.$highestRow, $lastColumn=='A'&&empty($arr[$lastColumn.'2'])?'0':$arr[$lastColumn.'2']);
//echo $lastColumn.$highestRow."=".$arr[$lastColumn.'2']."<br/>";
}
$writer2 = new Xlsx($spreadsheet2);
$filePath2 = "../my_tmp/scpuserhris/".$randomName.".xlsx";
$writer2->save($filePath2);