Services & Resources / Wolfram Forums
MathGroup Archive
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2007

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

Search the Archive

Exporting TableHeadings to Excel

  • To: mathgroup at
  • Subject: [mg76936] Exporting TableHeadings to Excel
  • From: Dean Williams <deanwilliams at>
  • Date: Wed, 30 May 2007 05:24:17 -0400 (EDT)

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?



data = {{"Item1", 1, 2}, {"Item2", 3, 4}}

aa = TableForm[data,
  TableHeadings -> {None, {"Item", "Heading1", "Heading2"}}]

Export["testxls.xls", aa]

  • Prev by Date: Re: links for 6!
  • Next by Date: Another strange cursor behavior in 6.0
  • Previous by thread: Re: Integer Solutions
  • Next by thread: Re: Exporting TableHeadings to Excel