QAxObject and Excel

JonB

@Ketan__Patel__0011 said in QAxObject and Excel:

Actually want Solution for Excel file Reading using ActiveX Then i Will Drop the solution for it

Even if he does want only ActiveX, do not drop your SQL/ODBC solution here! It is a very useful alternative way of going about things, depending on what is wanted. Even if it is not right for this user, it is useful to read for others coming to this topic :)

Ketan__Patel__0011

@JonB

So Should I Delete My Post ?

JonB

@Ketan__Patel__0011
Noooo!!! Not at all, I am saying your post is very useful. Maybe not to this OP, but potentially anyway to others. It is a good post :)

ODБOï

hi
@Ketan__Patel__0011 said in QAxObject and Excel:

So Should I Delete My Post ?

No, don't delete, i belive the OP is able to chose the right solution for what he needs

Ketan__Patel__0011

@LeLev

Okay i will Restore The Post

Sorry To Say But What Is Meaning Of

@LeLev said in QAxObject and Excel:

OP
?

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.