topic-39284

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

GetExcelRange wrong return
Posted: Wed Aug 19, 2020 09:25 PM

I have define columns types as text in 156 rows and 6 columns.
I use GetExcelRange( cExcelFile) but return many 156 rows and 6 columns with empty rows and columns as picture.

? oRange:Count // return 156
? oRange:Count // return 6

Thanks in advance for any help and advise.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: GetExcelRange wrong return
Posted: Thu Aug 20, 2020 04:39 AM

I see 6 rows only in both xbrowse and excel sheet.
Can you explain your problem more clearly?

Regards

G. N. Rao.

Hyderabad, India

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: GetExcelRange wrong return
Posted: Fri Aug 21, 2020 01:17 AM

Dear Master Rao,

nageswaragunupudi wrote:I see 6 rows only in both xbrowse and excel sheet.
Can you explain your problem more clearly?

It reads 156 rows ( 6 datas and 150 empty ) and 1 empty column.

FYI, I select 156 rows/ 6 columns and define as Text in Format cells. The function will select all even empty rows and columns.

Thanks in advance.

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: GetExcelRange wrong return
Posted: Fri Aug 21, 2020 06:10 AM

By default, it will select
oSheet:UsedRange.

And UsedRange includes any cells the user has used even for formatting even if does not have any data.

If you want to read only specific range, then you can specify the range explicitly in the function in the 3rd parameter

Regards

G. N. Rao.

Hyderabad, India

dutch

Posts: 1598

Joined: Fri Oct 07, 2005 05:56 PM

Re: GetExcelRange wrong return
Posted: Fri Aug 21, 2020 07:15 AM

Thank you so much, I got it.
Dutch

Regards,

Dutch

FWH 2304 / xHarbour Simplex 1.2.3 / BCC73 / Pelles C / UEStudio

FWPPC 10.02 / Harbour for PPC (FTDN)

ADS V.9 / MySql / MariaDB

R&R 12 Infinity / Crystal Report XI R2

(Thailand)

FiveTech Support Forums

Continue the discussion