Opening a MS Excel file to view from Qt Application

[nagabathula]

Hello every one.. I am working on a Qt application where i write some data to a Excel file , now i have given a option in Toolbar to view the excel file to which i have written data into. I tried many things looking at the forums but it din help the excel file does not open.

i did the following but does't open up a Excel.

QProcess *process = new QProcess(this);
    QString program = "msexcel.exe";
    QString folder = "E:/DataReceiver Excel Log/Mon 20-06-2011, 09.01.xls";
    process->start(program, QStringList() << folder);

QProcess *process = new QProcess(this);
    QString program = "msexcel.exe";
    QString folder = "E:/DataReceiver Excel Log/Mon 20-06-2011, 09.01.xls";
    process->start(program, QStringList() << folder);

To copy to clipboard, switch view to plain text mode 

QString folder = "E:/DataReceiver Excel Log/Mon 20-06-2011, 09.01.xls";
    process->start(newfilename, QStringList() << "");

QString folder = "E:/DataReceiver Excel Log/Mon 20-06-2011, 09.01.xls";
    process->start(newfilename, QStringList() << "");

To copy to clipboard, switch view to plain text mode 

QDesktopServices::openUrl(QUrl(tr(newfilename)));
   if(!QDesktopServices::openUrl(url)) {
    excelview.load(url);
    excelview.showMaximized();
}

QDesktopServices::openUrl(QUrl(tr(newfilename)));
   if(!QDesktopServices::openUrl(url)) {
    excelview.load(url);
    excelview.showMaximized();
}

To copy to clipboard, switch view to plain text mode 

none of the three above methods worked.. What is it wrong that i am doing. ?

Thank you

[nagabathula]

hello some one knows what i might be doing wrong here. ? Not able to figure out whats wrong .

thank you

[Talei]

1st snippet:
error in program path

QString program = "msexcel.exe";

QString program = "msexcel.exe";

To copy to clipboard, switch view to plain text mode 

that's mean msexcel.exe is located either in Your program directory or within Path windows variable. Use full path i.e "c:/path/to/excel.exe"

3rd snippet:
error in

QDesktopServices::openUrl(QUrl(tr(newfilename)));

QDesktopServices::openUrl(QUrl(tr(newfilename)));

To copy to clipboard, switch view to plain text mode 

should be:

QDesktopServices::openUrl(QUrl(tr(newfilename.toAscii())));

QDesktopServices::openUrl(QUrl(tr(newfilename.toAscii())));

To copy to clipboard, switch view to plain text mode 

don't use tr() (it's function for string translation into other languages, i.e english->polish, and file path is international as it is )

try:

QString newfilename = "C:/path/to/file.xls";
    QDesktopServices::openUrl(QUrl(newfilename.prepend( "file:///" )));

QString newfilename = "C:/path/to/file.xls";
    QDesktopServices::openUrl(QUrl(newfilename.prepend( "file:///" )));

To copy to clipboard, switch view to plain text mode