JsReport-xlsx
-
Is there any proper documentation for xlsx format like for 'html-to-xlsx' and others.
I have gone through the http://officeopenxml.com/SSstyles.php
but unable to find the proper way to handle couple of items.
i) Background of the cell
ii) Width of the cell according to content
iii) how to add image in the template
iv) alignment of the text
Thanks in advance for help
-
Maybe here https://msdn.microsoft.com/en-us/library/dd922181(v=office.12).aspx
Unfortunately quite unreadable.I usually create empty excel with just single feature I'm interested in. Like background color. Then save the xlsx file. Rename it to zip. Analyze what is there.
Then I replicate it with jsreport. The easiest is to style the xlsx as template which is used afterwards. Then you just reference already created styles.
-
You've probably seen them, but here are several examples
https://jsreport.net/learn/xlsx
-
@jan_blaha Thanks, for your quick response. I will look into it.
yes I have gone through these examples, but the above list things are not in these examples.
today I will also go through msdn documentation and excel way through zip.
