Universal Data Exporter PHP Support Product Page

Blank (empty) Excel spreadsheet is exported

Asked 17 Apr 2012 00:24:16
have this question
17 Apr 2012 00:24:16 Meredith Foster posted:
I am trying to export out a simple table to an Excel spreadsheet

PHP Version 5.3.3
MySQL 5.1.61
Dreamweaver CS 5.5
Microsoft Office 2007
Universal Data exporter verion 1.1.4

I have a table with one record in it. I am using a recordset like this:
FROM leases

When I run the page, Excel does open, but there is no data exported. The Excel sheet is blank.

The error log has this error:
8 is not a valid MySQL result resource in /var/www/vhosts/website/httpdocs/ScriptLibrary/dmxDataExporter.php on line 790


9 is not a valid MySQL result resource in /var/www/vhosts/website/httpdocs/ScriptLibrary/dmxDataExporter.php on line 920

If I display the table on the page and create a link and apply the ude behavior, then the export to Excel works ok. But, if I try to export from a recordset using the ude servior behavior, I get the above error.

Do you know what the problem might be?


Replied 16 May 2012 01:05:52
16 May 2012 01:05:52 Phil Boyle replied:
I am exporting from a datagrid. It works on local computer and I have it working on another live website and far as I know I've done everything the same.
Replied 16 May 2012 23:17:38
16 May 2012 23:17:38 Phil Boyle replied:
I have it working but it is strange it will export records held in the datagrid up to 35 doesn't work for 40 , works for 45 and doesn't work for 50. I seem to remember the same sort of problem on my other project when I used this.

Reply to this topic