Simple question about Data Reading by Prime?

[tom234]

Hello,
Can HP Prime read Spreadsheet data into PPL language?

Can HP Prime read Matrix Data from Spreadsheet or other programs File other than hand written into the Matrix eg.M0-M9?

I have done the indexing with List eg. L(I)....L(I+1) it works so one dimensional yes.

However, I really need to know how to read spreadsheet data into Prime.

Can it be done?

If so please give examples:



PS
thank you for opinions on DM41X or DM42 chose DM41X

[rawi]

Hi Tom,

I copied data from Excel to word, than exchagend decimal commas to decimal points and than copied it by copy and paste to the Prime-Spreadsheet App and form the spreadsheet app you can copy it to a matrix. You best do that on the Prime app and copy than the matrix to the prime handheld.

If you need further help indicata it and I can provide an example.

It is a little bit complicated but I could not find an easier way and at least it is simpler than typing all the numbers in.

Best

Raimund

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

[tom234]

So your using .Cell(1,1) as how you refer to spreadsheet or program specific language?

However this treats in like an array...
not like A1,B1 in both Spreadsheets? eg A1,A2 or B1, B2?

[Didier Lachieze]

Try with Spreadsheet.A1 or Spreadsheet.A1:B3