FiveTech Software tech support forums

There is no problem to be resolved.
We just need to be aware of the differences of behavior between VB vs. (x)Harbour and write our code accordingly.
Please use the sample code I provided above and that works well

Wish all friends Merry Christmas and Happy and Prosperous New Year

Hi Rao,

Thank you. However, this XLS has 494 columns and about 23,000 rows. I am looking to start reading row 2 and only retrieve about 80 columns of data so I can upload to SQL. Is there a way to read data row by row like below?

cValue01 := oSheet:Cells( nCurrentXlsRow, 2 ):Value
cValue02 ...

Recommendations while using very large xlsx files:
In such cases, most of the times, we won't be interested in reading and browsing the entire table, but only extracting limited information required.
We may adopt this approach:
oXl := FW_OpenXlsx( cFileXlsx, [cSheet] )
? oXl:nRows, oXl:nCols
aData ...

Next version of FWH under release enable reading, modifying and also saving the changes (to another xlsx file) without Excel or ACE OLEDB installed on the PC.

Simple Usage:
FW_ShowXLSX( cFileXlsx, [cSheet] ) // --> oXlsx object

Examples:
FW_ShowXLSX( "customer.xlsx" )
https://imagizer ...

Wonderful

Investigando, un poco, se podría usar TaskDialog del API de Windows (ChatGPT), y pasandolo a Harbour:

Thanks

This is my personal opinion.
The conversion should not be difficult for those who already has been programming in both Harbour and xHarbour. Mr. Otto is one of them.

We know FWH software is written to work with both Harbour and xHarbour providing identical functionality with either compiler. It has ...

#include "fivewin.ch"

function Main()

local aData, aclr := { "AR", "AB", "AC", "AO" }

aData := {{"Homers","Springfield",50,"AB"},;
{"Ceci", "Miami", 28,"AC"},;
{"Reg", "Scottsdale", 43,"AO"},;
{"David", "Hingham", 34,"AR"},;
{"Hugh", "Tarzana", 89,"AB"} }

XBROWSER aData SETUP ( ;
oBrw ...

Silvio.Falconi wrote::nRowHeight := your number

yes

We are working on a new function
FW_ShowXLSX( cFileXlsx )
This is still needs to be finalized.

No libraries, drivers or OleDB providers are required.
This function directly reads from the xlsx file and extracts the data.
So this is guaranteed to work on an computer.

Example out put:
https ...

I tried
oRs := FW_OpenADOExcelSheet( cSource, "Sheet1", "A1:SB65000", .T. )

And got the following errors
1. ADO ERROR UNKNOWN
2. Fail to open "XLS path + filename.XLSX"

By default, Microsoft Jet OLEDB is installed on every PC.
This default Jet OLEDB can open only "xls" files but not "xlsx ...

Try opening an xlsx file with

CREATING XLSX FILES WITHOUT USING EXCEL APPLICATION.

They are for creating only. Not for reading

#include "FiveWin.ch"

FUNCTION Main()

LOCAL oDlg
local aClrGrad[ 3 ]

aClrGrad[ 1 ] := { { 0.5, CLR_GREEN, CLR_HGREEN }, { 0.5, CLR_HGREEN, CLR_YELLOW }, "RING" }
aClrGrad[ 2 ] := { { 0.5, CLR_RED, CLR_HRED }, { 0.5, CLR_HRED, CLR_YELLOW }, "RING" }
aClrGrad[ 3 ] := { { 0.5, CLR_BLUE, CLR ...