FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Using Excel/FW under Remote Desktop
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Using Excel/FW under Remote Desktop
Posted: Wed May 10, 2023 10:09 AM

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 ?

Marc Venken

Using: FWH 23.08 with Harbour
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: Using Excel/FW under Remote Desktop
Posted: Wed May 10, 2023 06:38 PM
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
greeting,

Jimmy
Posts: 253
Joined: Fri Feb 03, 2006 04:21 PM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 01:56 PM
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 :wink:
Thanks,
Ari

FWH 2501 - Harbour 3.2.0 - Embarcadero 7.43 - MySQL
São Paulo - SP - Brasil
www.sisrev.com.br
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 04:23 PM
hi Ari,
Ari wrote: 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
greeting,

Jimmy
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 05:30 PM

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

Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 06:26 PM
greeting,

Jimmy
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 06:46 PM
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: Using Excel/FW under Remote Desktop
Posted: Thu May 11, 2023 08:37 PM

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

Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit

Continue the discussion