Excell to xbrowse ?

Excell to xbrowse ?

Postby Horizon » Mon Nov 20, 2023 3:30 pm

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
Horizon
 
Posts: 1322
Joined: Fri May 23, 2008 1:33 pm

Re: Excell to xbrowse ?

Postby Natter » Mon Nov 20, 2023 4:12 pm

If I understood the question correctly
Code: Select all  Expand view  RUN
dim:=oExc:Sheets(1):Range("A1:H100"):value


Then insert the dim array into the xBrowse
Natter
 
Posts: 1224
Joined: Mon May 14, 2007 9:49 am

Re: Excell to xbrowse ?

Postby Horizon » Mon Nov 20, 2023 5:50 pm

Natter wrote:If I understood the question correctly
Code: Select all  Expand view  RUN
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
Horizon
 
Posts: 1322
Joined: Fri May 23, 2008 1:33 pm

Re: Excell to xbrowse ?

Postby Natter » Mon Nov 20, 2023 6:42 pm

The highlighted fragment is ":Selection". Basically so
Code: Select all  Expand view  RUN
dim:=oExc:Sheets(1):Selection:Range:value
Natter
 
Posts: 1224
Joined: Mon May 14, 2007 9:49 am

Re: Excell to xbrowse ?

Postby nageswaragunupudi » Mon Nov 20, 2023 6:49 pm

Image


Code: Select all  Expand view  RUN
XBROWSER Array( 1, 10 ) SETUP ( oBrw:nEditTypes := 1, oBrw:lCanPaste := .t. )
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10646
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Excell to xbrowse ?

Postby Horizon » Mon Nov 20, 2023 8:20 pm

Thank you Mr. Rao.

It works.
Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.04
Horizon
 
Posts: 1322
Joined: Fri May 23, 2008 1:33 pm


Return to FiveWin for Harbour/xHarbour

Who is online

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