====== FDM external reports ======
One of the troubles that I have with [[http://www.filmdistributionmanager.com/wiki/doku.php?id=reports|FDM online]] C# application -- it's working under Linux/Mono environment and use the Carlos/AG XML-writer to create the Excel-compatible reports. This library is working fine, but the XML-files are very big. 

Also there is no way to convert these XML-s into PDF for example. 

To solve it I made the special interface from C# to PHP code using mySQL:

  -C# generates the data for excel report in the format [row, column, text_data]
  -Places these data into the mySQL table
  -Execute the PHP-script by the link (Response.Redirect)
  -The PHP-script opens the excel-template file (native *.xls)
  -Open the mySQL table
  -Write the data cells into the excel template from this table
  -Save the result as an Excel xls-native file and send it into response

So we have native small excel97 generated from data by C# code.

Of course the script clear the temporary table 'external_report' every time on complete.

The library PHPExcel allow also to save excel spreadsheets in PDF-format, that's useful for email robots.