MathGroup Archive 2010

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

Search the Archive

Re: Access to Open Excel Cell

  • To: mathgroup at
  • Subject: [mg106938] Re: [mg106918] Access to Open Excel Cell
  • From: Ariel Sepulveda <sepulveda.cuevas at>
  • Date: Fri, 29 Jan 2010 07:44:52 -0500 (EST)
  • References: <>

The Mathematica application in this link is designed
to generate a trigger automatically anytime the contents of the spreadsheet
is modified.  If needed, a trigger can be generated anytime a particular
cell is changed.  Other user requirements can be implemented to make it
suitable for other functionalities.  My contact info is provided below.
 Other data manipulation and analysis applications are available in

This an excerpt of the information in the link above:
Sharing is one of the most useful features of SpreadsheetLike. The idea is
that at any time data inside SpreadsheetLike can be used externally for any
user-defined application. The example below shows a dataset where columns A,
B, E, and G are hidden and data is being sorted by column I. By setting
sharing mode to Continuous any change made in the data is continuously being
written to the global variable defined in Variable Name. Thus,
SpreadsheetLike can be used as a data input tool for any user-defined

On Thu, Jan 28, 2010 at 3:44 AM, Stewart Bodzin <Stewart.Bodzin at>wrote:

> I know how to read Excel files into Mathematica.  I am trying find a way to
> read data from a specific cell in an "open" excel spreadsheet.  The basic
> problem is to make a change to a cell in excel, and then have a trigger in
> Mathematica kick off code to read that cell into Mathematica.  I'm not too
> concerned on how to trigger the action, and really only need help on how to
> code the hook into an open excel spreadsheet to fetch the data from the
> excel cell.
> Does anyone know of a code example of how to do this.
> Anyone's help on this is greatly appreciated.

Ariel Sepulveda, Ph.D.
President, Pronto Analytics Inc.
Tel. 787.354.6947
ariel.sepulveda at

  • Prev by Date: Re: Frame
  • Next by Date: Re: solve partial differential equations with mathematica
  • Previous by thread: Access to Open Excel Cell
  • Next by thread: Re: Access to Open Excel Cell