Page 1 of 1

Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 3:30 pm
by Horizon
Hi,

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

Thanks.

Re: Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 4:12 pm
by Natter
If I understood the question correctly
Code: Select all  Expand view
dim:=oExc:Sheets(1):Range("A1:H100"):value


Then insert the dim array into the xBrowse

Re: Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 5:50 pm
by Horizon
Natter wrote:If I understood the question correctly
Code: Select all  Expand view
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?

Re: Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 6:42 pm
by Natter
The highlighted fragment is ":Selection". Basically so
Code: Select all  Expand view
dim:=oExc:Sheets(1):Selection:Range:value

Re: Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 6:49 pm
by nageswaragunupudi
Image


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

Re: Excell to xbrowse ?

PostPosted: Mon Nov 20, 2023 8:20 pm
by Horizon
Thank you Mr. Rao.

It works.