Post Reply 
Interesting & Creative way of loading SpreadSheet from PC
02-11-2015, 08:25 AM (This post was last modified: 02-11-2015 08:31 AM by Thomas_Sch.)
Post: #17
RE: Interesting & Creative way of loading SpreadSheet from PC
Hello Bob,

YEDERFs and HANs suggestions work very well, if you pre-populate the Spreadsheet in Prime and the Excel-Spreadsheet the same way.

The basics, If you want to copy data from Excel to Prime:
- all cells in Prime should have a content ith the rigth type,
e.g. formula, number, or text as in Excel
- Cells in Prime should not be empty prior to copying
- Cells in Excel should be displayed as formula, like shown in the video
- an editor is used as temporary storage. Excel -> Editor -> Conn.Kit
- additionaly cells with text-type-content should be included in ""

@ YEDERF: please correct me, if this description is faulty.

If the corresponding cells match the type, copying will work.

You're right, it's not really user-friendly, but it's working without program!
HP should add this (or a better description) to the manuals.

If users have problems with this way, publishing your routines here would help.
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Interesting & Creative way of loading SpreadSheet from PC - Thomas_Sch - 02-11-2015 08:25 AM



User(s) browsing this thread: 2 Guest(s)