Forum


Replies: 1   Views: 1330
Change data in excel sheet embedded in a word document
Topic closed:
Please note this is an old forum thread. Information in this post may be out-to-date and/or erroneous.
Every phpdocx version includes new features and improvements. Previously unsupported features may have been added to newer releases, or past issues may have been corrected.
We encourage you to download the current phpdocx version and check the Documentation available.

Posted by guenlm  · 02-12-2019 - 12:42

Hello

All is in the title... I use Word docx template and I would like to put a table in an excel sheet with formula and conditionnal formatting. I try to change the data value's in this sheet from phpDocX but... nothing change... I tried to put the $$ placeholder in the cell or to change the name of the cell but noting to do...

How can I do that please? I hop it's possible ! (beacause I really need conditionnal formatting in existing table in Word template...)

Than'ks

Guen

Posted by admin  · 02-12-2019 - 13:11

Hello,

phpdocx allows changing data chart title, legends and values using replaceChartData (https://www.phpdocx.com/api-documentation/docxutilities/replace-chart-data-Word-document).

XLSXUtilities allows changing placeholders in XLSX files, but not in embedded XLSX files, as the API pages detail (https://www.phpdocx.com/api-documentation/xlsxutilities/search-keyword-Excel-document-and-replace-it-with-PHP).

We move the request to the dev team to consider adding support. Using the current version it may require a manual workflow:

1. Open the DOCX and extract the embedded XLSX and change the placeholders.

2. Add the updated XLSX to the DOCX file again.

3. Refresh some internal rels if needed.

If you open a ticket (https://www.phpdocx.com/support), the dev team can generate a script to accomplish this kind of special workflows that aren't supported yet.

Regards.