What format will excel "auto-parse"

B

Bura Tino

Hi,

I have a web server which I would like to output information in a format
that can be copied&pasted into excel in such a way that the user does not
have to follow up this step with the Text To Colomns feature. I'm outputing
plain text and my MIME type is "text/plain". I'm delimiting my would-be
columns with tabs but that doesn't seem to do the trick.

Thanks!

Bura
 
M

macropod

Hi Bura,

If you copy tab-delimited data & paste them into Excel, Excel will
automatically separate the data into columns.

Alternatively, if you separate the data with commas, and use 'csv' as the
file extension, Excel will open the file with the data automatically
separated into columns.

Cheers
 
J

Johan Nordberg

Use Tabs to separate columns, and CrLf to seperate rows. In VBScript,
you could use:

strData = strData & "Value1" & vbTab & "Value2" & vbCrLf

You must set Response.Contenttype to Excels contenttype. I don't
remember what this is, but try Application/Excel. I think it's
something a little trickier.

Cheers // Johan
 
Top