Using Excel/FW under Remote Desktop

Using Excel/FW under Remote Desktop

Postby Marc Venken » 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.04 with Harbour
User avatar
Marc Venken
 
Posts: 1425
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Re: Using Excel/FW under Remote Desktop

Postby Jimmy » Wed May 10, 2023 6: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
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: Using Excel/FW under Remote Desktop

Postby Ari » Thu May 11, 2023 1: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 2212 - Harbour 3.2.0 - Embarcadero 7.43 - MySQL
São Paulo - SP - Brasil
www.sisrev.com.br
User avatar
Ari
 
Posts: 228
Joined: Fri Feb 03, 2006 4:21 pm
Location: São Paulo, SP - Brazil

Re: Using Excel/FW under Remote Desktop

Postby Jimmy » Thu May 11, 2023 4: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
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: Using Excel/FW under Remote Desktop

Postby TimStone » Thu May 11, 2023 5: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
User avatar
TimStone
 
Posts: 2943
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: Using Excel/FW under Remote Desktop

Postby Jimmy » Thu May 11, 2023 6:26 pm

greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: Using Excel/FW under Remote Desktop

Postby Otto » Thu May 11, 2023 6:46 pm

Hello Tim,
here are some pros:

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


Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club
********************************************************************
User avatar
Otto
 
Posts: 6312
Joined: Fri Oct 07, 2005 7:07 pm

Re: Using Excel/FW under Remote Desktop

Postby TimStone » Thu May 11, 2023 8: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
User avatar
TimStone
 
Posts: 2943
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 47 guests