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]