<dtml-call expr="RESPONSE.setHeader('Content-type', 'xyz')"> this should be at the top of your "exportDirectlyToExcel.csv" method jens on 2/15/01 14:37, Lee Reilly CS1997 at lreilly@cs.strath.ac.uk wrote:
Here's some crude code to do what you want. Note that some lines are broken by my emailer and excel may be picky about extra white space.
yourMethodName.csv:
Content-type: application/ms-excel <snip>
Hi,
I've developed some import/export functions myself taking database info to/from CSV and/or tab delimited text files. Originally, I just displayed the output to the user directly (in text form) but as I've seen from the past few messages, I can have it displayed directly in Excel. I have had success with this in IE but Netscape is giving me "jip"...
Simplified version below:
Id: exportDirectlyToExcel.csv Title: exportDirectlyToExcel.csv -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ <dtml-in get_matrics_from> <dtml-var expr="export(_.this, classcode, matric)"> </dtml-in> -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
When I open this document in IE it opens Excel automatically but it only opens the text representation when I open it Netscape. I presume that adding a content-type would remedy this but where and how do I add it?
"Content-type: application/ms-excel" at the head of the page doesn't help. Including it in <HEAD><META> tags isn't helping either. Can anyone tell me the solution?
Here's a sample output...
9728430, Lee, Reilly, lreilly, 8, 2, 0, 0, 0, 0, 0, 0, 0, *, *, 0, 0 9702709, Gordon, Macleod, gmacleod, 25, 0, 3, 0, 0, 0, 0, 0, 0, *, *, 0, 0 9702075, Alan, Hamilton, ahamilto, 7, 0, 0, 4, 0, 0, 0, 0, 0, *, *, 0, 0 9712346, Alec, Littlechild, alittlec, 5, 0, 0, 0, 5, 0, 0, 0, 0, *, *, 0, 0 9712347, Fernando, Ricksen, fricksen, 8, 0, 0, 0, 0, 6, 0, 0, 0, *, *, 0, 2 9712349, Arthur, Numan, anuman, 3, 0, 0, 0, 0, 0, 7, 0, 0, *, *, 0, 2 9712351, Chris, Sutton, csutton, 10, 0, 0, 0, 0, 0, 0, 8, 0, *, *, 0, 2 9712352, Claudio, Cannigia, ccannigi, 12, 0, 0, 0, 0, 0, 0, 0, 9, *, *, 1, 0 9712350, Henrik, Larsson, hlarsson, 9, 0, 0, 0, 0, 0, 0, 0, 0, *, *, 0, 0
What can I add to this to make Netscape realise it's an Excel file and open in accordingly?
Cheers in advance ;-)
Lee