jquery ui dialog

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
LVL 19
erikTsomikSystem Architect, CF programmer Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ahmed HusseinCommented:
Browsers doesn't support XSL display in browser, you can parse the XSL data and show it inside a custom HTML table.
0
erikTsomikSystem Architect, CF programmer Author Commented:
I mean xls excel format
0
Ahmed HusseinCommented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

erikTsomikSystem Architect, CF programmer Author Commented:
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
erikTsomikSystem Architect, CF programmer Author Commented:
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
Ahmed HusseinCommented:
can you please attache the jQuery code here..
0
erikTsomikSystem Architect, CF programmer Author Commented:
$('#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
Gurpreet Singh RandhawaCEOCommented:
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
erikTsomikSystem Architect, CF programmer Author Commented:
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
Gurpreet Singh RandhawaCEOCommented:
what is currently happening, are you forcing the browser to open the excel file rather than downloading
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JavaScript

From novice to tech pro — start learning today.