Re^3: 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!

Comment on Re^3: Openning XML in Excel using CGI

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]
Re^5: Openning XML in Excel using CGI by BaldPenguin (Friar) on Nov 29, 2006 at 22:39 UTC
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]
Re^6: Openning XML in Excel using CGI by rashley (Scribe) on Nov 30, 2006 at 13:01 UTC
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]
Re^7: Openning XML in Excel using CGI by BaldPenguin (Friar) on Nov 30, 2006 at 15:48 UTC
Re^8: Openning XML in Excel using CGI by rashley (Scribe) on Nov 30, 2006 at 17:19 UTC
Some notes below your chosen depth have not been shown here


Problems? Is your data what you think it is?
	PerlMonks