What format will excel "auto-parse"

  • Thread starter Thread starter Bura Tino
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parse Text 1
how do I paste or import without parsing?? 3
Parse Data to Various Columns 5
How to export plain text from web site to Excel without data conve 1
How do I save excel file in text format without columns? 1
Prevent Auto Parse 1
Columns formatted As Dates Are Exported as a Number to Text 1
Text to Columns Question 1

Back
Top