php + excel: forming xls\xlsx, filling cells with data and generating charts

R

rsaReliableS2011-08-04 10:35:52

PHP

rsaReliableS, 2011-08-04 10:35:52

Hello. It is necessary to generate xls\xlsx file. In addition to filling the cells with data, you need to generate a chart. Please suggest a library for this purpose. I looked in the direction of Simple XLSX and PHPExcel - they do not support chart generation.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

V

Vorchun, 2011-08-04
@Vorchun

phpexcel.codeplex.com/ xslx only Used in several projects. The rest of the solutions didn't work.

C

cat_crash, 2011-08-04
@cat_crash

On *nix, you are unlikely to plot graphs in Excel. If hosting under Win - look towards COM

V

Vadim, 2011-08-04
@vshemarov

In general, it’s hard for me to imagine in what situation such a task can arise - it’s not just to create Excel files from PHP, but to generate graphs in them. But if it really is necessary, then I would go this way - I would create templates in Excel, I would rattle the necessary charts there, and I would not create a file from PHP, but fill them with data in predetermined ranges to which the charts are tied.

A

Anton, 2011-08-04
@sHinE

Xslx is a set of xml in a zip archive. Graphs there, too, as far as I understand, are stored in xml. However, you can generate graphics with third-party libraries as pictures and then insert them into xslx.
I usually do this - I create the necessary file in Excel, change it to zip and see what is there and where it is.