jQWidgets Forums

jQuery UI Widgets Forums Grid Export Excel

This topic contains 5 replies, has 2 voices, and was last updated by  ivailo 9 years, 2 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Export Excel Posts
  • Export Excel #83293

    Rai
    Participant

    Hi, my question is:

    Can export a excel with a filename what I enter in my code?

    Greetings.

    Export Excel #83294

    Rai
    Participant

    Can when I export to pdf, change a orientation of the page?

    Export Excel #83297

    Rai
    Participant

    I found a example with the filename…
    $(“#grilla”).jqxGrid(‘exportdata’, ‘xls’, ‘filename’);

    My next question is:
    the filename has a error when I add a concat

    
    var hoy = new Date();
    var dd = hoy.getDate();
    var mm = hoy.getMonth() + 1;
    var yyyy = hoy.getFullYear();
         if (dd < 10) {
              dd = '0' + dd
         }
         if (mm < 10) {
              mm = '0' + mm
         }
    var hoy = dd + '/' + mm + '/' + yyyy;
    var a = Date.now();
    
    $("#grid").jqxGrid('exportdata', 'xls', hoy);
    

    ERROR:

    
    Warning: fopen(08/04/2016.xls): failed to open stream: No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 4
    
    Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 5
    
    Warning: fclose() expects parameter 1 to be resource, boolean given in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 6
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 47
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 48
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 49
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 50
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 51
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 52
    
    Warning: filesize(): stat failed for 08/04/2016.xls in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 53
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/content/04/8742704/html/subfolder1/export_server/save-file.php:4) in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 53
    
    Warning: readfile(08/04/2016.xls): failed to open stream: No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 54
    
    Warning: unlink(08/04/2016.xls): No such file or directory in /home/content/04/8742704/html/subfolder1/export_server/save-file.php on line 55
    
    Export Excel #83329

    ivailo
    Participant

    Hi Rai,

    It’s not recommended to be used slashes in file name. Please, try to format your file names in different way, without special characters.

    Best Regards,
    Ivailo Ivanov

    jQWidgets Team
    http://www.jqwidgets.com

    Export Excel #83550

    Rai
    Participant

    I want change orientation page on pdf.
    How I do that?

    Export Excel #83594

    ivailo
    Participant

    Hi Rai,

    The orientation of pdf cannot be changed.

    Best Regards,
    Ivailo Ivanov

    jQWidgets Team
    http://www.jqwidgets.com

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.