Alan, Could you not look at a PHP/Command line solution and script it with LEP?
https://phpspreadsheet.readthedocs.io/en/develop/ James. On 7 May 2018 at 09:44, Allan Udy via 4D_Tech <[email protected]> wrote: > Hi All, > > I'm up the proverbial creek without a paddle... > > Years ago (v11) we started using the 'Excel Library' component put > together (I think) by Keisuke. For the life of me I can no longer find a > source version of this (if there ever was one), and it appears that any > online link to the component no longer exists. > > At one point we did get the component upgraded to work in a v14 database. > Seems (under MacOS at least) that it's still working under v16, but it's > plainly only 32-bit. Due to a couple of other reasons we now need to look > at taking this single-user app to 64-bit, and of course it won't work. :-( > > I have found Keisuke's 4d-plugin-xls (https://github.com/miyako/4d- > plugin-xls), but this does not appear to contain options to find and set > cell ranges as the earlier component did, nor is there any sensible > documentation, so it's not really useable. > > I'm aware of Pluggers XL Plugin, but at 600 Euro it's going to be hard > sell for our client when only basic use is made of Excel (Open a > spreadsheet, find a couple of named cells, put data in those cells, save > the spreadsheet). > > Are there any other options out their to interface a 4D app with an Excel > spreadsheet? > > Cheers, > Allan Udy > > Golden Micro Solutions Ltd, Blenheim, New Zealand > http://www.golden.co.nz<http://www.golden.co.nz> > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- [image: logo] *James Wright* C.T.O.*, Drag and Drop* Tel: 08000 43 22 12 | Suite 6/7 Chichester House, 45 Chichester Road, Southend-on-Sea, Essex SS1 2JU [email protected] | www.ezadspro.co.uk | www.draganddrop.co.uk ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************

