Hi, The VP Area is only available as a form object at the moment.
If you mean how do you do this as an offscreen area you would probably have to build yourself a form that opens hidden from view and process your excel file in the VP Area then close the form when complete. Best Regards, -Tai B. From: Jeremy Roussak <[email protected]> Sent: Tuesday, April 16, 2019 1:52 PM To: 4D iNug Technical <[email protected]>; Tai Bui <[email protected]> Subject: RE: 4D View Pro question Thanks - that will read the Excel document; but how do I create the VP area? On 16 Apr 2019, 21:14 +0100, Tai Bui <[email protected]<mailto:[email protected]>>, wrote: Hi, It should be possible with the VP IMPORT DOCUMENT command https://doc.4d.com/4Dv17R4/4D/17-R4/VP-IMPORT-DOCUMENT.301-4026489.en.html The command should be able to import your .xlsx format Excel File into a 4D VP area. Best Regards, -Tai B. Tai Bui Technical Services Engineer 4D Inc 95 S. Market Street, Suite #240 CA 95113 San Jose United States Téléphone : +1-408-557-4600 Standard : +1-408-557-4600 Fax : +1-408-271-5080 Email : [email protected]<mailto:[email protected]> Web : www.4d.com<http://www.4d.com> -----Original Message----- From: 4D_Tech <[email protected]<mailto:[email protected]>> On Behalf Of Jeremy Roussak via 4D_Tech Sent: Tuesday, April 16, 2019 12:07 PM To: 4D iNug Technical <[email protected]<mailto:[email protected]>> Cc: Jeremy Roussak <[email protected]<mailto:[email protected]>> Subject: 4D View Pro question Sorry if this is a silly, or trivial, question. I’m using V17R4. I’d like to load an Excel document and pick bits out of it. I don’t need or want to display any of it. I don’t have any form active. How do I create a VP area and load the document into it? Jeremy ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
