Casio ClassPad 101 User's Guide download pdf (Page 228)

Chapter 13: Spreadsheet Application 228

Importing and Exporting Variable Values

You can import LIST (list), MAT (matrix), EXPR (expression), and STR (string) variables* into a spreadsheet.

LIST, MAT, and EXPR type variable in spreadsheet data also can be exported.

* For information about variable types, see “Main Memory Data Types” (page 26).

u To import the data assigned to a variable

1. In a spreadsheet, tap a single cell to specify it as the import destination of the variable data.

• If the variable you are importing is an EXPR or STR type, tapping the cell will input the variable data. For a

LIST or MAT type variable, data is input as shown in examples below when cell A1 is tapped.

LIST variable “{1,2,3}” MAT variable “[[1,2][3,4]]” *

* Same as

1 2

3 4

• If any of the cells within the range where variable data is being input already contain data, the existing data

will be overwritten with the imported data.

• The data type of the cells to which data is imported will automatically change to calculation data type (LIST,

MAT, EXPR) or text data type (STR) in accordance with the type of variable imported into each cell.

2. On the [File] menu, tap [Import].

• This displays the Import dialog box along with a soft keyboard.

3. Type the variable name into the [Variable] box.

• Tapping the 2 icon on the Import dialog box will display the Variable

Manager, which you can use to select the variable you want. See “Using

Variable Manager” (page 27) for more information.

4. To import the specified variable data into the spreadsheet, tap [OK].

u To export spreadsheet data to an EXPR variable

1. Select a single cell that contains the data you want to export to an EXPR variable.

• It makes no difference whether the cell you select contains a value, expression, or string. Note that string

data exported from a cell is exported as EXPR type data, not STR type data.

2. On the [File] menu, tap [Export].

• This displays the Export dialog box along with a soft keyboard. In this

case, “EXPR” will be automatically selected in the [Type] box.

3. Type the variable name into the [Variable] box.

4. After confirming that everything is the way you want, tap [OK].

u To export spreadsheet data to a LIST or MAT (matrix) variable

1. Select the range of cells that contains the data you want to export to a LIST or MAT variable.

2. On the [File] menu, tap [Export].

3. On the dialog box that appears, tap the [Type] box down arrow button, and then select “LIST” or “MATRIX”

from the list of variable types that appears.

4. Type the variable name into the [Variable] box, and then tap [OK].

• The data in the range of cells you select in step 1 is exported as shown below, in accordance with the

variable type (“LIST” or “MATRIX”) you select in step 3.

1 2 ... 223 224 225 226 227 228 229 230 231 232 233 ... 274 275

No comments

Casio ClassPad 101 User's Guide Page 228