Author Topic: Export problem, Excel Columns, Zip File and Open/Save  (Read 2128 times)

bwt

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 17
    • View Profile
Export problem, Excel Columns, Zip File and Open/Save
« on: April 02, 2020, 11:37:52 am »
Good day,
I'm a novice testing the PRO evaluation version.

1) Export Problem
I have implemented this demo https://paramquery.com/pro/demos/export with my data in the localhost, but I'm facing a problem during export: No error but nothing happens. Is it due that it is an evaluation version?

2) Excel Columns
I wish to create a report with columns that I can create setting the borders. Can I set an A4 page in order to have the paging of the data and where to use also the page header/footer? See attach, please.

3) Zip file
I see that is possible to export as Zip File containing the JSON tables. Is it correct? Can I create a zip file containing all the JSONs tables in one file?

4) Open/Save
Is it possible to open/save the zip file in the remote Drive (Dropbox or similar) and/or in the PC local HD?

10x in advance for your support
Regards

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile
Re: Export problem, Excel Columns, Zip File and Open/Save
« Reply #1 on: April 07, 2020, 04:55:00 pm »
1) That example involves the server side code to export Excel file.

Alternatively Excel file can also be exported locally without help of server side code:

Please follow this example: https://paramquery.com/pro/demos/export_local

2) pqgrid doesn't have printing options or header / pagers on A4.

3) You would need to check out jsZip. https://github.com/Stuk/jszip

4) You would need to write server side code to save it remotely.

bwt

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 17
    • View Profile
Re: Export problem, Excel Columns, Zip File and Open/Save
« Reply #2 on: April 10, 2020, 09:33:54 pm »
10x for your clarifications.

Regards
Carlo