Simple question about Data Reading by Prime?

[Didier Lachieze]

(03-18-2021 02:21 PM)tom234 Wrote:  Can HP Prime read Spreadsheet data into PPL language?

Yes it's possible, with Cell(row,column).

Let say that in the default Spreadsheet app you have 12345 in A1 and "ABCD" in B3, and that you have created another spreasheet named Testsheet where A1 contains 67890 and B3 contains "EFGH", then the following program

Code:

EXPORT ST()
BEGIN
 PRINT();
 PRINT(Spreadsheet.Cell(1,1));
 PRINT(Testsheet.Cell(1,1));
 PRINT(Spreadsheet.Cell(3,2));
 PRINT(Testsheet.Cell(3,2));
END;

will return:
12345
67890
"ABCD"
"EFGH"

If you want more details about how to access Spreadsheets look to: Vars>App>Spreadsheet>Numeric, select Cell (long press) and press Help.