MathGroup Archive 2001

[Date Index] [Thread Index] [Author Index]

Search the Archive

RE: Making a LIst Reconsidered

  • To: mathgroup at
  • Subject: [mg29574] RE: [mg29566] Making a LIst Reconsidered
  • From: "Annetts, David (DEM, North Ryde)" <David.Annetts at>
  • Date: Wed, 27 Jun 2001 05:12:12 -0400 (EDT)
  • Sender: owner-wri-mathgroup at

Hi Fujio,
> Dear members of MathGroup : 
>     I posted a report titled "Making a List" the other day.  
> As it had 
> incorrect parts, I might make readers confused.  So, I again 
> submit a new 
> report, with a regrettable mind.
>     I am reporting a trouble converting data from Excel to 
> Mathematica.  
>     My trouble is as follows:
>     I paste some data from Excel on Mathematica, and the data 
> are expressed 
> on Mathematica as follows:
>     a
>     b
>     c
> In this situation, I would like to know how to convert them 
> into a list such 
> as { a, b, c}.
> I hope to receive answers as previously.

You can't do this directly, as least not without some tedious reformatting.
I think the reason is that Mathematica will accept data from the clipboard as a
string rather than a formatted string.

As Drago suggested, the way to go is to save the Excel data in a separate
file and import this, either using Import[] or manually using either Read[]
or ReadList[].



  • Prev by Date: Re: Needing help
  • Next by Date: Re: Mathematica formatting for large documents
  • Previous by thread: Re: Making a LIst Reconsidered
  • Next by thread: overlay imported picture with Mathatmatica calc