Interesting & Creative way of loading SpreadSheet from PC

[bobkrohn]

Interesting & Creative way of loading SpreadSheet from PC

Since the Connectivity Kit can't load SpreadSheet Data from a PC...
I had to be creative.

I wrote a program on the PC that takes TAB or COMMA delimited ASCII data files,
and creates HP Basic Source Code.

1) You create an "empty" Program File on the HP Prime.
2) Connect it to the PC via the Connectivity Kit.
3) Open the "empty" Program residing on the HP Prime via the Connectivity Kit.
4) Open the "Source file" created by my PC program via any Text editor.
5) Simply Copy/Paste the "Source Code" in the "empty" Program.
6) Esc out on the HP Prime and Run the program.

Presto.... Spreadsheet loaded with 10,000 records!

Example
//---------------


Export Load()
Begin

// Start of "Source file" created by my PC program

Spreadsheet.Cell(2,1):= 10000.00000000;
Spreadsheet.Cell(2,2):= 10000.00000000;
Spreadsheet.Cell(2,3):= 101.00000000;
Spreadsheet.Cell(2,4):="SW";

Spreadsheet.Cell(3,1):= 11000.00000000;
Spreadsheet.Cell(3,2):= 10000.00000000;
Spreadsheet.Cell(3,3):= 102.00000000;
Spreadsheet.Cell(3,4):="NW";

Spreadsheet.Cell(4,1):= 11000.00000000;
Spreadsheet.Cell(4,2):= 11000.00000000;
Spreadsheet.Cell(4,3):= 103.00000000;
Spreadsheet.Cell(4,4):="NE";

Spreadsheet.Cell(5,1):= 10000.00000000;
Spreadsheet.Cell(5,2):= 11000.00000000;
Spreadsheet.Cell(5,3):= 104.00000000;
Spreadsheet.Cell(5,4):="SW";

Spreadsheet.Cell(6,1):= 10500.00000000;
Spreadsheet.Cell(6,2):= 10500.00000000;
Spreadsheet.Cell(6,3):= 105.00000000;
Spreadsheet.Cell(6,4):="CTR";

MSGBOX("Data Load Finished");

END;

//--------------


Way Cool "Out of the Box" so to speak.
Maybe even easier than the so called "normal" way.

Can't go the other direction just yet. (Prime => PC)
We are still limited to the defective 999 Record (out of 10,000) output from Connectivity Kit.

Any details on the file structure of the Prime Spreadsheet file is welcome.