Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Wayne Stewart via 4D_Tech 
2cv is faster than a Ferrari:

https://goo.gl/images/2yZ2L9

On Wed, 9 May 2018 at 01:16, Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Another "plug" for Pluggers XCEL plugin.
> We use it exclusively.
> Full control of the spreadsheet.
>
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
>
> -Original Message-
> From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer
> via 4D_Tech
> Sent: Tuesday, May 8, 2018 12:15 AM
> To: 4d_tech@lists.4d.com
> Cc: Douglas Cryer <jdcr...@telekinetix.com>
> Subject: Re: Options To Put Data Into Existing Excel Spreadsheets?
>
> Allan,
>
> Until recently we were using Keisuke's component.  Clients were asking for
> more, in particular images so we looked around and found the Pluggers
> Plugin.  Yes it does mean going from a free option to a paid option but
> equally it is like going from a 2CV to a Ferrari.  It does much more, far
> faster and far more efficiently.  Keisuke himself said that the component
> was written as an example and he never expected it to be used in production
> systems.
>
> Since adopting the Excel Plugin we have converted many outputs and our
> clients love it.  They have commissioned more reports and we have been able
> to recoup the cost of the plugin easily within months of purchase.
>
> If you still need the component I am sure I can dig you out a copy but I
> would urge you to either fund the cost of the plugin yourself or get your
> client to do so.  You will not be sorry.
>
> Regards,  Dougie
> 
>
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218 2nd Floor Broadway House, 4-6
> The Broadway, Bedford MK40 2TE
> <https://maps.google.com/?q=4-6+The+Broadway,+Bedford+MK40+2TE=gmail=g>
> Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.com <
> http://www.telekinetix.com/>
> 
>
>
> 
>
>
>
>
>
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **
>
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **

-- 

Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart
<http://about.me/waynestewart>
**
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:4d_tech-unsubscr...@lists.4d.com
**

RE: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Randy Engle via 4D_Tech 
Another "plug" for Pluggers XCEL plugin.
We use it exclusively.
Full control of the spreadsheet.

Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer via 
4D_Tech
Sent: Tuesday, May 8, 2018 12:15 AM
To: 4d_tech@lists.4d.com
Cc: Douglas Cryer <jdcr...@telekinetix.com>
Subject: Re: Options To Put Data Into Existing Excel Spreadsheets?

Allan,

Until recently we were using Keisuke's component.  Clients were asking for 
more, in particular images so we looked around and found the Pluggers Plugin.  
Yes it does mean going from a free option to a paid option but equally it is 
like going from a 2CV to a Ferrari.  It does much more, far faster and far more 
efficiently.  Keisuke himself said that the component was written as an example 
and he never expected it to be used in production systems.

Since adopting the Excel Plugin we have converted many outputs and our clients 
love it.  They have commissioned more reports and we have been able to recoup 
the cost of the plugin easily within months of purchase.

If you still need the component I am sure I can dig you out a copy but I would 
urge you to either fund the cost of the plugin yourself or get your client to 
do so.  You will not be sorry.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218 2nd Floor Broadway House, 4-6 The 
Broadway, Bedford MK40 2TE Email : jdcr...@telekinetix.com  Web : 
http://www.telekinetix.com <http://www.telekinetix.com/> 

 







**
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:4d_tech-unsubscr...@lists.4d.com
**

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Arnaud de Montard via 4D_Tech 

> Le 8 mai 2018 à 09:14, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> 2CV to a Ferrari

What's the difference?


-- 
Arnaud de Montard 




**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Douglas Cryer via 4D_Tech 
Allan,

Until recently we were using Keisuke's component.  Clients were asking for 
more, in particular images so we looked around and found the Pluggers Plugin.  
Yes it does mean going from a free option to a paid option but equally it is 
like going from a 2CV to a Ferrari.  It does much more, far faster and far more 
efficiently.  Keisuke himself said that the component was written as an example 
and he never expected it to be used in production systems.

Since adopting the Excel Plugin we have converted many outputs and our clients 
love it.  They have commissioned more reports and we have been able to recoup 
the cost of the plugin easily within months of purchase.

If you still need the component I am sure I can dig you out a copy but I would 
urge you to either fund the cost of the plugin yourself or get your client to 
do so.  You will not be sorry.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.com 


 







**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread Nigel Greenlee via 4D_Tech 
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 <4d_tech@lists.4d.com> 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
> 
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **

**
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:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread James Wright via 4D_Tech 
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 <4d_tech@lists.4d.com> 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
>
> **
> 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:4d_tech-unsubscr...@lists.4d.com
> **




-- 
[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
supp...@draganddrop.co.uk | 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:4d_tech-unsubscr...@lists.4d.com
**

Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread Allan Udy via 4D_Tech 

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

**
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:4d_tech-unsubscr...@lists.4d.com
**