Simple Spreadsheet within Mathematica?
Thomas Melehan
Thanks
Tom Melehan
David Bailey
As someone else pointed out a while back, there is an undocumented
function TableView, which is presumably under development, and will
appear at some point. Obviously, anything you develop using this, may
(at the very least) need amending at the next version - it is, after
all, undocumented!
It is also possible to display a scrollable table of data in a Java
window. The easiest way to do this, is to download my (free) Super
Widget Package, and use SuperWidgetTree - there is an example in the
documentation.
Spread sheets include a lot of extra functionality, and yet another
option is to link to XL itself:
http://www.wolfram.com/products/applications/excel_link/
David Bailey
http://www.dbaileyconsultancy.co.uk
Sjoerd C. de Vries
rd-pipeline-for-mathematica/), in a future versions of Mathematica
there will be a SpreadsheetView.
Cheers -- Sjoerd
On Nov 30, 1:16 pm, Thomas Melehan <tpmele...@me.com> wrote:
> Has anyone developed a simple spreadsheet application that works within M=
David Reiss
--David
http://scientificarts.com/worklife
Simon
There is an undocumented function called TableView that was discussed
in these forums a while back.
Look for thread called "undocumented feature: TableView"
It's not complete yet, but might be enough for what you want.
Simon
Szabolcs Horvát
> Has anyone developed a simple spreadsheet application that works within Mathematica? It would be a useful tool.
>
If you're just looking to enter tabular data, the keyboard shortcuts
CTRL-Enter and CTRL-, (CTRL-Comma) may be helpful.
There was a discussion not too long ago about a "hidden" experimental
feature like this:
(It doesn't seem to be complete and ready for general use yet. For
example, it doesn't support data input.)
Finally, there is the Excel Link, which I've never used, so can't
comment on it:
dr DanW
Wolfram mentioned a new SpreadsheetView dynamic widget, probably for
the next release.
In the meantime, there is an undocumented TableView function in
Version 7, but do not rely on it. It is incompletely implemented and
buggy, which is probably why it is undocumented. Finally, there is
the third party ExcelLink package, which allows interaction between
Excel and Mathematica.
Daniel
Murray Eisenberg
short-run use -- because:
(1) Mathematica 7 already includes a TableView function that could
provide the basis for such functionality;
(2) As I seem to recall, in his videocast talk to the International
Mathematica User Conference 2009, Stephen Wolfram indicated that
spreadsheet functionality was on the way.
Thomas Melehan wrote:
> Has anyone developed a simple spreadsheet application that works within Mathematica? It would be a useful tool.
>
>
>
>
>
> Thanks
>
> Tom Melehan
>
>
>
>
--
Murray Eisenberg mur...@math.umass.edu
Mathematics & Statistics Dept.
Lederle Graduate Research Tower phone 413 549-1020 (H)
University of Massachusetts 413 545-2859 (W)
710 North Pleasant Street fax 413 545-1801
Amherst, MA 01003-9305
AES
David Bailey <da...@removedbailey.co.uk> wrote:
>
> Spread sheets include a lot of extra functionality, and yet another
> option is to link to XL itself:
>
> http://www.wolfram.com/products/applications/excel_link/
* Priced at $249 (does that include Excel?)
* Windows only (at least, only Windows version listed)
* Only connects to one version of Excel (at least only one version
listed -- will upgrades for subsequent versions of Excel be supplied
free?)
* Seems to intended primarily to add Mathematica capabilities to Excel,
rather than the reverse"
"Mathematica Link for Excel is an essential tool for finance
professionals, business professionals, life scientists, engineers,
physical scientists, social scientists, educators, and others who want
to use Excel and need to expand its computational and graphical
capabilities."
* Presumably both Excel and Mathematica must be running (or accessible)
to use it.
Ariel Sepúlveda
navigator and manipulator which can also be used for sharing data with other
user-defined Mathematica applications. It is very efficient handling large
datasets: 1,000,000 rows by 10 columns? Not a problem at all.
Once data is inside the SpreadsheetLike GUI it can be manipulated by
cropping, sorting, hiding columns, filtering, and sampling. The resulting
dataset can be saved in a new .sls (SpreassheetLike Sheet) file which can be
easily accessed later by means of the Open option in the File menu. It has
many other nice features like printing data subsets and cloning itself but I
think that one of its best characteristics is that it can share data with
other Mathematica applications in real-time.
I'll soon create a screencast and post a message here when ready. While
that happens there is additional information with screenshots available in
http://www.prontoanalytics.com/products/spreadlike/overview.htm. This
documentation is not exhaustive but is good enough to show what it is about.
SpreadshseetLike is not a spreadsheet but it provides a Spreasheet-Like user
experience in many ways.
Ariel Sep=FAlveda, Ph.D.
__________________________
President, Pronto Analytics Inc.
Tel. 787.354.6947
ariel.s...@prontoanalytics.com
http://www.prontoanalytics.com
E. Martin-Serrano
paid, license of Mathematica Link for Excel v2.1.1,
I cannot resist adding that, BTW, it is not $249 in Europe but
=E2=82=AC250, which means $375 at today's exchange rate.
E. Martin-Serrano
-----Original Message-----
From: AES [mailto:sie...@stanford.edu]
Sent: Wednesday, December 02, 2009 12:28 PM
Subject: Re: Simple Spreadsheet within Mathematica?
In article <hf2mmd$i97$1...@smc.vnet.net>,
David Bailey <da...@removedbailey.co.uk> wrote:
>
> Spread sheets include a lot of extra functionality, and yet another
> option is to link to XL itself:
>
> http://www.wolfram.com/products/applications/excel_link/