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

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!

Replies are listed 'Best First'.
Re^4: Openning XML in Excel using CGI
by rashley (Scribe) on Nov 29, 2006 at 18:33 UTC
    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]
        Yes, that works fine. I don't see any of these problems when I save to disk and open it. Unfortunately, the client wants the "Open" option as well.
[reply]

In Section Seekers of Perl Wisdom