How to build graphs and charts based on an xls document?

Question

PHP

Hey!
There is an xls (excel) file on the server, which is constantly changing.
I would like to display graphs based on this data on the web face.
web server - nginx

Answer 1

There are actually many solutions, depending on the tools and restrictions you use.
eg:
1. track file changes. for example, using inotify-tools or a cron script
2. if the file has changed, parse the data and push it into the cache, or into a json file that can be loaded into the chart widget.

Answer 2

You can open this xls file on the server, for example with this: PHPExcel , or with these , and then visualize with javascript, for example with this: chartjs , or with these .

Answer 3

I did the same on Python3.3
Here is an excellent library for that case xlsxwriter.readthedocs.org/en/latest/index.html
If necessary, I can throw off my example