psipsi
3rd August 2007, 09:11
Sorry for my bad english.
I need to read the information in a excel and then show it in a little screem (with the QMessageBox for example).
If it's posible, can you give me an example?
I found this here but I don't know how to read the information of a line and a certain column.
Thank you.
//Create connection, add workbook und sheet
QAxObject* excel = new QAxObject("Excel.Application", 0);
QAxObject* app = excel->querySubObject("Application()");
QAxObject* wbks = excel->querySubObject("Workbooks()");
QAxObject* wb = wbks->querySubObject("Add()");
QAxObject* ws = wb->querySubObject("Worksheets(int)", 1 );
//Show Excel
app->setProperty("Visible", true );
I need to read the information in a excel and then show it in a little screem (with the QMessageBox for example).
If it's posible, can you give me an example?
I found this here but I don't know how to read the information of a line and a certain column.
Thank you.
//Create connection, add workbook und sheet
QAxObject* excel = new QAxObject("Excel.Application", 0);
QAxObject* app = excel->querySubObject("Application()");
QAxObject* wbks = excel->querySubObject("Workbooks()");
QAxObject* wb = wbks->querySubObject("Add()");
QAxObject* ws = wb->querySubObject("Worksheets(int)", 1 );
//Show Excel
app->setProperty("Visible", true );