Re: Outputing a tabular function

*To*: mathgroup at smc.vnet.net*Subject*: [mg54975] Re: [mg54945] Outputing a tabular function*From*: Adam Getchell <agetchell at physics.ucdavis.edu>*Date*: Tue, 8 Mar 2005 05:04:25 -0500 (EST)*References*: <200503070710.CAA07734@smc.vnet.net>*Sender*: owner-wri-mathgroup at wolfram.com

Clifford Martin wrote: >In some code I've written I output a table. In >Mathematica I use TableForm in the usual way then use >columns of data to fill the table. It looks nice in >Mathematica. But my customer wants to be able to pull >the file up in Excel. I've tried various export >formats but since the tables are made up of columns of >data that are just lists it writes the lists as rows >Any suggestions about exporting the data so it can be >read in an external program and look like a table? (I >should add that I iterate over many sets of data and >so there are multiple tables that print out. I capture >the data in a function that I try to Export). Any >suggestions appreciated. > >Cliff > > I've been exporting into comma separated values, which, for a matrix, actually separates by tabs, then importing into Excel just fine. For example: In[25]:= Export["djia-results.txt", results2, "csv", ConversionOptions -> {"TableHeadings" -> {None, Range[minYear, maxYear]}}]; You can leave off the ConversionOptions; I added them because I had columns of stock data which I wanted to decorate with the year for inspection (although doing actual number crunching the year is unimportant as long as all the values for a given year are in the same column). Then import from Excel. Adam Getchell

**References**:**Outputing a tabular function***From:*Clifford Martin <camartin@snet.net>