[MUG] Using data from a spreadsheet.

[MUG] Re: Using data from a spreadsheet
Author: Maple User Group    Posted: 22/08/2001 16:08:51 GDT
>> From: Maple User Group "maple_gr" 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 "devore" To: "maple-list" "jleach" 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. "devore" -=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=- Date: Fri, 17 Aug 2001 14:39:58 -0700 (PDT) From: Robert Israel "israel" To: "maple-list" 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 "israel" Department of Mathematics http://www.math.ubc.ca/~israel University of British Columbia Vancouver, BC, Canada V6T 1Z2 -=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=-=*=- From: "Dr Francis J. Wright" "F.J.Wright" To: "\"Jason C. Leach\"" "jleach" 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 "S.J.Houghton" Date: Mon, 20 Aug 2001 13:21:50 +0100 To: "jleach" "maple-list" 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