Good xls exporter to generate excel sheets automatically with a few macros from any programming language?

We have a system which generates reports in XLS using Spreadsheet_Excel_Writer for smaller files and in case of huge files we just export them as CSVs.

We now want to export excel sheets which are multicolor etc. as a part of report generation, which in excel could be done through a few macros.

Is there any good exporter which generates the excel sheets with mac开发者_如何转开发ros?(Spreadsheet_Excel_Writer cant do this) If it exists for PHP it would be amazing but if it exists for any other language, its fine we could interface it.

It's your "excel sheets with macros" that is going to cause you all end of problems. If you're on a Windows platform, with Excel installed, then PHP's COM extension should allow you to do this. Otherwise, I'm nor aware of any PHP library which allows you to create macros... not even PHPExcel. I suspect the same will apply with most languages, other than perhaps those running with .Net (and possibly Mono).

However, do you really need macros to play with colour? Can't you do this more simply with styles, and perhaps conditional formatting?

PS. What's your definition of "huge"?