python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
is there a way to put placeholders in excel files using phpspreadsheet?
is there any way to get placeholders in my excel file using phpspreadsheet? all I see I can do is using a specific cell to put my data into it
eg. setCellValue('A1','John')
I want to insert data into ...
CTD
Votes: 0
Answers: 1
Display time range formatted with PhpSpreadsheet
I'm using PHPSpreadsheet to generate an XLS file with report data, and in some situations, display an XLS formatted as HTML on screen.
How can I display a formatted time range in an Excel worksheet?
I...
Tom
Votes: 0
Answers: 1
PhpSpreadsheet Date::PHPToExcel() adding time
I am trying to add a date field into an Excel file without the time portion.
This is my current code:
$dt = !empty($date) ? Date::PHPToExcel(DateTime::createFromFormat('Y-m-d', $date)) : null;
$spread...
dokgu
Votes: 0
Answers: 1
PHPSpreadsheet setAutoSize function not working as expected
I am using PHPSpreadsheet and I'm doing the following to autosize the relevant columns:
foreach (range('A', 'K') as $col) {
$productsSheet->getColumnDimension($col)->setAutoSize(true);
}
Th...
Matthew Knill
Votes: 0
Answers: 0