FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Some instructions in FWH to handle an Excel or a Word file
driessen
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 01:39 PM

Hello,

I urgently need some instructions to handle an excel file.

  1. How do I select a page in an Excel file from a FWH-application?
  2. How do I add a line or a columns in an Excel file from a FWH-application?

I also need an instrution for word.

How do I set tab stop (right and left) in a document from a FWH-application?

Thank you very much in advance for any help.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

cnavarro
Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 03:19 PM

Look

viewtopic.php?f=6t=34833p=207062hilit=oSheet#p207062

and search into this link and all forum oSheet

&&&

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
driessen
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 04:01 PM

Cristobal,

Thanks a lot for your reply.

Unfortunately this link is in Spanish. And I don't speak one single word of Spanish.

This link is a good start. Any idea for the rest?

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

cnavarro
Posts: 6755
Joined: Wed Feb 15, 2012 08:25 PM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 04:14 PM
For insert row

Code (fw): Select all Collapse
// select sheet
oSheet   := oExcel:Sheets( 1 )
oSheet:Rows(1).Insert()
oSheet:Columns("D:D"):Insert()

// or with objects range
objRange := oExcel.Range("A1").EntireRow()
objRange:Insert()

objRange := oExcel:Range("C1"):EntireColumn()
objRange:Insert()
Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces
Enrico Maria Giordano
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 05:48 PM
driessen wrote:Hello,

I urgently need some instructions to handle an excel file.

1. How do I select a page in an Excel file from a FWH-application?


Code (fw): Select all Collapse
oExcel:Sheets( cName ):Select()


EMG
Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg
driessen
Posts: 1467
Joined: Mon Oct 10, 2005 11:26 AM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Mon Jan 29, 2018 10:12 PM

Thanks a lot, guys.
This was the information I was looking for.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

hua
Posts: 1096
Joined: Fri Oct 28, 2005 02:27 AM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Tue Jan 30, 2018 03:06 AM
There's also an entry on the wiki here.

Though I believe some commands now can be written tidier e.g. oSheet := oExcel:Get("ActiveSheet") can be written as oSheet := oExcel:ActiveSheet nowadays.

Correct me if I'm wrong
FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour
Enrico Maria Giordano
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: Some instructions in FWH to handle an Excel or a Word file
Posted: Tue Jan 30, 2018 09:28 AM

You are right.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Continue the discussion

Static archive · New replies & topics via GitHub Discussions