QAxObject and Excel

JonB

@Ketan__Patel__0011
I didn't see you had actually deleted your useful post! Yes, please do restore it!

OP == "Original Poster", the person who starts a thread.

ODБOï

@Ketan__Patel__0011 the person who created this thread, (Original Poster )

Ketan__Patel__0011

@LeLev

Okay i got it Thank You

Ketan__Patel__0011

@JonB

I Restored it

Morteza_Mahmoudi

@Ketan__Patel__0011 I agree with you. AxObject is very slow especially in Save Data.

Ketan__Patel__0011

@Morteza_Mahmoudi

Happy To Help

Koru

Is it possible to get the cell's address using SQL/ODBC? I can get the column easily from

QSqlQuery::value

but how to obtain the row's number?

JonB

@Koru I don't follow, could you give an example of what query you issue, how you get a column number and what you want to get for a row number?

Koru

@JonB, the query is actually irrelevant, I just need to get the cell's address. I have an application that validates columns and lists cells that have wrong values. The validation result is the address and a failure message so the user knows exactly where the error occurs and what has to be fixed directly in a checked file.
SQL/ODBC queries compare columns faster than QAxObjects, but results lack addresses. The addresses don't have to be in an Excel manner like A12 etc., it can be a row/column number from the sheet.