Excel using Qt

[nmn]

Hi all,
I am new to Qt like the man !
how to read and write in excel file using Qt? How
the opensource do it ?and how's commercial?
I 'am no time on it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
can you give me an example!
The god bless you all!!!!
ningminna@126.com

[jpn]

What have you tried so far? Have you examined how do Excel formats look like?

[whitefurrows]

Hi,

you have many possibility, you can use QAxObject:

//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 );

//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 );

To copy to clipboard, switch view to plain text mode 

or generate a C++ namespace with the dumpcpp tool

Excel::Application* app = new Excel::Application;
wbk = app->Workbooks()->Add();
app->SetVisible(true);

Excel::Application* app = new Excel::Application;
wbk = app->Workbooks()->Add();
app->SetVisible(true);

To copy to clipboard, switch view to plain text mode 

or take a look to QExcel Converter SQL

but i think you can do all this things only with the commercial qt version

[nmn]

Hi,

you have many possibility, you can use QAxObject:

//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 );

//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 );

To copy to clipboard, switch view to plain text mode 

or generate a C++ namespace with the dumpcpp tool

Excel::Application* app = new Excel::Application;
wbk = app->Workbooks()->Add();
app->SetVisible(true);

Excel::Application* app = new Excel::Application;
wbk = app->Workbooks()->Add();
app->SetVisible(true);

To copy to clipboard, switch view to plain text mode 

or take a look to QExcel Converter SQL

but i think you can do all this things only with the commercial qt version

Dear sir :
I have see it .Thank you very much for your help.
How can I Read \Write Excel File !

With my best regards!