next »

[Reuben B.]

Accountants and Analysts love Excel.  One of the tasks they may have is to use Excel to create a bunch of numbers that they then want to import into your Genero application.    Examples might include budget and forecast figures.  Another usage of Excel is as an intermediary in a cheap method to do a one-time transfer of data from one application to another (export to csv or Excel, import the csv or Excel into your application).
 
Rather than writing dedicated load programs that might use LOAD, or base.Channel to read files, or a dedicated Web Service API to load data, the concept is to use an existing screen where the user can manually enter many rows of data via an INPUT ARRAY.  The question is then can I copy a range of cells from Excel and paste it into this or any INPUT ARRAY?  The answer is Yes using reflection.

Read more at https://4js.com/ask-reuben/ig-178/

[Reuben B.]

GBC 5.00.08 (https://4js.com/online_documentation/fjs-gbc-manual-html/#gbc-topics/gbc_whatsnew_50008_2.html) added the ability for the GBC to manage the paste of clipboard content from Excel.  The techniques referred to in this article are still valid and interesting, but you can review wether the default paste behaviour now meets your needs and means you no longer need to use the techniques listed in this article.