Some instructions in FWH to handle an Excel or a Word file

[driessen]

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.

[cnavarro]

Look

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

and search into this link and all forum oSheet

[driessen]

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?

[cnavarro]

For insert row

Code: Select all  Expand view

// 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()
 

[Enrico Maria Giordano]

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: Select all  Expand view

oExcel:Sheets( cName ):Select()

EMG

[driessen]

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

[hua]

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

[Enrico Maria Giordano]

You are right.

EMG