List Archives >
Maple User Group List Archive >
Archive by date >
This Month By Date >
This Month By Topic
[MUG] Using data from a spreadsheet.
| [MUG] Using data from a spreadsheet. |
|
Author: Jason C Leach
Posted: 17/08/2001 06:40:53 GDT
|
>> From: "Jason C. Leach"
hi,
If I insert a spreadsheet in Maple (6.01), can I access the data in
each cell in a maple calculation?
For example:
x:= DATA_IN_CELL_A1
or
x:= spreadsheet1.DATA_IN_CELL_B3
I suspect I can, but I don't know how.
Thanks,
j.
--
......................
..... Jason C. Leach
..
|
| [MUG] Re: Using data from a spreadsheet |
|
Author: Maple User Group
Posted: 22/08/2001 16:08:51 GDT
|
>> From: Maple User Group
On Thu, 16 Aug 2001, Jason C. Leach wrote:
>| If I insert a spreadsheet in Maple (6.01), can I access the data in
>| each cell in a maple calculation?
>|
>| x:= DATA_IN_CELL_A1 or x:= spreadsheet1.DATA_IN_CELL_B3
-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-
Date: Fri, 17 Aug 2001 17:32:16 -0400 (EDT)
From: Carl DeVore
To:
Subject: Using data from a spreadsheet.
Answer:
> Spread[GetCellValue](spreadsheet1, "B3");
Note that if you use letter-number addressing for the cells, then the
address is in quotes.
--
Carl Devore
Maple programs written for hire. Maple advisor for hire.
-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-
Date: Fri, 17 Aug 2001 14:39:58 -0700 (PDT)
From: Robert Israel
To:
Subject: Using data from a spreadsheet.
Yes, this is what the procedure GetCellValue in the Spread package is
for. For example,
> with(Spread):
CreateSpreadsheet(MySheet);
produces a spreadsheet with the name MySheet. Then to get the value
in cell B3 you could say
> GetCellValue(MySheet, "B3");
Robert Israel
Department of Mathematics http://www.math.ubc.ca/~israel
University of British Columbia
Vancouver, BC, Canada V6T 1Z2
-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-
From: "Dr Francis J. Wright"
To: "\"Jason C. Leach\""
Subject: Using data from a spreadsheet.
Date: Sat, 18 Aug 2001 20:34:11 +0100
This code shows how to access cell A1 in the first spreadsheet inserted into
the current worksheet:
> with(Spread):
> x := GetCellValue("SpreadSheet001", "A1");
To find the identifier for a particular spreadsheet, right-click on it and
select Properties from the Context menu (or use the menu bar). The Spread
package has other capabilities, including creating spreadsheets and setting
cell values -- see the online help.
Francis
-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-
From: Stanley J Houghton
Date: Mon, 20 Aug 2001 13:21:50 +0100
To:
Subject: Using data from a spreadsheet.
Look at the help pages on the "spread" package
(type "?spread"). I believe this has what you need.
Stan
|
Previous by date: [MUG] Re: Mathematical symbols in plots, Theodore Kolokolnikov
Next by date: [MUG] Text Parsing., Jason C Leach
Previous thread: [MUG] testeq, Bill Whiten
Next thread: [MUG] Text Parsing., Jason C Leach
|
Connectors