Allan
I think I have the code you refer to. if it is the component that uses vbs
scripts(such as application_arrange_windows.vbs)..this might have been
something other than Miyakos’ code.. contact me off list and i can put a copy
of this on a drop box for you.
C_TEXT($1)
C_TEXT($2)
C_TEXT($3)
C_TEXT($4)
SCPT_XL_SetParameter ("XCEL_WORKBOOK_NAME";$1)
SCPT_XL_SetParameter ("XCEL_SHEET_NAME";$2)
SCPT_XL_SetParameter ("XCEL_RANGE";$3)
SCPT_XL_SetParameter ("XCEL_VALUE";$4)
SCPT_XL ("range_set_value”)
Nigel
> On 7 May 2018, at 09:44, Allan Udy via 4D_Tech <[email protected]> wrote:
> application_arrange_windows
> 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]
> **********************************************************************
**********************************************************************
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]
**********************************************************************