MathGroup Archive 2007

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

Search the Archive

Re: Exporting TableHeadings to Excel


Use either

aa = Prepend[data, {"Item", "Heading1", "Heading2"}];

or

aa = Join[{{"Item", "Heading1", "Heading2"}}, data];


Bob Hanlon

---- Dean Williams <deanwilliams at mac.com> wrote: 
> 
> Using the example below, I am trying to export the TableHeadings to
> accompany the data into Excel.
> 
> However, when I open Excel, the TableHeadings are lost.
> 
> Is there a way to export the TableHeadings and data together?
> 
> Regards
> 
> Dean
> 
> 
> data = {{"Item1", 1, 2}, {"Item2", 3, 4}}
> 
> aa = TableForm[data,
>   TableHeadings -> {None, {"Item", "Heading1", "Heading2"}}]
> 
> Export["testxls.xls", aa]
> 
> 



  • Prev by Date: Re: v6: cursor behaviour with arrow keys
  • Next by Date: Re: Re: Re: asymptotics
  • Previous by thread: Re: Exporting TableHeadings to Excel
  • Next by thread: Re: Exporting TableHeadings to Excel