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

Exporting TableHeadings to Excel

• To: mathgroup at smc.vnet.net
• Subject: [mg76936] Exporting TableHeadings to Excel
• From: Dean Williams <deanwilliams at mac.com>
• 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?

Regards

Dean


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

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

Export["testxls.xls", aa]