Excell to xbrowse ?

Post Reply
Horizon
Posts: 1329
Joined: Fri May 23, 2008 1:33 pm
Has thanked: 6 times
Been thanked: 1 time

Excell to xbrowse ?

Post by Horizon »

Hi,

Is it possible to copy selected area from excel to xbrowse? If yes, any example?

Thanks.
Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.04
Natter
Posts: 1244
Joined: Mon May 14, 2007 9:49 am

Re: Excell to xbrowse ?

Post by Natter »

If I understood the question correctly

Code: Select all | Expand

dim:=oExc:Sheets(1):Range("A1:H100"):value
Then insert the dim array into the xBrowse
Horizon
Posts: 1329
Joined: Fri May 23, 2008 1:33 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Excell to xbrowse ?

Post by Horizon »

Natter wrote:If I understood the question correctly

Code: Select all | Expand

dim:=oExc:Sheets(1):Range("A1:H100"):value
Then insert the dim array into the xBrowse
Thank you very much for your reply, Natter. I guess I didn't explain my problem.

I have a file opened in Microsoft Excel and I marked some of it and copied it to the clipboard. Can I paste the part I copied to the clipboard into xbrowse with Ctrl-V?
Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.04
Natter
Posts: 1244
Joined: Mon May 14, 2007 9:49 am

Re: Excell to xbrowse ?

Post by Natter »

The highlighted fragment is ":Selection". Basically so

Code: Select all | Expand

dim:=oExc:Sheets(1):Selection:Range:value
User avatar
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 10 times
Contact:

Re: Excell to xbrowse ?

Post by nageswaragunupudi »

Image

Code: Select all | Expand

XBROWSER Array( 1, 10 ) SETUP ( oBrw:nEditTypes := 1, oBrw:lCanPaste := .t. )
Regards

G. N. Rao.
Hyderabad, India
Horizon
Posts: 1329
Joined: Fri May 23, 2008 1:33 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Excell to xbrowse ?

Post by Horizon »

Thank you Mr. Rao.

It works.
Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.04
Post Reply