Solved

jquery ui dialog

Posted on 2013-05-28
10
200 Views
Last Modified: 2013-08-05
I am building a coldfsuion report. Where one of the options is to show ther report in xls.

So I am displaying the report in jquery ui dialog. for html format it shows fine , but when I do XLs it still shows the html.

on the calling file

 I do this
<cfheader name="Content-Disposition" value="attachment; filename=acmesalesQ1.xls">
      <cfcontent type="application/vnd.msexcel">
      <cfheader name="Pragma" value="">


#saveContent#

savecontent is the variable name of the <cfsabecontent what I am I doing wrong
0
Comment
Question by:erikTsomik
  • 5
  • 3
  • 2
10 Comments
 
LVL 4

Expert Comment

by:Ahmed Hussein
Comment Utility
Browsers doesn't support XSL display in browser, you can parse the XSL data and show it inside a custom HTML table.
0
 
LVL 19

Author Comment

by:erikTsomik
Comment Utility
I mean xls excel format
0
 
LVL 4

Expert Comment

by:Ahmed Hussein
Comment Utility
Yeeep sorry too, xls. You have to parse it on the server and show it in custom html table, since browsers doesn't support showing XLS data.

~AG
0
 
LVL 19

Author Comment

by:erikTsomik
Comment Utility
but I am overwriting the header with coldfusion

<cfheader name="Content-Disposition" value="attachment; filename=acmesalesQ1.xls">
      <cfcontent type="application/vnd.msexcel">
      <cfheader name="Pragma" value="">
0
 
LVL 19

Author Comment

by:erikTsomik
Comment Utility
and really I just want to show the popup which will ask the user to show the data in xls format not show the excel in the browser
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 4

Expert Comment

by:Ahmed Hussein
Comment Utility
can you please attache the jQuery code here..
0
 
LVL 19

Author Comment

by:erikTsomik
Comment Utility
$('#frm').submit(function(e) {
                        if($(this).valid()) {

                              
                        var link = 'index.cfm';
                              
                              



                              $("#dialog").html("<h3>Please Wait ... </h3>");
                              $("#dialog").dialog({
                                    dialogClass: 'no-close',
                                    resizable: true,
                                    draggable: false,
                                    modal: true,
                               width: 1200,
                                    height: 400,
                                    open: function (event, ui) {
                                  $(this).load(link + '&' + $("#frm").serialize());
                              },
                                    buttons: {
                                          "CLOSE": function(){
                                                $(this).dialog("close");
                                                $(this).html("");
                                          }
                                    }
                              })

                              return false;
                        }
                  });
0
 
LVL 15

Expert Comment

by:myselfrandhawa
Comment Utility
umm,

Not sure what to say:

1. Are you trying to show excel data in browser
2. Are you focing the Browser to show the data as XLS way in Browser like Formatting and all.

If 1, You can always do <cfoutput> the cfsavecontent text and it will show data.

id 2, that is not possible for browser to render it just like the way excel does.

for 2, you can either use Datatables to show the Records and have sorting and searching and pagination features or use cfgrid or use some custom Tag
0
 
LVL 19

Author Comment

by:erikTsomik
Comment Utility
no I am not trying to show excel in the browser. As I said I want <cfheader will force the page to open a file in the xls format
0
 
LVL 15

Accepted Solution

by:
myselfrandhawa earned 500 total points
Comment Utility
what is currently happening, are you forcing the browser to open the excel file rather than downloading
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now