[Solved] Get errors when exporting data to CSV files

[LeeMinh]

I am writing a small application to export data to CSV files. And this is the code that I used

@
QString fileName = QFileDialog::getSaveFileName(
this,
tr("Save As"),
"",
tr("Comma Separated Values (.csv);;All Files (.*)"));

if (fileName.isEmpty()) return;
else {
QFile file(fileName);
if (!file.open(QIODevice::WriteOnly)) {
QMessageBox::information(this, tr("Unable to open file"), file.errorString());
return;
}

// Write content to *.csv file
QTextStream stream(&file);

// Print header
stream << "ID\tUsername\tAddress";

stream.flush();
file.close();
}
@

Then I run the application, a dialog appears to save CSV file. But when I open the CSV file that I have just saved, I got 2 following error warnings

!http://i.stack.imgur.com/pt0vJ.png(Error 1)!

and

!http://i.stack.imgur.com/JQF1w.png(Error 2)!

This is the data in the CSV file

!http://i.stack.imgur.com/vbHXY.png(The data in CSV file)!

As you see, I intend to display 3 fields such as ID, Username and Address in 3 columns but all data is in a column.

Could you explain me that why I got 2 above messages and how can I display each field (ID, Username and Address) in each column?

Thanks in advance!

P/S: Currently I am using Microsoft Excel 2013.

[thEClaw]

Step one: Don't be afraid to use a text editor (the really old one) to take a look into the file yourself. You'll see first hand if everything is fine in there, or at least "as intended".

Step two: When importing a csv-file, you have to give some settings - e.g. the field delimiter, which not necessarily has to be a tab (\t)!

I think you are just using a bad format here. I would try something like this, because that's how I know it:
@stream << ""ID";"Username";"Address"";@

[LeeMinh]

@thEClaw: Thanks for your help! Now I can solve my issues. I am very happy!