Services & ResourcesWolfram ForumsMathGroup Archive

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

Re: Access to Open Excel Cell

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

The Mathematica application in this link
http://www.prontoanalytics.com/products/spreadlike/overview.htm 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
http://www.prontoanalytics.com/products.htm.

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
function.

On Thu, Jan 28, 2010 at 3:44 AM, Stewart Bodzin <Stewart.Bodzin at usa.net>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 prontoanalytics.com
http://www.prontoanalytics.com

• References:
  • Access to Open Excel Cell
    • From: "Stewart Bodzin" <Stewart.Bodzin@usa.net>