Beefy Boxes and Bandwidth Generously Provided by pair Networks vroom
Keep It Simple, Stupid
 
PerlMonks  

Re^2: Openning XML in Excel using CGI

by rashley (Scribe)
on Nov 29, 2006 at 11:46 UTC ( [id://586742]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to Re: Openning XML in Excel using CGI
in thread Openning XML in Excel using CGI

You are correct, the users on on Windows.

I'm not explicitly setting a file extension or name. Using vnd.ms-excel, it comes through as the name of my CGI with .xls tacked on the end.

The 'Open' menu is what's giving me the touble.

Most of my users are on Excel 2002, SP3. But this may not always be the case.

Replies are listed 'Best First'.
Re^3: Openning XML in Excel using CGI
by BaldPenguin (Friar) on Nov 29, 2006 at 12:44 UTC
    Try changing the file extension or explicitly setting it to 'xml'. Then try double-clicking as well to see how that works. Are you actually using SpreadSheetML or just simple xml? My results didn't improve in this respect until I started using SpreadSheetML (xlxml).

    Excel 2002 should recognize the .xml extension for it's file, while 2003 prefers .xlxml.

    Don
    WHITEPAGES.COM | INC
    Everything I've learned in life can be summed up in a small perl script!
      I'm using simple xml, and I'm not sure how to explicitly set the filename.

      Double-clicking what? It's a submit button that triggers the whole thing.

        By double-clicking, I mean to save the file to disk and then dbl-clk in the Windows Explorer.

        Don
        WHITEPAGES.COM | INC
        Everything I've learned in life can be summed up in a small perl script!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://586742]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.