search

aVadim483 / fast-excel-templator

Lightweight and very fast Excel Spreadsheet generator from XLSX-templates in PHP
MIT License
9 stars 1 forks source link

Xslx with shared strings (fixed dropdown values) - is it possible to template. #2

Open julianthompson opened 9 months ago

julianthompson commented 9 months ago

I have been given a xlsx template to populate with lots of cells with fixed drop downs (shared strings?) - like 'Yes' and 'No'... It is possible to set these properly using templator? Excel seems to set them as "shared string" (?) integer values, but templator just replaces these with a string value. I can find the values of the shared strings.

excel-dropdown-example-1 excel-dropdown-example-2

If I get the row template:

$rowTemplate = $sheet->getRowTemplate(3); dpm($rowTemplate);

I get the following definition for the cell:

excel-dropdown-example-j-column-data-format