'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 my excel where I have a placeholder not into a specific cell, looking for something similar to phpword eg. setValue($placeholder,'John')

I've been looking for a solution for quite a while now but I can't find any function to help me out.



Solution 1:[1]

You can try it.

    $spreadSheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet;
    $placeholder = 'D'
    $i = 5;
    $spreadSheet->getActiveSheet()->setCellValue($placeholder . $i, 'John');

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 poppies