Regarding excel recipe and number/percentage formatting to cell
-
Re: Regarding excel recipe and number/percentage formatting to cell
Hi jan_blaha sorry I totally forgotten to update my playground link, please find below my link, as you can see try run and download it, the chart unable to run it as it recognize as varchar/text/string instead of number.
-
Here is it fixed
https://playground.jsreport.net/w/anon/nvAGwt8sYou should do something like this to insert number
<c s="{{@root.$removedItem.c.[1].$.s}}"><v>{{percent}}</v></c>
-
ah thanks! another quick questions, if I have multiple tables to be inserted into the excel, I finding it hard to get it prefect to do it, is there any tips or way to execute it?
-
Is the number of tables static? Then you can follow the table example linked in the docs
https://playground.jsreport.net/w/anon/Hy_V2BSh-4
-
Not really, the tables will be dynamic...
-
I see, unfortunately, we don't have examples for this, so you are going to need to create an excel with few tables, decompress the docx and analyze how are the tables defined. Then you can replicate the same using xlsx helpers.
