|
Title: Ask Reuben 178 - Copy and Paste From Excel Post by: Reuben B. on June 15, 2023, 01:23:01 am 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/ |