Export to PDF or Excel using Python/Django/MySQL backend

Suite and Optimus Suite 5
#1

Hi folks,

Is there an example somewhere showing how one would export to PDF and/or an Excel spreadsheet using Django/Python/MySQL as the backend server?

Thanks,
Kurt

#2

Hi Kurt,
unfortunately we don’t provide export script on Python, but you may use online export service like this:

<input type="button" value="To PDF" onclick="mygrid.toPDF('http://dhtmlxgrid.appspot.com/export/pdf');" />
<input type="button" value="To Excel" onclick="mygrid.toPDF('http://dhtmlxgrid.appspot.com/export/excel');" />

Such way gives ability to export grid without installing export script at your server.

#3

Thanks, was searching for this and saw an old post of mine :slight_smile:

We may be exporting sensitive data, is it secure? does the server cache or log anything?

Thanks in advance.

#4

Hi,
no, server doesn’t log or cache anything, just generates pdf/excel file and returns it to user.

#5

We did get our internal php server running for just export, I posted a question here:

viewtopic.php?f=2&t=28917

Maybe should move it to this forum?

Basically we don’t see our subgrids in the exported excel spreadsheet.

#6

Hi,
unfortunately grid-export doesn’t support exporting sub-grids.