Using Excel/FW under Remote Desktop

[Marc Venken]

I'm running my program under RD but I need to create a excel file. On the server there is no exel installed.
I can instal it but it seems that a other kind of lincence is needed for excel to install on a server Windows 2019

Any advice ?

[Jimmy]

hi Marc,

there are some CODE which can "write" a Excel Sheet ... but only "very simple" Sheet

there is a "Professional" LIB called LibXL
https://www.libxl.com/

i know that some Xbase++ User have made a "Wrapper" for LibXL.
not sure what we need todo for harbour

[Ari]

Olá Jimmy,
Thanks for the tip.

I downloaded the lib, I found it interesting, do you have any small examples for FiveWin and Harbor

In my system, there are a lot of reports generated in Spreadsheet, and it would be great to be able to open them without Excel

[Jimmy]

hi Ari,

do you have any small examples for FiveWin and Harbor

i have no Fivewin / harbour CODE for it, only Xbase++ using OT4XB to build "wrapper" for DLLcall()

under \examples\c\ and \examples\delphi\ you will find CODE which can help to build a "Wrapper" for harbour

[TimStone]

Marc,

This is not "the" answer to your question, but rather an alternate thought.

Why are you using RD to run the program ? I use it to do my Windows work from my Apple Mac, but otherwise I'm not sure of any benefit.

It is a small modification to your program to run it on your local machine, where Excel is installed, but to set the default path to the data files on your server. Your program becomes the "client", and you can install it on all of your workstations. Networking is natural in FW. Thus you can have all the data in one, shared, spot, but do all the processing on the local machine.

It certainly would be a lot easier than having to find an Excel multi user solution.

Tim

[Jimmy]

hi Ari,

have a look at
https://groups.google.com/g/harbour-users/c/jngCD-CFJss

[Otto]

Hello Tim,
here are some pros:

https://winhotel-space.translate.goog/w ... r_pto=wapp


Best regards,
Otto

[TimStone]

Otto,

I'm don't understand that link. Maybe it is incorrect.

As for what I suggested, I have been using a client / server methodology for nearly 40 years. My customers run from 2 - 20 computers on a network, all sharing the same set of data files. Some use a true server with Windows Server software. Others simply designate one of their normal workstations, running Windows 10 or 11, as a server. They run the client software on the same computer, but all of their other workstations also interact with the data on that same machine. We NEVER have any problems, and these folks are entering a lot of data all day long.

I know you do things differently, but I've been networking and sharing data since the earliest days of DOS, using dBase II, and III, then Clipper, and since 2000, full Windows. The computers today are so fast and efficient that it works beautifully.

Tim