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 17: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!
[reply]
      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.

[reply]
        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!
[reply]

In Section Seekers of Perl Wisdom