[raja2704]

Hi Team,

Could you please suggest the best possible way to write mysql query results in Spreadsheet with dynamic columns.

Maximum number of records - 75000
Max Columns - 50

This may vary depending upon the query request.

We are trying to write the records from CSV to Spreadsheet. We are working on this.
Did anybody have solution plz share it to us.
If it is possible could you please suggest what will be the maximum records that can be set to spreadsheet.

regards,
Raja

[amosbatto]

These code examples might help you:
http://wiki.processmaker.com/3.1/PM_Tab ... _PM_Tables
viewtopic.php?f=41&t=711112&p=791700&hi ... le#p791653
viewtopic.php?f=44&t=712892&p=794051&hi ... le#p794051

If you want formatting in your spreadsheet, then you should check out PHPExcel library:
http://wiki.processmaker.com/3.0/Trigge ... _PHP_Files
http://wiki.processmaker.com/3.0/Grid_C ... preadsheet

Modern versions of Excel and LibreOffice Calc support up to 1 million rows and 65,000 columns. If you are using Excel 2005 or earlier, there was a limit of 65,000 rows. (Before asking these types of questions that aren't related to PM, please do web searches.)